Full, differential and log backups are the three things almost every SQL Server DBA can define, and the three things a surprising number of us get wrong under pressure at two in the morning.
Eleven SQL Server Interview Questions That Look Far Too Easy
These eleven SQL Server interview questions look far too easy, and every one of them has stopped somebody senior.
Cost Optimization That Never Reaches the Invoice
SQL Server cost optimization has a problem nobody puts on the slide. The savings are real, the dollars are real, and none of it reaches the invoice. This is the story of how I found that out in front of people. I want to tell you about the best week…
Read More
Nine Unusual Ways My Clients Use AI With SQL Server
Everyone writes about AI generating queries. Nobody writes about the strange jobs it is actually doing inside real database teams. These are nine of them, and I helped build every one.
The Strange Emotional Shift of Working Alongside a Machine That “Thinks”
Let us talk about The Strange Emotional Shift of Working Alongside a Machine That “Thinks”. The Night a Query Finished Before I Did
Local AI Models for SQL Server – A Complete Guide
Let us learn about Local AI Models for SQL Server – A Complete Guide. What if you could bring the power of AI into SQL Server?
Performance and TempDB Spills – SQL in Sixty Seconds 208
Sorting large datasets in SQL Server can significantly impact performance, especially when it leads to tempdb spills.