[2004-12-20] SQL Server Database Settings Performance Checklist
Each Database Needs to Be Audited
As part of your performance audit, you need to examine each database located on your server and examine some basic database settings. When compared to some of our other performance audit tasks, you will find this audit one of the easiest. For convenience, you may want to consider photocopying a copy of the above chart, producing one copy for each database that you will be auditing.
[2004-12-17] SQL Server Configuration Performance Checklist
Most SQL Server Configuration Settings Should Not Be Changed
[2004-12-16] 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 optimize Windows' performance.
[2004-12-10] SQL Server Hardware Performance Checklist
Auditing SQL Server Hardware Is An Important Early Step
[2004-12-09] Embedded Databases
An Embedded database is a specific database genus that does not run as a separate process, instead, it is directly linked ("embedded") into the application. Herein, the database is integrated into the application and the end-user has little or no knowledge that the database exists. Embedded databases are sometimes referred to as "fire and forget" or "implement and forget" databases, since they require no or minimal database administration.
[2004-12-07] How to Identify and Delete Duplicate SQL Server Records
Recently, I was asked to help someone clean up their database after they had double loaded an import file.
[2004-12-07] Using Performance Monitor to Identify SQL Server Hardware Bottlenecks
The best place to start your SQL Server performance audit is to begin with the Performance Monitor (System Monitor). By monitoring a few key counters over a 24 hour period, you should get a pretty good feel for any major hardware bottlenecks your SQL Server is experiencing.
[2004-12-03] Backing Up And Restoring Your MySQL Database
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.