Productivity

8 posts
How I Use AI for Everything Except SQL

How I Use AI for Everything Except SQL

I trusted AI to redesign this blog, be my personal assistant, and organize my life. But I won't let it near a production database. Here's why that's not a contradiction - and what I learned about trust along the way.

Tools 7 min read Productivity
SSMS: Layout, Options and Hotkeys

SSMS: Layout, Options and Hotkeys

My SSMS setup guide: layout tweaks, essential Options settings, hotkeys I can't live without, and miscellaneous tips for a better SQL Server Management Studio experience.

Tools 9 min read Productivity
Coding Standards (T-SQL Tuesday #151)

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
Why my way of writing SQL is superior

Why my way of writing SQL is superior

Semicolons, leading commas, single-letter aliases. Here is the SQL style everyone loves to argue about, and the practical reasons I refuse to budge.

Opinion 5 min read Productivity
Don't Be Lazy

Don't Be Lazy

Sometimes the fastest help is the kind you find yourself. A rundown of the lazy question patterns I keep seeing in SQL help channels.

Opinion 4 min read Debugging · Productivity
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