SQL Server 2008 SP4 (link) and SQL Server 2008 R2 SP3 (link) have been released. Please note these are the final service packs for these
Author: Mohit
Microsoft Data, Analytics & AI - Sr Cloud Solution Architect
Updating Central Management Server (CMS) Register Server List Automatically
Microsoft released Central Management Server (CMS) with SQL Server 2008; it allowed us to have great functionality for multi-server management. However keeping that list up-to-date
Auditing SSRS Report Execution
We can use the SSRS Report Server Execution Logs (link) to review who is executing reports on the server. These logs are saved directly in
SQL Server Configuration Manager, WMI Error 0x80041010
I just got this at my client, its normal message. See it way too often, generally, I run into this when the multiple version of
Service Principal Names for SQL Server
Service Principal Names (SPN) get used for Kerberos authentication. SQL Server require that all instances have SPNs configured, if not Kerberos authentication fails. By default
Online Index Rebuild can Cause Fragmentation
As Microsoft SQL Server PFE, I am always playing with SQL Server. I generally spend most of my time on the engine side of world;
SQL Canada (SQLCAN) 