As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016. There is however one feature I dearly miss, the ability to customize or build reports underneath the Query Store folder in SQL Server Management Studio. Even though the built-in reports are pretty decent for seeing […]
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 […]
In the previous article in this blog series I told you my plans of expending my horizons towards the Data Science field. As I noted in that article my first steps towards Data Science consists of getting my math knowledge up-to-date again on math areas like linear algebra and matrices. The first thing to note […]
As an IT professional we are used to spending a lot of time learning about new technologies or how we can improve our knowledge on the products we work with. For more than 10 years now I have been working with SQL Server and still continue to learn new things about the product daily. However, […]
In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine in SQL Server 2016. Even though these performance enhancements don’t get as much attention as the big new features introduced in SQL Server 2016 (like Query Store), they can play a massive role in the […]
With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS, the Plan Comparison Tool. Like the name suggests, the tool makes it possible for you to compare different plans inside SSMS, but it doesn’t stop there. Microsoft also managed to squeeze in some optimizations for […]
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 […]
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 […]
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 […]