Hi, I’m David Wiseman.
I’m a SQL Server DBA that enjoys performance tuning and spend most of my time writing and tuning T-SQL code. This is my personal blog site to share my experience, scripts and tools with the community.
More
DBA Dash
Open Source SQL Server Monitoring tool. Just released!
Latest Posts
- T-SQL Tuesday #186 – Managing Agent JobsFor T-SQL Tuesday #186, Andy Levy asks, “How do you manage and/or monitor your SQL Server Agent jobs?” This is a great opportunity for me to discuss how DBA Dash can help monitor SQL Agent jobs. DBA Dash is a free and open-source monitoring tool for SQL Server, created by me. It’s used to monitor… Read more: T-SQL Tuesday #186 – Managing Agent Jobs
- Removing large backup history with sp_delete_backuphistoryProblem 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 with frequent log backup & restore operations. The clean… Read more: Removing large backup history with sp_delete_backuphistory