We are solidly in the age of the data breach, and companies are justifiably nervous. But not nearly nervous enough. “As with any security issue, a full review of all companies, systems, third-party applications and related IT solutions must be completed before final determinations can be made.”
Month: April 2022
3 Important Queries for Testing Your Availability Group Endpoints
Time flies, seasons are flying by and seemingly changing day by day. We have slippery slopes here, there, and everywhere. Every now and again Database professionals need a quick moment to get away from the fray. As luck would have it, it is now time for a fabulous party – to get away from all…
SQL Server Security on the Ground
Today we’re going to hit my top 5 – well, top 6 – boots-on-the-ground security tips for SQL server. First, though… I’m pleased as punch to invite you to our next live webinar on April 21: Jen and Sean’s All-Time 5 Favorite SQL Server Security Tactics! Register: www.tinyURL.com/2022-03-LearnSQL
Work requests: It’s broke. Fix it.
Many years ago I was given a work request that literally just said: It’s broke. Fix it. I’m sure you can see how that is supremely unhelpful. And this isn’t the only time I’ve gotten such great requests. I need full access. Please run this script. (I’ve even gotten this one without an attached script.)…
UNDERSTANDING SQL SERVER SECURITY: Secure xp_cmdshell with the Microsoft Master’s guide (in 4 not-so-easy steps)
Quite a lot of data folks are reasonably concerned with the possible security holes that xp_cmdshell could introduce.