Wayne Sheffield

My blog about SQL Server

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

Exploring how a parent-child relationship was implemented by a third-party software vendor improperly.

The Richmond SQL Server User Group, located in Richmond, VA, is looking for speakers for the 2019 calendar year. Due to limited bandwidth at our venue, we prefer in-person presenters. We currently have openings for the following dates (meetings start at 6:30pm): January 10, 2019 February 14, 2019 May 9, 2019 June 13, 2019 July […]

A wrapup of TSQL-Tuesday #105, where we talked about overcoming brick walls

%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