It turns out I was doing this all wrong for months. For the longest time, I’ve been checking my SQL Server instances to see what needs patching with Test-DbaBuild from the dbatools PowerShell module. But the result was always the same – it never returned a Service Pack or Cumulative Update target. I glossed over…

Read More Checking for SQL Server Updates with dbatools

Settle in folks, this is a long, rambling post. As this goes live, it’s been about three weeks since my abrupt switch from driving to the office every day to working from home full-time. This shift happened at the same time my kids had school cancelled, and our lives got flipped, turned upside down. So…

Read More COVID-19 – Work & Life Changes, How We’re Coping

This tripped me up a few weeks ago, but once I stopped and thought about for a moment it made total sense. I was trying to copy some data into a temp table and got an error I’d never encountered before. Column, parameter, or variable #1: Cannot find data type MyStringType. What’s that all about? Let’s find out.

Read More User Defined Types and Temp Tables Gotcha