Wayne Sheffield

My blog about SQL Server

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.

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a virtual tally table and getting data from prior rows.

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

A T-SQL approach to solving the 2018 “Advent of Code” programming challenge. This solution includes a running total calculation and duplicating a result set