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

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 I’d like to take a minute, just sit right there, and I’ll tell you how I…am dealing with all this.

Continue reading “COVID-19 – Work & Life Changes, How We’re Coping”

User Defined Types and Temp Tables Gotcha

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.

Continue reading “User Defined Types and Temp Tables Gotcha”

Modernizing Your T-SQL: Trimming Strings

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 the T-SQL in your applications, I’m guessing not.

This one seems pretty basic, but it’s got a trick up its sleeve – the TRIM() function.

Continue reading “Modernizing Your T-SQL: Trimming Strings”

Modernizing Your T-SQL: The Sequence Object

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 the T-SQL in your applications, I’m guessing not.

Let’s take a look at the SEQUENCE object, introduced with SQL Server 2012.

Continue reading “Modernizing Your T-SQL: The Sequence Object”

Appearance: Data Bits #2

Last week (as I write this), Kevin Hill (blog | twitter) released the first episode of his new podcast Data Bits. I enjoyed listening to it and said “hey bud, if you need a guest sometime down the line, give me a shout!”

Well, “sometime down the line” turned out to be just a few days, and we recorded on the evening of March 4th amid a little craziness in both our houses. I always enjoy catching up with Kevin and our hour-long conversation could easily have been three or four. We talked tech, not tech, career stuff, and of course #SQLFamily.

Check out Data Bits Episode #2

Does dbatools Have a Function for That?

dbatools has a lot of functions. A lot. Over 550. There is a great command index on the website, and the documentation gets updated every time a new version is published. But sometimes, it feels like you can’t find what you need unless you already know the name of the thing you’re looking for. Other times, you might start writing your own wrapper around dbatools functions, or maybe start a new function from scratch, because it seems like the functionality you need isn’t there.

Continue reading “Does dbatools Have a Function for That?”

Modernizing Your T-SQL: String Aggregation

This is another in a group of several posts on modernizing T-SQL code with new features and functionality available in SQL Server.

SQL Server 2016 gave us the STRING_SPLIT() function, but what about the reverse – compiling a set of values into one delimited string? We only had to wait 15 months for the release of SQL Server 2017, and the STRING_AGG() function.

Continue reading “Modernizing Your T-SQL: String Aggregation”