An Introduction to SQL Server 2016 Query Store

By David Postlethwaite

David is delivering a talk An Introduction to SQL Server Query Store at SQL Saturday Iceland today - this...

SQL Bits in less than a month

I’m getting excited, and you should as well. Join me at a fantastic conference in the UK this spring. Register...

Schedulers To Rule Them All

Sometimes things just don’t make sense.
One of our production servers has 4×8 (4 sockets, 8 core) processors with hyper threading enabled.  This...

SQL Server: DBCC CHECKDB Command with Complete Explanation

SQL Server is used widely for the management of database. It is possible that the data gets corrupt due to...

When NOLOCK LOCKS!

This is hardly breaking news, but it’s important to know: when using NOLOCK table hints in SQL Server, it can...

PASS Excel BI VC: Improvements to Excel Pivot Table

Please join the PASS Excel Business Intelligence Virtual Group onn March 22nd 11AM Eastern for Microsoft’s Program manager Alexander Lahuerta....

Friday Reading 2017-03-17

As this is being posted I’m on my way up to Dublin Airport to catch my flight to Iceland ready...

Global v Session Trace Flags

I wrote a short article on enabling and disabling trace flags. You can read it, but I didn’t really discuss...

Check Those Settings

Recently, I was tasked with “enhancing” a third party application.  This third party application (TPA) outputs a bunch of files...

Compressed backup errors and TF 3042

Compressing your backups has very few downsides. It’s usually faster (the additional time for compression is less than the time...