Data Compression in SQL Server – Pros and Cons

SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...

Getting your Cloud on

One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that...

Wait Types and Latch Classes Library

Great news from SQLSkills.”Announcing the comprehensive SQL Server Wait Types and Latch Classes Library” – Paul S. Randal http://www.sqlskills.com/blogs/paul/announcing-the-comprehensive-sql-server-wait-types-and-latch-classes-library/ It has...

A Day In The Life of a SQLBits Volunteer

So SQLBits has finished for another year. About 1500 people registered for the largest SQL Conference in Europe held over...

SQL Server : Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=10.0.0.0

I have recently experienced an issue with a third-party  backup application (Commvault) that was trying to backup the databases from...

SQL Server Command Timeout – Application Timeout – Attention

When you use ODBC or SqlClient to access data from SQL Server, by default the query will be cancelled if there is no response from the server within a...

Common uses of stored Procedure sp_MSforeachtable

We will get the brief idea about undocumented procedure sp_MSforeachtable of the Master database.

sp_MSforeachtable can be used to loop through all...

Monday Morning SQL Break – May 9, 2016

It’s Monday morning (er afternoon) and it’s time for this week’s blog and twitter round-up for last week. If you...

Events I Wish PASS Organized

I was talking a bit with a friend at SQLSaturday Jacksonville and realized I needed to write down a thought...

Notes From SQLSaturday Jacksonville 2016

Everything ran smooth The site reminds me of Orlando – limited space for sponsors, but offset by the other advantages (free...