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

Create a free account · Sign In

Transact SQL Links and Resources

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

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.

SqlSpec - Database Documentor - "SqlSpec" creates comprehensive, easily navagable documentation for your SQL Server databases. Most data dictionary software runs $199-$499 which makes the $20 you'll spend on SqlSpec a tremendous deal.

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