SQLAuthority News – RML Utilities – Usage and Additional Help

Yesterday I wrote about SQLAuthority News – Download RML Utilities for SQL Server. I received many emails where different developers requested how to find additional help regarding RML Utilities. Few users reported that they are not able to install RML Utilities because of some reporting service pre-requisite. If RML Utilities…
Read More

SQLAuthority News – Download RML Utilities for SQL Server

Note:   Download RML Utilities for SQL Server by Microsoft The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see: Which application, database or login is using the most resources, and which queries are responsible…
Read More

SQL SERVER – Delete Backup History – Cleanup Backup History

SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be executed with parameter which takes days of history to keep. In following example 30 is passed to…
Read More