Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

DBA Support

By Steve Jones,

There was a time when I managed two production databases on SQL Server. Two. I had a development version of one database where we paused development for testing, and only two production databases to manage. Since I had to also handle development, application support and hardware repair/replacement, that seemed like plenty to me. I was the accidental DBA, with database administration being the lowest priority of my day.

After that I moved on to administer databases in a number of jobs, sometimes as a priority, sometimes not, but in each case, I learned to work more efficiently and effectively. My goal was to automate as much as possible of the routine work so that I could spend my days adding value to the company. I learned to use scripts, alerts, jobs, and more to keep systems running while I was doing other work.

I'm sure many of you work in a similar manner, or at least I hope you do. This Friday I wanted to ask you at what scale do you need to become efficient, based on the size of your organization. The question this week is:

How many databases does each DBA in your organization manage?

I know some of you manage lots of databases in raw numbers, but also let us know if you need to do much with these databases. Is maintenance automated, or is there much active management you need to do in order to ensure these databases are running on a weekly basis. Let us know the size of your load as well, perhaps the amount of data is a better way of measuring the DBA load.

Steve Jones

The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at You can also follow Steve Jones on Twitter:

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at They have a great version of Message in a Bottle if you want to check it out.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

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

URGENT - SQL Database Development Manager required! London

URGENT - SQL Database Development Manager required! - London



A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...


Maturing Your Database Development Process–Version Control

At Redgate Software, we have a progression of the stages of a database development pipeline. These a...


Podcast Announcements

Podcast Feeds


Is there integration of TFS 2008 source control with SQL Server 2008 Management Studio / Client tools for Database versioning???

Descriptive Tags: TFS 2008 source control , SQL Server 2008 Management Studio, SQL Server 2008 Clien...

friday poll