Member of the LearnItFirst.com Video Training Network	Related Video Training Sites: · SQL Programming Training Videos · SQL Server DBA Tutorials

Create a free account · Sign In

SQL Server 2005 Links and Resources

Feel free to use this page as your portal to the SQL Server 2005 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

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

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

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

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.

About Us

· Corporate Philosophy
· Advertise With Us
· Become an Author
· Contact Us

Video Playback

· System Requirements
· TSCC Codec (to play videos)
· Troubleshooting/Problems

Subscriptions

· Pricing/Buy Now
· Testimonials
· Privacy
· Terms of Service