The Seven Deadly Habits of a DBA… And How to Cure Them
Calling widespread bad habits in database administration "deadly" may seem extreme. However, when you consider the critical nature of most…
Part of the
network
network
Tag: database administration
SQL Server Jobs Can Negatively Affect Performance, If You Are Not Careful
Virtually every SQL Server runs one or more daily jobs. And most likely, runs many weekly jobs. Unfortunately, most DBAs…
Operating System Performance Checklist
Like SQL Server, Windows Server is mostly self-tuning. But like SQL Server, there are things we can do to help…
SQL Server Hardware Performance Checklist
Auditing SQL Server Hardware Is An Important Early Step
Embarcadero Releases Embarcadero DBArtisan and DBArtisan Workbench 8.0
New Version of DBArtisan and DBArtisan Workbench Significantly Extends DBA Solutions for DB2, Oracle, SQL Server, and Sybase.
Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair
Up to the version 7.5 Microsoft Great Plains, and if you are looking to version 7.0, 6.0, 5.5, 5.0 or…
Introduction To Performance Tuning Exam (1Z0-033) of Oracle 9i DBA Track
Benefits of Oracle Certification In the present day competitive world, it has become essential for professionals, especially in the field…
Alert! Alert! Alert! Backup and Restore Baby!
At many organizations I doubt red lights flash with the sound of blaring sirens when backups fail in production environments,…
The Self-Taught DBA
You can't go to college to become a DBA. Sure, you can take some basic classes on database theory and…
SQL Server Upgrade Recommendations and Best Practices – Part 2
The first article of the series, Part 1 - Upgrade Overview and Project Planning, detailed the business justification for upgrades…
