Latest in the news

Name

Download Last Modified
Oracle grid computing

Request

10/22/03

Organizing Your House: Step into a New DBA JOB

Name

Download Last Modified
Mapping the database environment architecture

Request

03/9/03

Establish Change Control process in your Environment

Request

03/9/03

Gather SLA

Request

03/9/03

Establish recovery model and backup strategy

Request

03/9/03

Establish Security audit

Request

03/9/03

Establish monthly and weekly maintenance routine

Request

03/9/03

Create state analysis document for your production critical processes, by doing SWAT analysis. Schedule follow up visit in two months to complete future recommendation.

Request

03/9/03

Best Full Life-Cycle Tools: ALL ROUNDER [Jack of all]

Name

Download Last Modified
Streamline your Developers: allow your developers to create New Development Database while maintaining corporate change control process. 

Request

03/9/03

Centralize all of your development database administration to a single utility: DBAArtisan 7.0

Request

03/9/03

Weekly Database server auditing utility: Sp_Audit

Request

03/9/03

Capacity planning

Request

03/9/03

Oracle and SQL Server cross-platform knowledge

Request

03/9/03

Free real-time monitoring tool for SQL servers: NETIQ

Request

03/9/03

Security Snapshot

Request

03/9/03

Data Warehouse DBA: Man In Black  [Brain behind the Executives!!!]

Name

Download Last Modified
Sample Production DBA checklist: XXX.XLS

Request

03/9/03

Ware-house staging architecture: 

Request

03/9/03

 ETL Data flow mapping:

Request

03/9/03

Executive/Sponsor checklist:

Request

03/9/03

Sample star-schema data-dictionary:

Request

03/9/03

Sample BI tools:

Request

03/9/03

Sample team readiness auditing utility:

Request

03/9/03

Sample OLAP forward engineering method:

Request

03/9/03

OLAP Do's and Don'ts checklist

Request

03/9/03

Sample reporting tools

Request

03/9/03

Cross-platform ETL Checklist

Request

03/9/03

SLA handbook

Request

03/9/03

Change control documentation hand-book

Request

03/9/03

Production DBA: Solider & COP  [Readiness is the job!!!]

Name

Download Last Modified
Sample Production Event Schedule reference: XXX.XLS

Request

03/9/03

Sample security standard document: Security_Standard.DOC

Request

03/9/03

 30% Time weekly process auditing. Sample process auditing schedule: DBA_audit_schedule.DOC

Request

03/9/03

Sample SA password maintenance standard: SA password standard.DOC

Request

03/9/03

Sample ideal backup recovery model: Recovery_Model.doc

Request

03/9/03

Sample Capacity planning

Request

03/9/03

Cross-platform DBMS knowledge

Request

03/9/03

Development lifecycle knowledge for a DBA

Request

03/9/03

Enterprise operating system environmental knowledge for a DBA

Request

03/9/03

Sample Weekly auditing report for a DBA

Request

03/9/03

Sample application for Database change control process and handing migration request to the production and QA environment.

Request

03/9/03

Development DBA: Artist and Minority Report Investigator [Imagination is the job!!!]

Name

Download Last Modified
Sample Naming convention: 

Request

03/9/03

Sample Data Flow Diagram: 

Request

03/9/03

Sample ERD: 

Request

03/9/03

Sample cross-platform development tool: 

Request

03/9/03

Sample Do's and Don'ts checklist: 

Request

03/9/03

Sample Data-mapping checklist: *.XLS

Request

03/9/03

Sample Data-dictionary

Request

03/9/03

Sample re-usable architecture for codes

Request

03/9/03

Sample reverse engineering process

Request

03/9/03

Best Article, White-Paper and Code reference Archive 

Name

Download Last Modified
Microsoft tech-net articles     
MSDN library articles    
OCP articles    
SQLPASS-MRG articles    
Best Online Reference Sites

Name

Microsoft R & D 
VLDB 
SQL-Performance Tuning 
OCP 
MCDBA 
Sybase
DB2
TPC.ORG
SQLPASS
SQL-MAG
Winnt-MAG
Oracle Magazine
DBAZine
PeopleSoft
SAP

 

Last updated Saturday January 24, 2004 05:02:46 PM by SQLPASS-MRG Webmaster