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 …
This is my first time participating in T-SQL Tuesday. The Invitation from Glenn Berry asks to write about what you’ve been doing with SQL 2022. I was eager to test DBA Dash with SQL 2022 and started testing with the first public release (CTP 2.0). I added a SQL 2022 instance to my lab environment, …
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. …
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 …