09Oct 2013 by Grant Fritchey 2 Comments

Do Be a Gatekeeper

Professional Development
I read this fascinating blog post called "Don't Be a Gatekeeper" by Julie Zhuo. Please read that first. It really resonated for me in a lot of ways. Everything she said is 100% applicable to our jobs as data professionals. Work to make things more robust. Create processes and structures and an environment where you don't have to be the hero all day every day. Yes, absolutely. But... ah, there's this nagging little voice at the back of my head. Let's ignore it for a moment. Are you a gatekeeper for your developers? Why? Get out of their way. Listen to what Ms. Zhuo has to say. Your development team doesn't need you squatting on their servers preventing them from moving as fast as they can. In fact, they need…
Read More
04Jun 2013 by Grant Fritchey 4 Comments

Helping Database Administrators

Redgate Software, SQL Server
Let's be honest. Database administration is not all that tough. Set up your backups. Test them. Get consistency checks on line. Some maintenance routines for statistics and maybe for fragmentation are also helpful. Set up security. In most of the important ways, you're done. Sit back, monitor the whole thing and collect your paycheck. BWA-HA-HA! Yeah, well, it's a nice dream. The reality is that you're dealing with constant change that throw this simple set of maintenance monitoring tasks into the garbage. No, you've got new databases under development. Sometimes by development teams that are absolute rocket scientists and you sit at their feet learning how they did some really cool piece of code. And sometimes by development teams that more resemble crazed monkeys throwing poo at the walls to…
Read More
28Aug 2012 by Grant Fritchey 2 Comments

These People Are Exceptional

Professional Development
I should know. I was one of the judges of this year's Exceptional DBA of the Year award. I had to read through tons and tons of submissions and help to arrive at a final list of people who truly personify the concept of both the DBA and the exceptional person. They are all worthy of your votes, but you can only pick one. Today is the final day to make your voice heard and get your influence in. Please, let us know who you think the Exceptional DBA of the Year is by clicking on the link, now, and voting.
Read More
21Mar 2011 by Grant Fritchey 10 Comments

Communication

Object Relational Mapping, SQL Server, T-SQL, Tools, Visual Studio
It sure seems like there’s a lot of miscommunication between developers and database specialists. In fact, the communication can become so poor that outright hostility between the groups is common. At the end of the day we are all working towards a common goal, to add value to whatever organization we are working for. It's a shame that we all lose sight of this commonality and create such a false dichotomy between the groups. I think there are some ways that we, as database specialists, can use to attempt to cross that gap. Prior to being suborned to the dark side, I was a developer. I had a little over 10 years experience working in VB, Java & C#. I remember, distinctly, cursing our database team for being so problematic…
Read More
02Nov 2010 by Grant Fritchey 12 Comments

TSQL Tuesday: Why Are DBA Skills Necessary

Misc
  Quote: "Database stuff, all this programming stuff, is easy. Anyone can do it. That's why everyone in the company has sa privileges." For nine months, I worked in an environment where everyone, from developers to QA to the sales people to the receptionist, had SA privileges. You know what? DBA skills are necessary. I speak from the point of view of someone that has had to recover a server after a salse person helpfully "cleaned up the temporary stuff on the server" by dropping tempdb, causing a late deployment for a client. I speak from the point of view of the guy who kept a window open on his desk with the database restore script ready to run, all day long, because of "accidents" that stopped development until I could get the…
Read More