TSQL2sday #70 – Consistency, consistancy, consestency

TSQLTuesday

#TSQL2sDay, hosted by Jen McCown (b/t) on strategies for managing an Enterprise.

Managing an enterprise is all about consistency. The best tools and policies out there aren’t going to do you a bit of good if you and your team/coworkers/underlings/minions don’t execute them in a consistent method. Now, is that consistent, consistant or consestent? Good thing we have an enterprise tool like spell check here.

Companies like Idera, RedGate and others have sets of sweet tools to help manage and maintain your enterprise. I’ve used some of them and have been happy with the products, but had several cases where SQL servers broke or didn’t perform up to their expectations. There was powerful hardware, there was monitoring with all the flashing lights and alerts you could ask for, but there wasn’t consistently followed policies and procedures. Writing policies and procedures suck, but it is the necessary task that will save you and your team/coworkers/underlings/minions from being thrown into the tank containing sharks with frickin’ laser beams on their heads.

Instances spread across several continents, time zones and languages can be difficult to manage, especially when your team is also distributed across those three variables. As a good sized enterprise we were able to bring in a suite of enterprise tools from Idera. The wizards were clicked through, lights flashed, alerts alarmed and we were in control of our enterprise…for about 5 minutes. This distributed team did not communicate well. We did not write consistent procedures nor follow consistent policies. We failed as a team and our enterprise reflected this.

As an enterprise of one in my current role I have a much easier time enforcing documentation requirements and adherence to policy. Consistency is still important as I do like going on vacation now and then. Without enterprise documentation how is anyone going to be able to fill in and show my boss how replaceable I am?

What are key parts of my consistent enterprise management?
Ola – Because Ola.
Wiki – Our internal IT spot for documentation, policies and procedures
Standard Alerts

Advertisements