SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

The Scary DBA

I have twenty+ years experience in IT. That time was spent in technical support, development and database administration. I work forRed Gate Software as a Product Evangelist. I write articles for publication at SQL Server Central, Simple-Talk, PASS Book Reviews and SQL Server Standard. I have published two books, ”Understanding SQL Server Execution Plans” and “SQL Server 2008 Query Performance Tuning Distilled.” I’m one of the founding officers of the Southern New England SQL Server Users Group and its current president. I also work on part-time, short-term, off-site consulting contracts. In 2009 and 2010 I was awarded as a Microsoft SQL Server MVP. In the past I’ve been called rough, intimidating and scary. To which I usually reply, “Good.” You can contact me through grant -at- scarydba dot kom (unobfuscate as necessary).

Help Me, Help You, Deliver DevOps

I believe in DevOps.

Actually, that’s a pretty horrible way to put it. It’s not about belief, like keeping Tinkerbell alive.

I have successfully worked within an environment that implemented a DevOps approach to development, deployment and maintenance. I also provide classes and consulting on how to approach DevOps from the Ops perspective as well as writing books on the topic.

Because I’ve seen the DevOps approach work, and work well, despite the fact that my principal job description is in the Ops side of DevOps, I am a very strong and passionate advocate for DevOps.

But!

DevOps

Despite the fact that I absolutely support the concepts of DevOps, moving development & deployment into the production space, and moving operations into better support of the development space, I frequently find myself, with my face, in my palm.

Why?

Look at the word, DevOps. Note: it doesn’t say Dev. It doesn’t say DEVops. It doesn’t say Dev           ops(maybe, later, if we have time). The core concepts behind DevOps is that development and operations are coming together. It’s not that development is taking over operations, as I so frequently have to argue about, with both development and operations. This is an important and key concept because, there’s a reason why you see some specialization within IT. Frankly, IT is difficult. So, people spend time learning smaller aspects of it in order to be good at those aspects. Yes, acknowledged, there is the very rare individual who truly is a superstar and can do it all, but they are, by definition, extremely rare on the ground. Most of us in IT are just ordinary humans.

Operations

I get it. To developers, the operations team just seems like this slow moving behemoth, a dinosaur on it’s way to the tar pits (yeah, I know, mainly mammals in the tar pits from a different era, work with me). Especially the DBA team (No!) and they’re ability (No!) to slow things down (No!) with their constant (No!) use of the word, “No” (No!).

However, operations exists for a reason, and they’ve developed a lot of special skills and knowledge that seems to be missing from development. Let me outline what I mean.

Failure

There has been quite a few spectacular failures recently. Let’s talk about how a fundamental lack of understanding of why ACID properties on a database are kind of important, especially when setting up something that resembles a bank.

No? How about the fact that backup testing, a pretty fundamental aspect of operations is so easily overlooked. Not to mention evidently being able to use the same login in dev/test and production so that you can corrupt and then drop the production database accidently.

Maybe that you need a secondary location for your DR? Seems like a pretty fundamental part of operations.

Or even my own web site. I didn’t maintain my updates appropriately (and I know better) which allowed me to be hacked. Happily, I have two sets of backups, one I maintain myself and one maintained by my wonderful service provider, Dreamhost. Recovery was possible in under an hour.

Speaking of backups, maybe taking them at all would be a good idea.

Kumbaya

Not all those losses and outages are even remotely the fault of DevOps, but you do get the sense in our ever more development focused age, that maybe, a little more attention ought to be paid to the Ops side of things and then we can all hang out, singing kumbaya instead of running around putting out fires. The key concept of DevOps is that we meet in the middle and cross over. It’s not that one side takes over the other. The old days where things were Ops-centric were silly, and failed. Let’s not repeat those mistakes by going completely Dev-centric. Let’s do DevOps.

PS: Apologies if this page loads slowly. I was in a mood.

The post Help Me, Help You, Deliver DevOps appeared first on Grant Fritchey.

Comments

Leave a comment on the original post [www.scarydba.com, opens in a new window]

Loading comments...