Friday, January 29, 2010

DBA Check List

Below is an outline of the items that need to be considered for a DBA role. Being a DB Developer/DBA I find this list to be a great starting point. Depending on the type of environment you have some of these items may be overkill or just not needed.

Link to full pdf version
  • General DBA Best Practices
    • Best Practices for Becoming an Exceptional SQL Server DBA
    • Day-to-Day
    • Installation
    • Upgrading
    • Security
    • Job Maintenance
      SQL Server Configuration Settings
    • Database Settings
    • Replication

  • High Availability Best Practices
    • General High Availability
    • Disaster Recovery
    • Backup
    • Clustering
      SQL Server Mirroring
    • Log Shipping

  • Performance Tuning Best Practices
    • Performance Monitoring
    • Hardware Performance Tuning
    • Indexing
    • SQL Server 2008 Compression Best Practices
    • SQL Server 2008 Data Collector Best Practices
      Best Practices for Resource Governor

  • Application Design and Coding Best Practices
    • Database Design
    • Queries and Stored Procedures
    • Transact-SQL
    • SQL Server CLR
    • XML

  • SQL Server Component Best Practices
    • SSIS
    • Reporting Services
    • Analysis Services
    • Service Broker

Source article

0 comments:

Post a Comment