Advent of Code 2018 – Day 5 (Alchemical Reduction)

A T-SQL approach to solving the 2018 "Advent of Code" programming challenge. This solution includes a recursive case-sensitive string replacement.
The post Advent of Code 2018 – Day 5 (Alchemical...

Advent of Code 2018 – Day 4 (Repose Record)

Advent of Code 2018 – Day 4
As I explained in a recent post, I’m participating in this year’s Advent of Code...

Advent of Code 2018 – Day 2 (Inventory Management)

Advent of Code 2018 – Day 2
As I explained in yesterday’s post, I’m participating in this year’s Advent of Code challenge,...

Advent of Code 2018 – Day 1 (Chronal Calibration)

Advent of Code
This guy by the name of Eric Wastl (t) created this neat web site called “Advent of Code“....

What were you thinking (hidden relationship)???

What were you thinking?
Have you ever been working on some code from another person, and you end up scratching your...

Speakers wanted for Richmond (VA) SQL Server Users Group – 2019

The Richmond SQL Server User Group, located in Richmond, VA, is looking for speakers for the 2019 calendar year. Due...

TSQL Tuesday #105: WrapUp

When I hosted this past TSQL-Tuesday, I fully expected to have the wrap-up done a few days later. Lots of...

T-SQL Tuesday #105 Invitation: Brick Wall

It’s time for another T-SQL Tuesday. The brainchild of Adam Machanic (b|l|t), and designed to strengthen the SQL Server blogging...

Does a Primary Key always have stats_id 1?

Back to the SQL Server Basics with Wayne

The Myth
I recently was attending a presentation where the presenter stated that the...

SSMS reset window layout (Day 37)

SSMS is a wonderful tool. You can drag Windows around, grouped with others, split, docked, undocked, hidden… it seems endless...