Maybe I’ve forgotten the name and the address of every patient I’ve helped throughout my years in EMS back when I was still involved, but there’s one thing I know: quite a few would say hindsight is 20/20. The older I get, the more I see how often this pattern repeats. Whether it was the … Read more
Give me six hours to chop down a tree and I will spend the first four sharpening the axe. Abraham Lincon Welcome back to the Two Weeks to A Healthy SQL Server series of posts! This is the official “Day One” post. This first step may not be the most glamorous or the biggest payoff, … Read more
Many companies have the wrong people managing their databases. It sounds mean, out of context. But note we didn’t say “bad people” or “mean people,” just the wrong people to ensure a healthy SQL Server. Sometimes it’s even worse than that. It’s not the wrong person, it’s “no person.” Nobody owns its uptime, recoverability, or … Read more
… Long live that other SQL Server version you should have upgraded from long ago … It’s January of 2019. 2019 and I’m writing a post reminding you that you it is time to upgrade from SQL Server 2008 or SQL Server 2008 R2!! Eleven years later.. That’s a testament to the amazing product that SQL … Read more
Today Microsoft just made a huge announcement. All of the features you can build into your databases in SQL Server (well the vast majority at least) are no longer just included in Enterprise Editions. There are some exceptions… But the main point here is – you can be on SQL Server Standard – and you can use … 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
I’m not going to let another #mememonday pass without a post – one thought came to mind. The theme this month is – What gift do you want Microsoft to leave under the tree this year? I don’t want much. Bill Gates is already taking care of the world, so no beauty pageant wish there. … Read more