EPM is great tool that builds on top of the SQL Server Policy Mangement and Central Management Server to provide you overview of your enviornment.
Category: Administration
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
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;
Using sys.dm_io_virtual_file_stats DMF to get IPOS and BPS
SQL Server keeps track of all the reads and writes it submits to the operating system (OS). It records this information in sys.dm_io_virtual_file_stats DMF. We
Index_Name Function for SQL Server
We have the database_name, object_name, object_schema_name but don’t have index_name. So when accessing information in sys.dm_db_index_usage stats, it becomes troublesome to find out index name
SQL Canada (SQLCAN) 