StraightforwardSQL Database stuff with a side of memes

Regex

3 posts
Testing the code (T-SQL Tuesday #156)

Testing the code (T-SQL Tuesday #156)

I picked the T-SQL Tuesday topic and still struggled to answer it. The quality of production code I value most: it has tests.

T-SQL Tuesday 2 min read Regex · CI/CD
Efficient Cheating at Lego Video Games

Efficient Cheating at Lego Video Games

My daughter's LEGO game makes you re-enter every cheat on a clunky six-dial lock. So I built a TSQL solver to find the shortest path through all of them.

How to 8 min read Regex
Short Code Examples (T-SQL Tuesday #143)

Short Code Examples (T-SQL Tuesday #143)

This month's T-SQL Tuesday invitation is from John McCormack. I'm sharing a few handy snippets I use on a regular basis - a time loop, impersonation testing, database recreation, and some RegEx for SSMS Find & Replace.

T-SQL Tuesday 3 min read Regex · Productivity