DBCC CLONEDATABASE and sensitive data

Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is a new DBCC command, DBCC CLONEDATABASE. As the name suggest this command can be used to make a clone of your user database without the table data. Instead it creates a schema and statistics only […]

Talking about the Query Store at SQLBits!


From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will be in Liverpool promising four days of great SQL Server sessions and training. Just take a look at the agenda to be blown away by the amount of content. I am very proud to announce […]

SQL Server Management Studio Preview

You may have heard that SQL Server Management Studio (SSMS) is now available as a stand-alone installation package outside of the SQL Server setup (as a preview version). With the release of SQL Server 2016 RC0, Microsoft decided to cut the cords with SQL Server Management Studio as it has been removed from the SQL […]

Session Based Wait Statistics in SQL Server 2016

As you probably know I am very fond of SQL Server Wait Statistics (shameless book link) and the options they provide for analyzing SQL Server performance. During SQL Server version releases new options became available to monitor and/or analyze Wait Statistics but one option for Wait Statistics analysis was still missing, the ability to monitor […]

Pro SQL Server Wait Statistics available now!

Remember that blog post from April this year that I announced working on my first ever SQL Server related book “Pro SQL Server Wait Statistics”? Well good news, it is available now! Pro SQL Server Wait Statistics is available in a variety of different formats, including ePub, Kindle and paperback so there is always a […]