In SQL Server, the sp_delete_backuphistory stored procedure is is the standard and supported method to purge old data from the backup and restore history tables in the msdb database: Recently, I encountered an issue running sp_delete_backuphistory on servers that hosted a large number of databases …
There are a few methods you can use to get drive information using T-SQL. The problem is all these methods have some limitations. They provide free space but not drive capacity or they only provide data for volumes that contain database files. Ideally Microsoft would provide an easy way to get both …
When you configure your SQL servers for high availability you want the failover to be as seamless as possible. If you use availability groups, mirroring or log shipping as part of your high availability strategy you will need to take care of anything that lives outside the context of your databases. …
Max server memory is one of the SQL Server configuration options that you should change from the default value. Brent Ozar has some good advice on this here. TLDR: You should leave some extra memory for the o/s. A good starting point is to leave 10% (4GB minimum). If you are running other processes …
Update: This was my original solution to automate the DBA Checks process. I don’t recommend people use this solution as it doesn’t scale well to a larger number of servers and the CLR function used to get drive space requires the TRUSTWORTHY property to be enabled which can be a potential security …
Warning: the use of TRUSTWORTHY described in this article can be a potential security risk so you might want to consider alternative options. Using CLR (.NET Framework) code in SQL Server is a very powerful way of extending the built-in features and functionality. The .NET framework provides access …
This script is a simple utility to allow users to restore SQL Server databases. It’s easier to use for non-DBAs and it provides a method of restoring databases when the management tools are not installed. It’s a good demonstration of a HTA application, but it’s not a intended as a replacement for …
Show running time and estimated time to go for SQL backup and restore operations.
This function converts a string to proper case. e.g. Convert this: A LONG TIME AGO IN A GALAXY FAR, FAR AWAY To this: A Long Time Ago In A Galaxy Far, Far Away Note: It might be better to do this in the application rather than the database and it could be better written as a CLR function. This is …