Topic · 5 articles
Coding
Cheat sheets, snippets and tools for everyday programming.
Azure Data Studio – Cool Snippets
How to back up and restore your Azure Data Studio SQL snippets, plus the sql.json snippet file with the shortcuts I use every day.
2 min readRegex – Cheat Sheet – Basic – Anchors
A regex cheat sheet for the two basic anchors, ^ and $, with find-and-replace examples in Notepad++ that add text to the start or end of every line.
2 min readAzure Data Studio My New Muse (Part 1)
A brief look at Azure Data Studio, followed by tips to speed up your SQL coding with custom snippets and query shortcut keys.
4 min readSQL – CTE – Basics
What a SQL common table expression (CTE) is, how to write one, common pitfalls, and a CTE vs normal join comparison on AdventureWorksDW2019.
2 min readSQL Loopidy loops… A case for TSQL loops
T-SQL WHILE loops, what they're good for, and a practical example that builds a dynamic UNION ALL query across one-table-per-day data.
5 min read