Two Words For Faster Scalar Functions

Watch this week’s episode on YouTube.WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005.  So why...

Two Words For Faster Scalar Functions

Watch this week's video on YouTube
WITH SCHEMABINDING optimizations were added all the way back in SQL Server 2005.  So why bother talking about them in 2018?
Because no one is...

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...