SQL Server Case of the Week: Windows Server 22 Update Possibly Breaking SQL Agent & SSIS Packages

SQL Server case study of the week

We started receiving alerts that a client’s SQL Server Agent was not running.  Upon further investigation, we found that the server was recently restarted after Windows updates were applied.  While reviewing the installed updates, we encountered an issue with KB5071547 on Windows Server 2022.  After some troubleshooting, which included trying to start the agent from … Read more

SQL Server Case of the Week: SQL Server Audit Errors – Resolving a Common Error

SQL Server case study of the week

When SQL Server Audits Fail – Quick Summary SQL Server Audits – they’re running in the background, but what happens when something goes wrong? There is an alert that we have encountered that, if you follow the information in the error, typically does not lead you to the solution. What do you do then? Every minute the audit is … Read more