Advent of Code 2018 – Day 1 (Chronal Calibration)

Advent of Code
This guy by the name of Eric Wastl (t) created this neat web site called “Advent of Code“....

Epic Life Quest – looking back

This will be my last post for the year. In this am going to look back on goals I set...

Getting SQL Services, Starting, Stopping and Restarting them with dbatools

There was a question in the #dbatools slack channel 

Getting dbatools
dbatools enables you to administer SQL Server with PowerShell. To get...

Overview of DML Operations – SQL Delete

This article on the SQL Delete is a part of the SQL essential series on key statements, functions and operations...

Query Store and Plan Cache Plans Compared

Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...

Running SQL Server with Docker on the Mac

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

SHUTDOWN SQL Server

I explore the question of if it is possible to reboot the server from within SQL Server or even simply shut down the entire server. Well, you can certainly...

SQL Homework – December 2018 – Configure SSMS

I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...

Three tips to help your database team avoid burn out this holiday season

As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of...

Three tips to help your database team avoid burn out this holiday season

As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of the busiest and most stressful times of the year...