Add Witness to Existing SQL Server Database Mirroring

1. After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2....

Monitoring BI Performance: Scripts and Slides

I recently did a presentation and discussed some techniques for monitoring the performance of your business intelligence stack. I will be doing...

How to pause execution for particular time or interval ? TIP #71

 
Suppose, We are working on a stored procedure in which some complex operation is going. We are fetching some value...

SQL PASS 2014 Summit Diary – Day 6

Today is the last official day of the PASS Summit.  The sessions will wrap up at the end of the...

Working with Very Large Tables Like a Pro in SQL Server 2014

I presented my session – Working with Very Large Tables Like a Pro in SQL Server 2014 – in PASS Summit 2014....

PASS Summit: Blogger Q&A with Board of Directors Executive Committee

On Thursday, I was invited as a blogger to attend an intimate conversation (Q&A) with the PASS Board of Directors:...

Determine size of the file using T-SQL/Powershell/Ole Objects

There are many ways to find the filesize.
This post is all about identifing the filesize using T-SQL,Instantiating OLE Objects and...

How to find all running SQL Server Instance on a machine ? TIP #70

Hello friends,

Many times it happened with me I forgot the instance name of SQL Server.

So here is a small trick...

Summit 2014 – Next Impressions

As Summit 2014 begins to wind down, it is time for some more impressions from the week.  The week has been good so far.  It has been very busy...

Summit 2014 – Next Impressions

As Summit 2014 begins to wind down, it is time for some more impressions from the week.  The week has...