How to calculate database growth over 12 months?
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.
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
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
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 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