SQL Master

Imagine a situation when you are working on a query for couple of hours and suddenly your management studio is crashed or your PC is restart...

In SQL Server 2012 Microsoft did lot of enhancements in SSIS, especially by introducing the “ Project Deployment Model ”.  After this so ma...

Today I’m going to show you how to write a PIVOT query when column names are dynamic.  A dynamic pivot is very necessary when you don’t know...

Let me show you 2 simple queries to find the row count of all the tables in a Database. Some time back I shared a trick to quickly find th...

Recently I was working on creating a custom dashboard to monitor the health of all the database servers.  One thing I wanted to add to the d...