Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

DBA: Mentor vs. Protector

By Matt Simmons,

Today we have a guest editorial from Matt Simmons

I started in the database world using MS Access about 15 years ago. I was young and inexperienced and made lots of mistakes with even the simplest stuff. But I was fortunate that in our department there was a developer that saw something promising in me. I was willing to try things myself first, research a lot, and then ask questions of others. He was both patient and wise and dispensed knowledge in a mentoring fashion, sharing bits and pieces of knowledge pointing in directions to pursue. Rarely did he offer an outright solution, but steered me toward the right path.

My second encounter was similar to the first, with guidance and direction, someone challenging me to think through the entire process and then implement a proposed solution. My third encounter was with a certified MCDBA. He was actually younger than me, but like my other friends saw some potential in my ability as a SQL Programmer. He took me under his wing and together we challenged each other to develop new processes and methods for the agency where we worked.

I suppose I can relate my first experiences to being in high school, then college and then to becoming a teachers' assistant. Mentored by all of my teachers and professors, and being challenged to learn. I was taught to educate my fellow programmers and support the database community as a whole.

Since my days as a "TA" I've run into issues with almost all my subsequent DBA's. They were, in my opinion, brought up in the military fashion with a "Lock it down and Secure it, No one may Pass" attitude. I've found this to be extremely frustrating and have left jobs as a result of this type of attitude.

Now don't get me wrong, I was taught about the importance of security and implementing best practices. I swear by it, and as a developer am scared when I find production databases that are accessible to my coworkers.

But what I don't understand is the DBA that locks down the Dev box so tightly that only they can play in the sandbox. Part of my job as a programmer, I believe, is to write the best code I can, to help my other programmers write better code and to help improve the performance of the database. I can't do that unless I can at least use ShowPlan and create indexes. I document my performance tests, my changes, and the improvements. I make recommendations to improve performance and try to assist my DBA.

All I ask is for the ability to do my job. So, I ask for your thoughts. Does the Data Protector trump the Mentor when it comes to dealing with developers/programmers? Is there a happy medium where the two can coexist?

Total article views: 207 | Views in the last 30 days: 1
 
Related Articles
FORUM

MMO Bioware Austin Texas - Database Programmer

Database Programmer Video Games

BLOG

Team-based Database Development: Playing Nice With Others

Here are the slides and links to awesome resources for my presentation, “Team-based Database Develop...

ARTICLE

Citizen Programmers

Steve Jones finds the Salesforce platform interesting and notes we have lots of "citizen programmers...

ARTICLE

What Makes a Good Programmer

Are top notch programming skills innate or can they be learned? Janet Wong takes a look at the skill...

BLOG

Good Programmer = Lazy & Dumb?

Alternative title for programmers using C-derivatives and Java: Good Programmer == Lazy & Dumb? ...

Tags
dba    
editorial    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones