My popular Wait Stats and Queues script, now updated for SQL Server 2016. It works on 2008, 2012 and 2014 too and helps you identify resource bottlenecks.
SQL SERVER – SSMS Enhancement – Databases Node Filter Capability
A client with 86 databases struggled to find one in Object Explorer. A newer SSMS Enhancement lets you filter the Databases node. Here is how it works.
How to Get Started with SQL Server 2016? – Interview Question of the Week #086
A candidate asked me in an interview: how do I get started with SQL Server 2016? Here is my answer for anyone who has not tried it yet.
Install SQL Server 2016 Sample Database WideWorldImporters – SQL in Sixty Seconds #081
WideWorldImporters is the new sample database for SQL Server 2016. This SQL in Sixty Seconds video shows how to download and install it quickly.
Install SQL Server Management Studio 2016 – SQL in Sixty Seconds #080
SSMS no longer ships with SQL Server 2016 setup. In this SQL in Sixty Seconds video I show how to install SQL Server Management Studio 2016 on its own.
SQL SERVER 2016 – Learn Installation of SQL Server 2016 in 2 Minutes Video
Every time when new SQL Server version arrives, lots of people want to install it. Let us learn installation of SQL Server 2016 today.
SQL SERVER 2016 – Encrypt Your PII Data – Notes from the Field #132
Mike Lawell found a client storing personal information in clear text. He explains how SQL Server 2016 encryption options can protect your PII data.