SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • Training
  • FAQ's
  • Blogs
  • Software
  • Books
  • About Us
RSS Feeds
Sign in | Join


USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...
Latest Articles

A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server

More     
 
Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...
SQL Server Destination remote server error
Setting Up Data And Log Files For SQL Server
Will Check Constraints Improve Database Performance?

More     
   
Latest Software Reviews

dbForge Review
Spotlight on ApexSQL Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Data Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Doc 2008

More     

books >> sql server 2000 books >> Essential SQL Server 2000

Essential SQL Server 2000


Sep 15, 2004

Book Review

Essential SQL Server 2000
by Buck Woody
Copyright 2002
Addison-Wesley

 

Essential SQL Server 2000 Find out more about this book,
or purchase it, from Amazon.com

When a new release of SQL Server comes out, there are many books rushed to publication so that they are released at the same time the new version of SQL Server is released. Unfortunately, this "book rush" often leads to poor quality books. But if you wait some time after a  new version of SQL Server comes out, then the books you find tend to be of a little better quality. This is the case with Essential SQL Server 2000.

This is an introductory book on the basics of SQL Server 2000 administration, and provides a survey of all the key areas. It includes these topics:

  • Installing/Upgrading SQL Server 2000

  • Tools

  • Accessing Data

  • Importing and Exporting Data

  • Automation Using the SQL Server Agent

  • Maintenance

  • Backing Up and Restoring

  • Monitoring and Optimization

  • Security

  • Replication

  • Analysis Services Using OLAP

  • Extensible Markup Language

  • English Query

  • Working with Instances

One feature I really like about this book is that many of the common DBA activities are explained three ways. First, the task is explained using Enterprise Manager. Second, the task is explained using command line options, such as using stored procedures. And third, many practical, real-world examples are provided. This is much better than what many SQL Server intro books do, which either tend to mix Enterprise Manager and command line options (which is confusing for beginners), or ignoring command line options altogether.

The book does have a beginning chapter on performance tuning, although it is not very extensive. But I would not really expect a comprehensive discussion of SQL Server performance tuning in a beginner's book such as this one.

I recommend this book for people new to SQL Server 2000 and who want to learn the basics of how to administer SQL Server 2000.


        








C# Help and Tutorials | PHP MySQL Tutorial | Sharepoint Tutorial | Azure Tutorial | Cloud Hosting Magazine | ASP.NET Tutorials | Windows Server Help | Windows Phone Pro | Silverlight Ace | Visual Studio Tutorials | Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | SQL Server Training Videos | DBA FAQ's | Developer Peformance FAQ's | DBA Peformance FAQ's | Developer FAQ's | Clustering FAQ's | Error Messages | Audit Tool Reviews | Backup Tool Reviews | Coding Tool Reviews | Compare Tool Reviews | Documentation Tool Reviews | Design Tool Reviews | Monitoring Tool Reviews | Log Tool Reviews | Reporting Tool Reviews | Clustering Tool Reviews | Security Tool Reviews | Change Management Tool Reviews | Remote Access Tool Reviews | Book Reviews | Security Tool Reviews | ADO.NET / ASP.NET | Administration | Analysis/OLAP Services | Application Development | Configuration | Components | ETL | Hardware | High Availability | Hints | Index | Misc | Operating Systems | Performance Tuning | Replication | T-SQL | Views


              © 2010 Jude O'Kelly. All rights reserved