Friends, the MidnightDBAs have a plan for 2022. A capital-P Plan. And it involves writing and teaching a lot. The plan for January 2022 is a focus on SQL Server security. We’ve already collaborated and published one blog over at MinionWare.net: UNDERSTANDING SQL SERVER SECURITY: Secure xp_cmdshell with the Microsoft Master’s guide (in 4 not-so-easy […]
Category: Admin
What happens if your SQL Server editions are out of support? – a MinionWare snippet
The more your SQL Server is out of date, the more things become vulnerable, broken and unfixable, limited in features, and expensive.
Fix: When an Availability Group listener’s IP is stolen
When you can connect to the individual nodes of a SQL Server Availability Group (AG), but not the AG listener, you may have a duplicate IP situation. Resolving this isn’t QUITE as straightforward as I’d hope, so here’s our solution.