Jeff Taylor

Many of us use AI the same way every single day. Open a tab. Paste in a question. Copy the answer out. Fix what it got wrong. Then tomorrow,...

2026-09-18

34 reads

T-SQL Tuesday #202: The Two Outages I Won't Ever Forget

by ReviewMyDB

Jeff Taylor

My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages. Two nights I still remember minute by minute, and what I do differently because of...

2026-09-18 (first published: 2026-09-08)

298 reads

T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?

by ReviewMyDB

Jeff Taylor

The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend or a foe, from full-throated defenses to a lab built to prove me wrong.

2026-09-04 (first published: 2026-08-25)

78 reads

T-SQL Tuesday #201 Invitation: Temp Tables, Friend or Foe?

by ReviewMyDB

Jeff Taylor

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...

2026-08-04

95 reads

How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps

by ReviewMyDB

Jeff Taylor

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....

2026-07-20 (first published: 2026-07-10)

226 reads

Automatic Index Compaction

by ReviewMyDB

Jeff Taylor

Index maintenance has always meant nightly jobs and a window you have to defend. Azure SQL’s new Automatic Index Compaction targets page density directly — so I tested it.

2026-07-10 (first published: 2026-06-30)

318 reads