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

This is one of several posts on modernizing T-SQL code with new features and functionality available in SQL Server. Last year, you finally retired the last of your SQL Server 2008R2 instances. Congratulations! But are you taking advantage of everything that your new instances have to offer? Unless you did a review of all of…

Read More Modernizing Your T-SQL: The Sequence Object

This month, Jess Pomfret (blog | twitter) is trying to beat the winter motivation slump by exploring, and asking us to share, our lifehacks that make daily life a little easier. I’ll admit, this post was kind of difficult for me to build as these are things that I don’t put a lot of thought…

Read More T-SQL Tuesday #123: Lifehacks to Make Your Day Easier