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 …
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 …
The invitation from Tom Zíka asks “Which quality makes code production grade?”. Code that runs in production should be reliable. It should produce consistent results, handle concurrency and deal with error situations. Production code needs to be able to scale. Scalability should be considered in …
Data Relay is a free community conference in the UK for the Microsoft data platform. I submitted a session for DBA Dash which was accepted and I delivered my session on the 4th October 2022 in Leeds. This was the first time I’ve done something like this and it was outside of my comfort zone. I was …
Some modules such as antivirus software are known to cause issues when loaded into SQL Server address space. These problems might vary from performance issues to weird bugs and corruption. DBA Dash can now highlight where you have problematic modules loaded. Read more here
DBA Dash has a new website. The purpose of this site is to provide a friendly landing page for new users of DBA Dash and to provide a better documentation experience. DBA Dash remains open source and the GitHub page isn’t going anywhere. GitHub is still the place to log issues, create discussions …
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, …
I’m writing this post to join in with September Free Community Tools Awareness Month. There are many awesome free community tools. I’ve chosen to blog about 3 of them that I think are interesting any maybe less well known in the database community. I’m also taking the opportunity to shamelessly plug …
If your table runs out of identity values, you might see an error message similar to the one below: Msg 8115, Level 16, State 1, Line 7 Arithmetic overflow error converting IDENTITY to data type int. DBA Dash now has monitoring for identity values. You can see when you are about to run out of …
The first public release of DBA Dash was in January 2022 and version 2.21.0 is the 24th release.🎉 A lot has changed with many new features added as well as bug fixes. I haven’t really blogged much about the changes, but I thought it might be good to capture what its new for significant releases. So …