13Mar 2019 by Grant Fritchey 4 Comments

Database Development Gone Wrong

Redgate Software
I recently shared a story about how I was personally responsible for a development project going off the rails (and oh boy, did it go off the rails). It's a very painful story to share since I was the principal bad guy. However, I learned a lot of lessons from it. Now, it's your turn. Redgate Software (yes, my employer), is running a contest between now and March 20, 2019. We want to hear your story about database development gone wrong. It can be a horror story like mine, or just a simple story of the pain involved when developing databases ('cause there's always a little pain). Inspiration! What, the chance to $150 or more isn't inspiring? OK, how about this, here's Kendra Little's story about her database development... not…
Read More
15Sep 2014 by Grant Fritchey 2 Comments

Podcast on Devops and the Database

DevOps
I've been attempting to expand my reach to get back to my roots in development. I'm doing this because I really believe in the concepts behind devops, that these walls we've erected between development and dba, between dba and san admin, et, ad nauseum, cetera, need to come to an end. The great news is that there are a lot of other people who feel the same. We're changing things. Come on over to the dark side, we have wine. Any way, I had a blast talking database devops with Bryan for his podcast. Have a listen and let me know what you think.
Read More
05Feb 2014 by Grant Fritchey 6 Comments

Book Review: The Phoenix Project

DevOps, Professional Development
Let's get this straight right up front, the thought of reading a novel that's about IT is so repellent, so repugnant, just so horribly wrong, that it's kind of hard to fathom why I would even attempt it. What's even more difficult for me to fathom is how much I enjoyed this book. Which is a novel. About IT. I can't figure it out. Maybe I need to start reading more IT novels... no. Let's hope that's not actually a thing. On with the review... The Phoenix Project is a story about a mid-level manager in a large company who has been running part of the IT organization that is a bit of a backwater, maintaining old big-iron systems, VAX, that type of thing. He gets called into the CEOs…
Read More
15Jan 2014 by Grant Fritchey 17 Comments

Database in Source Control

SQL Server, Tools
Many years ago, I was working with a great DBA. Seriously, a very smart and capable guy. He told me, "We need to put the database into source control, just like app code." And I just laughed. Not because I disagreed with him. I knew he was right, but I had tried, several times, to do just that. See, I'm not really a DBA. I'm a developer. I knew that code (and all the T-SQL that describes databases is code) needed to be versioned, sourced, tracked and audited. But great googly moogly, it was not an easy thing to do. I first tried just exporting the entire database into a script and then occasionally checking that script into source control. Yay! Mission Accomplished... Well, I had a database in source…
Read More