T-SQL Tuesday #131–An Analogy

This month the T-SQL Tuesday invitation is from Rob Volk, the last of the crew that I pushed to host last year at a SQL Saturday. I managed to...

T-SQL Tuesday 131: Data Analogies, or: Explain Databases Like I’m Five!

This month’s TSQL2sday is hosted by one of my favorite presenters, Rob Volk. His challenge for us is to use analogies and explain a database concept like you would...

QDS Forced Plans - Gotchas and Limitations

Released with SQL Server 2016, Query Data Store was a game changer for performance tuning. Right from Microsoft’s website: The SQL Server Query Store feature provides you with...

Most Costly Statement in a Stored Procedure

A lot of stored procedures have multiple statements and determining the most costly statement in a given proc is a very common task. After all, you want to focus...

Renaming SQL Server Databases

Video walkthrough of renaming or “flipping” databases to minimize down time during a refresh.  Most commonly when moving a copy from prod to dev. My Pluralsight courses for new...

Daily Coping 12 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Create HyperV VMs for Database server - Part 9

Setup Windows Server 2019 Domain Controller - Part 8

Recording Sessions for the Virtual Summit

A week ago the SQL Bits conference took place in London, sort of. The event was virtual, but it was held during the London timezone, which makes sense as...

Daily Coping 9 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...