Topic · 5 articles
SQL
T-SQL, CTEs, loops and SQL Server tooling.
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 read5 Quick tips for MSSQL Management Studio
Five quick tips for SQL Server Management Studio that save time and boost productivity, from colour-coded environments to query shortcuts and line numbers.
5 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