The DBA Blog by Tomer Lev

SQL information, scripts, tricks and more…

DBA Production Tasks

Here are some of production DBA tasks, I could think of:

Schema changes
Version Upload
Staging
Chrisis
SQL JOBS
ETL data transfer
Index maintenance
Backups
Permissions
monitoring
shrinks
server check
Archive data
Optimize queries
Programmers tasks
Reporting Services
Automate notifiations
High Availability
Scaling Up
OLAP cube – in case there is a need….
SSIS packages
Creating logical and physical objects
Establishing multiple DBEnvironment connections
Maintaining buffers for data and log pages
Managing transactions and locks

I’m sure there are more….

Advertisements

July 5, 2009 Posted by | General, SQL SERVER | | Leave a comment