Don't Build a Monitoring System
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
2009-09-14
892 reads
Should you buy or build a monitoring system for your SQL Server? Todays' guest editorial from Grant Fritchey talks about the resistance to recommendations that many people seem to have.
2009-09-14
892 reads
Since I just spent a bit more than half of my 24 Hours of PASSpresentation on tuning queries talking about...
2009-09-11
652 reads
I got the question the other day, when are you likely to see a spool in an execution plan? Easy,...
2009-09-09
2,785 reads
The new book is up on Amazon. I only worked on three chapters of Rob Walter’s new book and that...
2009-09-04
625 reads
I haven’t done well with this. I missed a post. I missed a bunch of workouts. I put on weight....
2009-08-29
1,327 reads
We’ve received wonderful support from the community. Brad McGehee has a list with great people on it who have volunteered...
2009-08-29
1,656 reads
Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this...
2009-08-25
561 reads
I think the Professional Association of SQL Server users (PASS) is an extremely important organization for SQL Server DBA’s. Even...
2009-08-25
663 reads
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,325 reads
I have two new books that I can heartily recommend. This isn’t a review of either book since I’ve only...
2009-08-20
569 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers