| |
[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] 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.
|
|
