I’m Speaking At SQL Saturday Richmond

I am so excited, I was selected to speak at SQL Saturday Richmond on March 24, 2018, in Richmond, Virginia.
SQL...

Lessons Learned From SQL Saturday Cleveland

I can finally breath a sigh of relief, my first time of presenting two sessions back to back is finally...

Waiting Tasks Reveal Pain Points

Waiting tasks quickly shows you where to look for the bottlenecks. This is only one of the many times that I...

“How do I contribute to dbatools?” with Drew Furgiuele

This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the...

"How do I contribute to dbatools?" with Drew Furgiuele

Watch this week's video on YouTube
This weekend I caught up with Drew Furgiuele at SQL Saturday Cleveland and learned how to get involved with the open-source dbatools PowerShell module.
If...

Bug in SSMS V17.4

 
If you are using SSMS V17.4 as I am

You may encounter a weird error. This can be repeated as follows:
Open...

Learning Goals–January Review

In December I participated in T-SQL Tuesday #97 and wrote a post about 2018 goals. I promptly spent two weeks...

Wait Statistics on a Query

Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...

SQL Homework – February 2018 – Work with security

This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts

Create a SQL login and a Windows authenticated login....

Forensic Analysis of Log files in SQL Server

The Importance of Log Files in SQL Server
On the SQL server every day we perform many transactions and as we...