NOLOCK is not a safe performance fix, it is a decision to reduce blocking by accepting an answer that may never have been true. The whole problem is that nobody who types it thinks they are making that trade.
I Let AI Recommend SQL Server Indexes Across a Week of Queries
I let AI recommend SQL Server indexes across a week of queries, measured every number before and after, and the result was not the one I expected to write about.
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.
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.
Hire AI and Not Me: Human Can Make Mistakes
Let me tell you something that took me a long time to say out loud. Human Can Make Mistakes Not AI. (Well, line inspired from famous GenAI tool).
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
SQL SERVER – Execution Plans and Indexing Strategies – Quick Guide
Let us learn today in this quick guide Execution Plans and Indexing Strategies. Your comments are welcome