Category: Admin

Learn some critical SQL Security with the MidnightDBAs (Thursday, Jan 20)

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 […]

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.