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


What is a Database Administrator today?


What is a Database Administrator today?

Author
Message
Outer World
Outer World
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 70
I worked for the business unit (BU) and not the IT department, so I was not granted SysAdmin rights to the servers even though my position was as a Database Administrator. That was very frustrating and I found out later that this was an ongoing war between the BU and IT.

Reminds me of my current job. My title is database analyst. The database is a SQL Server system and I am employed by the BU and not the IT department. The IT department likes to keep SQL Server within their 'center of excellence'. Consequently I am doing my work using MS Access even though I have more experience with SQL Server.
Ford Fairlane
Ford Fairlane
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3304 Visits: 836
Outer World (12/8/2013)
I worked for the business unit (BU) and not the IT department, so I was not granted SysAdmin rights to the servers even though my position was as a Database Administrator. That was very frustrating and I found out later that this was an ongoing war between the BU and IT.

Reminds me of my current job. My title is database analyst. The database is a SQL Server system and I am employed by the BU and not the IT department. The IT department likes to keep SQL Server within their 'center of excellence'. Consequently I am doing my work using MS Access even though I have more experience with SQL Server.


If you can access your databases through MS Access ( what a crime) why not just use SSMS to do you work ?

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Outer World
Outer World
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 70
If you can access your databases through MS Access ( what a crime) why not just use SSMS to do you work ?


Yep for sure. SSMS Express is free. It’s more about what has been acceptable to the organisation I am working in.
Jim P.
Jim P.
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1867 Visits: 2215
Outer World (12/8/2013)
If you can access your databases through MS Access ( what a crime) why not just use SSMS to do you work ?

Yep for sure. SSMS Express is free. It’s more about what has been acceptable to the organisation I am working in.


I can write a SQL query to do DML manipulations. You probably can as well. Can Joe in Accounting? How about Deb in Sales?

The advertisement in the 50's and 60's was that computers were meant to make life easier. Now we get to the oughts and you want Joe to learn stuff, compared to using Access to allow him to click a button? You, me and everyone in the DBA, programmer or similar IT roles should be making things easier for the end user. We should not add complication to anything for the end user.

If you do, please try to find a job as a government bureaucrat that has people fill out a required form because they don't have a family that needs insurance.



----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
Graeme100
Graeme100
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2380 Visits: 795
Interesting article.

Personally, I am a firm believer of becoming an expert. Someone who knows their job well. As a far as a DBA is concerned I think the newer versions are making the life of a DBA easier. This is great for the experienced DBA but for the newbie, this makes learning far harder as one is less likely to come across the little things that make up the 'learning' experience.

I think it is possible to to know less with the newer iterations of SQL and still be called a DBA. This allows a 'DBA' the time and perhaps necessity to learn other skills and become more of a jack of all trades.

Pros and Cons all round here but unless you have the mind-set and inclination I don't feel the role of DBA is as pure as it once was.



runaldo
runaldo
Old Hand
Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)

Group: General Forum Members
Points: 374 Visits: 566
I am a "production DBA" so my primary focus is to get the infrastructure in place, capacity planning, server functionality etc. As a senior dba I have 4-5 prioritised tasks:

1) SQL Skills
2) Procedural skills (ITIL stuff)
3) New version functionality (playing around with CTP's)
4) New hardware/virtual server delivery (wrestling with server and san guys).
5) Performance tune/fix errors in applications

Specially point 5 is "tricks of trade".



Miles Neale
Miles Neale
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4254 Visits: 1695
jianmin.c (12/6/2013)
I am a database administration, and also, I am the database developer, and then asp.net, C#, Jquery, Java script, CSS, front end developer; and also C#, windows programmer, and then, Microsoft BI, office 2010, 2007 powerpivot user to do rapid prototype, business analysis.
I work on SQL server 2008, SQL server 2005, create a new database, back up, and then, set up agents to report web database server daily disk space, database size, auto growth etc.
One of things brings me most concern is to how to create an IT career for myself, what is my best strategy to learn, grow, and also enjoy the short career I may have.
From other end, I also try to improve data structure, algorithm skills, improve my work performance etc.
I could not believe what I could do as one person; but the task I worked on opened my eye and forced me think smart and work smart.

I want to use an example to end my comment, what kind of work involves for you to send out market team thousands of contact in Microsoft outlook address book an email without being treated as spam?


Spam is in the eye of the beholder and not something that your application can control. However, there are some things you might do in "signing up" new members to the mailing list.

First ask those who signup to put the sender you use on their approved sender list. This will allow your email to pass into the inbox w/o turning it into spam.

Second the user or sender name you use might be a tip to some spam engines. Email from senders with names like NoReply@mySite.org can be caught or suspected by some spam engines. Lastly you might read a little on how spam engines determine what is or is not spam and avoid those practices.

But for those engines that look at a piece of mail and see that it has gone to 25k sites and that username is not on the approved list, it will more often then not get sent to the spam folder.

Good luck.

M.

Not all gray hairs are Dinosaurs!
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)SSC Guru (67K reputation)

Group: General Forum Members
Points: 67379 Visits: 18570
Flipz (12/6/2013)

There is a lot of confusion about what a SQL DBA should be doing as this is often confused with SQL Developer work which I believe is a different role. This confusion is really happening at the top level in organisations where team structures and job roles are decided.


I agree that DBA and Developer are different realms within SQL Server. Even within that, one could come down a bit more and get more specialized.

I'm not certain that the role of DBA is more difficult now than it was 10-15 years ago. Sure the technologies are different, and maybe we need to know a bit more about a few more technologies. But if you have been working with it for a while, then some of those things are a lot easier. Maybe it is more difficult for those fresh into the field when comparing now to 15 years ago. I think many of us probably thought it was plenty difficult 15 yrs ago as we cut our teeth on the product.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

streece56
streece56
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 0
In the two government entities that I have worked, the Database Administrator is a "Jack-of-all-trades" in the database world. Most Database Administrators within our organization work with a number of different databases. We are responsible for database backups, restores, specialized data processing, etc. I enjoy having a position with diversity, so the answer is yes - the Database Administrator is no longer just responsible for database backups, and restores.
dbassassin
dbassassin
Old Hand
Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)

Group: General Forum Members
Points: 320 Visits: 290
What is a Database Administrator today ...

any IT profressional that:

1. Has the ability to learn, very quickly
2. Needs no modifiers to be chill in the face of certain doom (you all know the doom I speak of)
3. Is not afraid of databases

Smile

Why is it that people who can't take advice always insist on giving it? - James Bond, Casino Royale
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search