Wayne Sheffield

My blog about SQL Server

In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among other jobs that this entails, this also means that I am working with SQLSaturday SpeedPASSes. SpeedPASS History According to the SQLSaturday FAQ, the SpeedPASS is your admission ticket to a SQL Saturday event. It contains a name badge, admission ticket, lunch […]

Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let’s look into the performance gains this offers.

SQL Server 2019 introduces Scalar UDF Inlining, which is supposed to improve the performance of Scalar UDFs. This post investigates this new feature.

In this T-SQL Tuesday post, I answer Andy Leonards question of “Why do you do what you do”? It comes down to I automate what I can so that I can be lazy.

SQL Server 2017 has enhanced the security requirements for using CLRs. Read on to see what I ran into, and how I was able to get CLRs to work!

From a DBA’s perspective, automation is something that is absolutely necessary. This post shows just a few areas where I use automation in my life.

Influence Somebody Ahh, December. What a wonderful time. Snow all around (many along the eastern seaboard of the United States were hit Sunday by a snowstorm… I had 7″ of that wonderful white flakey stuff myself). There’s a holiday for everyone, whether it’s Christmas, Hanukkah, Kwanzaa, Boxing Day, or something else. Offices are throwing parties […]

Next,  Advent of Code 2018 – Day 6 As I explained in a recent post, I’m participating in this year’s Advent of Code challenge, with the twist of doing the challenges in T-SQL. In case you don’t know what “Advent of Code” is, Eric Wastl (t) created it for the purpose of, as Eric describes […]

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a physical tally table.

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a recursive case-sensitive string replacement.

%d bloggers like this:

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close