How to Login to SQL Server with NT AUTHORITYSYSTEM using PSExec Tool

PSExec tool gives you an option to run a remote process or an application using System account, if SYSTEM account has permission on that application. Although there are many more features that are  For example, if SQL Server has NT AUTHORITY\SYSTEM as one of its logins, then you can use this account to login to…

3

How to limit connections to SQL Server until all databases are ONLINE!

Strange requirement, right? Recently, I got a peculiar case wherein the demand made by the customer was to make sure no application should be able to connect to SQL Server unless and until all the databases are ONLINE. The business requirement of this company was to have all databases online before any of their ten…

8

Why to look at "Wait Statistics" to troubleshoot SQL Performance

Here we will discuss on Waits in the context of SQL Server: Highlights of this video blog :- 1. What is wait and why we need to focus on wait? 2. Lifecycle of a session 3. Analogy to explain waits 4. Types of Waits. 5. Where to see waits in SQL Server 6. Demo To…

4

SQL server 2008 Filestream

Filestream is a  new feature in SQL server 2008, that allows storage and efficient access to BLOB data, using combination of SQL Server 2008 and NTFS file system. It provides  an easy way of handling BLOB data with database transactional consistency, integrated management, security and excellent streaming performance. It basically maintains transactional consistency between the…

2

Troubleshooting SQL server High CPU : Part 2

In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it. Possible causes that can lead to high CPU usage by SQL server:- 1.Inefficient Query Plans 2. Intra- query Parallelism 3. Excessive Cache look up time To watch the video in better…

1

Troubleshooting SQL server High CPU : Part 1

In this blog we have explained the various causes for SQL to drive the processors i.e. high CPU and the steps to troubleshoot it. Possible causes that can lead to high CPU usage by SQL server:- 1.Inefficient Query Plans 2. Intra- query Parallelism 3. Excessive Cache look up time To watch the video in better…

1

Product Update Feature in SQL Server 2012

A new feature introduced in SQL Server 2012 setup is “Product Update”. Product Update searches for the latest product updates and integrates it with the main product installation.It can search for the latest or applicable updates in Microsoft Update,Windows Server Update Services (WSUS), a local folder or a network share. Product Update can pull in…

0

Introduction to Sparse Columns

In this video blog we would walk you through a feature introduced from SQL server 2008 i.e. Sparse Columns.    Sparse columns are just an ordinary columns that have an optimized storage for null values.    It reduces the space requirements for null values at the cost of more overhead to retrieve non null values….

0

High Availability for SQL Server Replication using Database Mirroring

Here we will Discuss on Providing High Availability for SQL Server Transactional Replictaion using Database Mirroring : Highlights of this video blog :- 1. Transactional Replication Overview. 2. Database Mirroring Overview 3. Replication with Database Mirroring. 4. Mirroring the Publication database 5. Effect of the Mirroring state on the Replication Log Reader agent. 6. Mirroring…

3

Missing MSI’s/MSP’s error during SQL Server Patching

In this video blog, we would walk you through  some tips and methods to troubleshoot Missing MSI’s/MSP’s error during SQL Server Patching or installation. Highlights of this video blog :- 1. What are MSI’s/MSP’s 2. Location of Setup logs and log file names 3. Fixing missing MSI’s and MSP’s error :      E.g.  Unable to…

3