top of page


T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
The T-SQL Tuesday #201 round-up: ten bloggers on whether temp tables are a friend or a foe, from full-throated defenses to a lab built to prove me wrong.
2 days ago8 min read


T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I argue moving data into a #temp table is usually the wrong reflex, and invite you to make your case.
Aug 44 min read


How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
Fabric has CI/CD built in, but if you've tried to use it for database deployments, you've probably already run into its limits. It's still very much in its infancy. The moment you change a column's length, drop a column, or remove a table that already contains data, the deployment fails — Fabric throws up a safety precaution and refuses to proceed. That's a reasonable default, but it stops real schema changes in their tracks. There could be ways around it — third-party tools
Jul 106 min read
bottom of page