T-SQL Tuesday

Database CI/CD Basics (T-SQL Tuesday #177)

A crash course on database CI/CD: source control as the source of truth, state-based vs migration-based versioning, and the many moving parts of automated database deployments.

T-SQL Tuesday 4 min read CI/CD

2024-08-13

Extended Events and I (T-SQL Tuesday #166)

Grant Fritchey asked us to talk about our favourite SQL Server tool for T-SQL Tuesday #166. Mine is Extended Events - and I have the GitHub repo and a public speaking session to prove it.

T-SQL Tuesday 3 min read Extended Events

2023-09-13

T-SQL Tuesday #156 - Wrap Up

Fifteen SQL bloggers answered one question: what turns ordinary code into production code? Here's what they taught me.

T-SQL Tuesday 3 min read

2022-11-17

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

2022-11-08

Production Code (T-SQL Tuesday #156)

I'm hosting T-SQL Tuesday this November. The question: which secret ingredient turns ordinary code into production-grade code?

T-SQL Tuesday 1 min read

2022-10-31

What's in a name? (T-SQL Tuesday #152)

My T-SQL Tuesday rant: an app that connects as '.Net SqlClient Data Provider' turns debugging into a manhunt. Please, name your apps.

T-SQL Tuesday 2 min read Debugging · Extended Events

2022-07-12

Coding Standards (T-SQL Tuesday #151)

My T-SQL Tuesday #151 entry: the SQL habits I swear by, and the ones I'd ban from every codebase if I could.

T-SQL Tuesday 4 min read Productivity

2022-06-14

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

2021-10-12

Work Life Balance (T-SQL Tuesday #141)

Work-life balance has been my focus for the past year and I've already made some changes to my lifestyle. Now it's time to take a look back and evaluate.

T-SQL Tuesday 2 min read Personal

2021-08-10

Containers and Me (T-SQL Tuesday #140)

It took three tries before containers clicked for me. Each time I learned a bit more, but it wasn't until I had my own project that it all came together.

T-SQL Tuesday 2 min read Docker

2021-07-13

My Favourite Data Type (T-SQL Tuesday #136)

Brent Ozar asked the SQL community about their favourite data type. My answer surprised even me - sql_variant. Here's why, plus the data type I can't stand.

T-SQL Tuesday 2 min read

2021-03-09