[2005-07-18] Synchronize multiple MySQL Databases with PHP
PIM Team Case Study
[2005-07-11] Moving A SQL Server Database
A database move can be done a couple different ways, but when the database is updated frequently and the move needs to be completed with minimal downtime and no data loss, it is best to move it by detaching and then reattaching the database on the new server. The database will be offline during the move but it is better to have it offline than to miss transactions when backing up and then restoring the database on the new server.
[2005-07-11] Get Down With OCP: Evaluating DBA Job Applicants in an OCP World
Not long ago, weeding through DBA applicants with a tech interview was a straightforward process. You'd ask candidates 200 or so technical questions.
[2005-07-11] Change Password for SQL Server User
Most security experts' recommendations include changing passwords frequently to enhance security. It is easy to change the password on a SQL Server Username via Query Analyzer.
[2005-07-11] Indexes: An Overview and Maintenance for Performance
Many people know the importance of creating indexes on SQL Server database tables. Indexes greatly improve the performance of a database.