SQL Server First Responder Kit [Free DBA Tool of the Week]
July 20, 2016
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
Robert Davis’ Login Sync Script [Free DBA Tool of The Week]
July 16, 2016
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
Free DBA Tool of the Week – DBATools
July 7, 2016
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.
Check Your SQL Server Configuration
November 27, 2013
I blog a lot about best practices, defaults and paying attention to your installations. It’s a huge pet-peeve of mine to see improperly configured instances. One of the things I always do when doing a health check is review an instances configuration options. On quite a few client environments, just a couple quick knob turns