SQL Server: Performance Tuning :Understanding Set Statistics IO output

Performance tuning is one of the important task of DBA. Many times people comes to us with different types of...

Understanding Contained Database in SQL Server 2012

SQL Server 2012 supports contained databases and partially contained databases, which provide a high degree of isolation from the database...

A Vacation and Traveling to Sacramento

I’ve got a couple days off, starting today after my webinar on Preparing for When Disaster Strikes. I’ve got some...

Are You the Primary Replica?

UPDATED -- Jul 3, 2015 -- To verify database exists, per comments by Konstantinos Katsoridis. Thanks for finding the bug!

In my recent adventures...

Gap issue in SQL Server 2012 IDENTITY column

Found a gap issue when using IDENTITY column in SQL Server 2012, every time I restarted sql server service, the current...

I Learned Something From You

I learned something from you – that was something someone said to me at the end of a recent consulting engagement....

Moving Files with Open Source Software, cURL and winSCP

Open Source, ON WINDOWS! I’m still stunned in this day and age that people pay obscene amounts of money on tools that are easily replaced in most cases with...

Moving Files with Open Source Software, cURL and winSCP

Open Source, ON WINDOWS!
I’m still stunned in this day and age that people pay obscene amounts of money on tools...

Query to Find "Update" Dependencies on a Table or View (SQL Server 2012)

The built-in dependency finder in SQL Server Management Studio does not provide the ability to distinguish between dependencies that are...

SQL Server : Understanding Differential Change Map (DCM) Page and Differential Backups

In our earlier posts, we have discussed about different types of pages.Data Pages, GAM and SGAM,PFS page and IAM page. In this...