Are your SQL Server instances secure? With new threats to your data emerging every day, it’s a difficult question to answer. And what is even included in the word “secure”? Sure, maybe you’re confident you have security against hacking (or maybe not?), but what about internal security? Are you protected against oops moments? Are there … Read more
I do a lot of SQL Server Health Assessments on SQL Server environments. I’m always checking sys.configurations to look for problematic instance level configuration settings. I almost always find configurations worth changing. But the approach I’ve always used is a bit manual and I wanted to fix it. So I finally wrote a script to … Read more
I can’t do a series on free SQL Server DBA tools without including the SQL Server First Responder Kit put out by Brent Ozar and his company (and the SQL Family who helped)! This is that post. A couple weeks ago, I was inspired to start this blog series because of an amazing PowerShell module … Read more
Last week I bragged about an amazing PowerShell module I’ve recently fallen in love with. Today I’m going to talk about the script that, in a roundabout way, made me discover that tool. This is a great script from an extremely knowledgeable and helpful member of the SQL Server family, Robert Davis. Free SQL Server … Read more
I need to sync logins.Just the logins? Sure just go find the best version of sp_help_revlogin. Oh wait you want the server roles, okay well you can steal some of this script here. Oh wait you want the server perms also and default databases? Okay then do a search for this script. Here you go. … Read more