As Joey explains, Activity Monitor consumes a lot of resources and yields little usable data. Here are some third-party alternatives. I get to work with a lot of customers, so I get to see a lot of ...

Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

Microsoft deprecates SSRS, PBIRS and SSAS management packs for SCOM, ending support in 2027. The move signals a shift from on-prem SCOM extensions toward cloud-based SQL Server monitoring. IT teams ...

As today’s database administrators (DBAs) manage the complexity of modern database environments, particularly containerized systems, they must lean into smart automation to transform database ...

— Today at the 2004 Professional Association for SQL Server (PASS) Community Summit in Orlando, Fla., Microsoft Corp. extended its comprehensive data platform by demonstrating new business ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...