Back in June 2006, Craig Freedman — at the time a developer on the SQL Server query processing team at Microsoft — started a blog about how SQL Server actually executes queries. Almost twenty years later it is still one…
The demo of Bob Ward about new features was nice, but lacked a bit of a CES demo. A few customers always ask what is the best way to sync changed data between locations, Triggers perhaps?! (Just yoking). So I…
If you have a lot of database maintenance jobs on different schedules it is hard to see which ones overlap and are not taking advantage of resources. The job visualizers I know are mostly reporting based and hard to get…
SQL Server 2016 is about to retire in July. If you’re not planning to swipe the corporate credit card for ESUs… it’s migration season.And honestly, moving your AG databases doesn’t have to be a drama-filled weekend project.Spin up a fresh…
This is what Microsoft can do for you. ( ) Well how can a DBA do this in a simple way? You analyze it with Claude code using Brent Ozar’s sp_BlitzIndex @AI = 2. You want the query and…
I saw Brent Ozar on Youtube Performance Tuning and going back to the stone-ages using @AI = 2 in sp_BlitzIndex, copy/edit/paste and again paste your precious time and save money by using a smart app and keep the focus on…
SQL Server 2025 gives you new backup compression algorithms that can dramatically reduce backup size and I/O — often without increasing CPU load. The “best” algorithm isn’t universal. It depends on your data, your hardware, and your restore-time requirements. The…
Using @tabel variables in the past was a good reason for getting fired, because the engine thought you gonna put 1 row in, so the cost for the execution plan were low, so no parallelism in the operators. However now,…
If there is a large (10 tables and some temp tables), complex query and in the select is a calculation with a lot of column values from different tables and the execution plans shows nested loops inside nested loops ..…
