Month: August 2022

Script to consolidate SQL Server agent logs

Problem: How can I view all SQL Server agent logs at-one-time without querying each individual log on its own? Solution: The answer is to put this data into a single table allowing you to better query this information based on your individual needs. I’ve given a possible solution with the following T-SQL script. Let me …

Script to consolidate SQL Server agent logs Read More »

Changes in SQL Agent Insight release 0.25

With the release of SQL Agent Insight version 0.25 (and for all future releases), I’ve decided to blog the release notes as a secondary means of tracking the history of features, improvements and bug fixes of the product. Heading over to SQL Agent Insight’s change log page will continue to only capture the changes of …

Changes in SQL Agent Insight release 0.25 Read More »

Script to identify unused SQL Server database mail accounts

Background: Following in-step with my previous blog posts, you will know that I like to keep my SQL instances as free from clutter as possible. I provide a script below that will return all database mail accounts not currently being used by any database mail profile on the current instance. Having this list allows you …

Script to identify unused SQL Server database mail accounts Read More »