Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

 

   
  SQL Server Tips by Burleson

What Self-Managing Does Not Mean

While some enhancements are likely to get applause from DBAs and IT managers alike, the majority of critical database tasks and decisions still, and will probably always, require a trained DBA’s hand. Those thinking that the new self-management features will do away with the requirement for good DBAs are quite wrong. No matter how self-managing a database is, it will never be able to:

Design Itself: An experienced administrator or data architect is still needed to intelligently create the logical and physical design of a database for real world use. This applies even with auto-storage management.

Build Itself: An administrator will always be needed to smartly implement a physical database design and configure server resource constraints so it can stand up against today’s demanding applications.

Secure Itself: Security management is still a process that must be carefully carried out under a trained administrator’s eye.

Develop Itself: Many DBAs are called upon to help write or troubleshoot database procedural logic that is produced by a development/application staff.

Change Itself: A database cannot perform true automatic change control in terms of: smartly adding/dropping table columns; reworking security; changing index strategies, although the engines are getting better at this; or altering stored procedural code.

Test Itself: The concept of proper performance testing is not only foreign to the self-management aspects of database engines, but sadly to many DBAs as well.

Recover Itself: Yes, the automated functions of backup and recovery are much better than they were in the past. However, an administrator is still needed to properly set up, monitor, and oversee critical backup and recovery procedures.
No matter how far down the manageability path a database evolves, the disciplines mentioned above make it impossible for a serious production database to ever truly manage itself in the literal sense. Even in the areas of self-managed performance and storage, the latest releases of the database engines are not 100% complete.


The above book excerpt is from:

High-Performance SQL Server DBA
Tuning & Optimization Secrets

ISBN: 0-9761573-6-5
Robin Schumacher

 http://www.rampant-books.com/book_2005_2_sql_server_dba.htm  

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster



Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks
 

Hit Counter