Feel free to use this page as your portal to the SQL Server 2000 community

General Microsoft SQL Server Home Page - A great resource for all versions of SQL Server SQL Server Worldwide Users Group - A great newsletter and a nice site MSDN's SQL Server Section - Code samples, articles and more PASS - Professional Association of SQL Server - Good links, articles, and event calender Sql-Server-Performance.com - A great resource for performance tuning SQL Server

Tools and Utilities Log Explorer - The best SQL Server log browsing tool on the market today DBArtisan - The standard tool suite for those DBAs and developers who work with multiple relational database management systems (such as Oracle, SQL Server, and DB2) ER/Studio - For you data modelers out there Best Practices Analyzer for SQL Server 2000 - Microsoft's SQL Server Best Practices Analyzer is a management tool that lets you verify the implementation of common usage and DBA-related Best Practices. Umachandar's SQL Server 2000 Scripts - Thank the world for this man's efforts because he sure has many interesting scripts Microsoft Visio - Microsoft Visio can do so many things to help you diagram, plan and even reverse engineer databases that it is considered a primary tool by many network administrators, sysadmins, DBAs, data modelers, and programmers/developers.

Recommended Books Professional SQL Server 2000 Programming - Recommended by Scott Whigham (author of LearnSqlServer.com) as best book for newbies and beginners to SQL Server 2000 Kalen Delaney's "Inside SQL Server 2000" - This book by Kalen Delaney is long-regarded as the best way to take that next-step from intermediate-level to guru Ken Henderson's "The Guru's Guide to Transact SQL" - You just can't find a better book on SQL Server. This was book could've been written in 1979 but it wouldn't matter; even when SQL Server 2010 (or whatever) comes out, it will still be relevant. A classic! Ken Henderson's "The Guru's Guide to SQL Server Stored Procedures, XML, and HTML" - There's a definite list of "World's Greatest Authors for SQL Server" and Ken Henderson has to be 1 or 2. Buy this book if you develop stored procedures - end of story; just ignore the XML part if you have SQL 2005. Ken Henderson's "The Guru's Guide to SQL Server Architecture and Internals" - This book is written for SQL Server 2000 but many of the same concepts are still valid for SQL Server 2005. SQL Queries for Mere Mortals - Michael Hernandez has just a way of explaining things like JOINs and subqueries that just clicks. Be aware that this book is about SQL, not a particular implementation of SQL Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook - Ken England gives a great treatise on execution plans, query tuning and index design in this SQL Server standard Microsoft SQL Server 2000 Bible - Paul Nielsen is a SQL guru - there's no question. This book is a huge tome of great SQL info and comes highly recommended for newbies and intermediate-level DBAs and developers Database Design for Mere Mortals - Another Michael Hernandez gem and, of course, it's an industry standard. Be aware that this book is about SQL, not a particular implementation of SQL SQL for Smarties: Advanced SQL Programming - Joe Celko is the guru's guru and we all just want to be half as smart as him. Be aware that this book is about SQL, not a particular implementation of SQL SQL Puzzles and Answers - How fun - a whole book of nothing but schema puzzles and query puzzles. Be aware that this book is about SQL, not a particular implementation of SQL An Introduction to Database Systems - This is the seminal work - the collegiate textbox from which much of today's books refer back to. Be aware that this book is about SQL, not a particular implementation of SQL