#SQLPASS #Summit14 Day 2 Keynote Highlights !

This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day...

Let’s get started

Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to...

Last Weeks Top “Reading” Links #108

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow...

Expected Variables–T-SQL Testing

After I wrote about creating tables that contain the results I expected, I wondered if I could do the same...

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. Click Configure Security, Configure Database Mirroring Security...

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....