Daily Coping 19 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...

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

SQLSaturday #1000! Join Oregon Virtually this Saturday

Honored to be a part of not just SQLSaturday #1000, but the long proud history of the free community series of SQLSaturdays celebrating their 1000th+ event. (I spoke at...

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

Configure Windows Server 2019 Multi-Subnet Cluster - Part 11

Daily Coping 16 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...

Install SQL Server 2019 - Part 10

Publish Database Fails – Script File could not be found

A small blog post for anyone who stumbles across this issue (and for my future self, should I forget the solution). I was working on some tables in SSDT...

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

Write It Down!

Recently I set up a new process to pull data out of a MySQL database and into SQL Server. Pretty standard ETL stuff, but it’s the organization’s first time...