This blog post is written in response to T-SQL Tuesday hosted by Paul Randal.
I think following questions has been always very interesting question for everybody who is working with SQL Server.
Are you a Database Administrator or Database Developer?
The answer of this question varies from organizations to organizations and to countries to countries.
Quite often I see people call them developer and doing tasks of backup and restore of the database. Often I see Administrator writing efficient code in application development. I totally understand that it is almost impossible to draw a line and quite often we are comfortable doing all the tasks.
Additionally, there are few tasks which can be done well by either Database Administrator or Database Developers. E.g. Index management and creation.
However, I want to start an interesting conversation with all of you today.
Question for you –
Irrespective of your job description do you consider yourself as Database Administrator or Database Developer?
Why?
Please leave your answers in comment area. I am also creating pole along with this post – I have not kept the others options or both options as they take away fun of this question.
[polldaddy poll=4018200]
Reference: Pinal Dave (https://blog.sqlauthority.com)
47 Comments. Leave new
Database Developer.
I am a DBA. I don’t do code. I come from a systems background. Don’t get me wrong, I can muddle my way through some intermediate SPs, functions, and triggers but I am more comfortable with keeping database systems available.
SELECT ‘YES’ FROM tblQuestion WHERE HAT = ‘DBA’ OR HAT = ‘DEV’
results
———————————
YES
YES
Officially I’m a DBA but due to the fact that we are understaffed and also the fact that our databases and DB jobs have been set up well and run smoothly I therefore do a lot of DB developement.
Of course, as a DBA I prefer to do real DBA work.
I am doing the following tasks
1) Design and create database structure
2) Create stored procedures functions
3) Schema Comparision
5) Try to Optimize the Query
I am DBA Developer, because i am not doing any kind of administrative tasks in SQL Server
I am doing only procedure,function and database design so i am developer.I have knowledge but we don’t have work like DBA.
I call myself “Database Engineer” because I am not simply implementing what others told me to do …
Yet my job description simply sounds “Database Specialist”.
I agree with that… Database Specialist :D
But to choose between DBA or DBD, I choose DBD. In SQL Server administration things feel seemless, coz lotta
administration thing can be done easily.
Diffrent with Oracle guys, which sounds good to call himself DBA, coz there is lotta administration things come with complexity and effort.
The other way developing things in oracle is the same like developing vb/c#/java/web program to access db (oracle need oracle developer like sql server need visual studio or others).
Simply (just my 2 cent) :
SQL Server = DBD
Oracle = DBA
Thx
I am SQL Sever Database Administrator.
dba; given that I used to be on sysadmin side, it was a more (or less) natural flow
I have done both database development(Unix and Windows platforms) and now administration for 14 years and and am a MCDBA of which involves server, network, database, application, installs, configuration, performance, troubleshooting, investigation, recomendations and any and all other possible senarios. It is then hard to define the fine line of developer or administrator but my role is defined as DBA specialist.
THX..
This is Great !!!!
Great topic. I find that having some DBA skills really help me as a developer. I look at chose I wrote before I started performance trouble shooting, and I can’t believe it is mine.
I am a developer. i am finding to improve as DBA
You need to be either a developer or a database administrator nothing in betwwen It is isolation of tasks that means that it is. Too often you may be called to develop and then deploy what you develop as most cases the dba is the gatekeeper and does all deployment and so breaks the rule. Dont try to convince me otherwise as there must be segregation of tasks. DBA developer is a recipe for disaster
I think Database Administrator can work as DBA and aslo as DBD, because he know about both creating procedure, triggers, indexes and also knows how to take backup and restore them. I current profile gives me the opportunity to develop the procedure, triggers and also of taking backup and maintaining databases.
Hardik Thakore
it’s difficult to say that i am an administrator , because i really don’t like doing the backup or fixed problems of database i didn’t write its code ,, so i am a developer … but not a professional
I m Diploma holder working as System Administrator I want to go for Database Administration please help me what should i do??
my email id is [email removed]
hi sir i want to know difference between SQL DBA and SQL Developer .My mail id is : dhanabecse172gmail.com
who earns more oracle dba or developer
have sql server 2008 64bit Developer’s Edition Installed on my machine.
And Microsoft Office 2013 Professional 64bit.
I have been trying to import and export some Excel data from an Excel sheet into a sql server database. I have used the following query to do this :-
sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO
sp_configure ‘Ad Hoc Distributed Queries’, 1;
GO
RECONFIGURE;
GO
USE [ERPInventorySystem];
GO
SELECT *FROM OPENROWSET(‘Microsoft.ACE.OLEDB.12.0’, ‘Excel 12.0;Database=C:\Users\pratiks\Downloads\contact.xls;’,
‘SELECT * FROM [Sheet1$]’)
GO
But the error message says,
OLE DB provider ‘Microsoft.ACE.OLEDB.12.0’ cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.