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 ...

One of the most useful features in Microsoft's System Center Operations Manager (SCOM) product is its reporting engine. Even though there is nothing overly difficult about its installation process, ...

On the back-end I installed two database servers running SQL Server. The idea was to use NLB on the front-end for load balancing and Database Mirroring on the back-end for data protection and failover ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...

There’s a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

Microsoft will retire SCOM SQL monitoring packs in 2027, pushing customers toward Azure Monitor and cloud billing.

Microsoft has announced that SCOM Management Packs for SSRS, PBIRS, and SSAS will reach End of Support in January 2027, forcing enterprise migration to Azure Monitor.