Welcome to wiseDATAman.com
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
Free, open-source SQL Server monitoring for performance, daily health checks and configuration tracking. DBA Dash has been in active development since 2022 with regular releases. Find out more at dbadash.com.
Latest from the DBA Dash blog
- What's new in 4.24.0Query the repository from Claude Code, Cursor and other MCP clients. Plan SQL Agent start times, and mark the hours jobs should stay out of. Deploy community tools from DBA Dash. Read more
- What's new in 4.23.0Live query plans from Running Queries and SSMS. Long-running queries are collected as operator counters, not a new plan XML on every snapshot. Then source connections from the GUI, and a redrawn SQL Agent job timeline. Read more
- What's new in 4.22.0Query Stats at statement level, a tabbed detail window, AG failover history, log shipping pairs and exclusions, Plan Viewer insights, Amazon Bedrock, AI follow-ups, AI performance analysis, SQL login password age, and a GUI installer. Read more
Latest Posts
- T-SQL Tuesday #186 - Managing Agent Jobs
For 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
- Removing large backup history with sp_delete_backuphistory
Problem 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: backupfile backupfilegroup backupmediafamily backupmediaset backupset restorefile restorefilegroup … Read more