Few days ago, I reviewed SQLAuthority News – Book Review – SQL Server 2005 Management and Administration (Paperback) on this blog. I received few comments on this review. Some people think it is good book, some thought that this waste of time. Well, after so many emails, I feel that I should point out something special about this book, which attracted me.
The reason, I decided to review this book is practical advise, rather then some technical long answer. Technical answers have their places and helps to fix issues in most cases, however common sense is extremely important. To prove that this book gives practical answers, I have copied one of the section from this book and listed only few of the topics from that section.
I have received authorization from publisher to review this book, this article does not violate any copyright issues.
- Conduct general health checks every 6 to 12 months.
- Create documentation and associate it with production and test SQL Servers to supplement operations and routine maintenance.
- Identify all the health issues during the health check and then develop a remediation plan. Don’t try to fix the issues during the health check because doing so muddles the results and slows down the health check process. And the fix for one issue might affect another.
- Retain all health check documentation and information for future use.
- Using SQL Server 2005 BPA is the most efficient way to scan the core components of SQL Server 2005.
- When using a locally attached storage, isolate the operating system from the database and transaction logs, preferably on separate RAID volumes.
- Allocate enough space on mission-critical databases and transaction logs to accommodate their growth.
- Manage antivirus scanning, excluding specific files within SQL Server.
- Use Windows Authentication.
- No one should log in as the Service Account to do administration.