SQL Server websites and books

Microsoft SQL Server home page
MSDN/ SQL Server - Developer centre

Microsoft books online - T-SQL Reference: SQL 2000 | SQL 2005 | SQL 2008

Murach's SQL Server 2005 for Developers by Bryan Syverson, Joel Murach
Optimize query performance, use views and stored procedures, manage multiple databases.

Kalen Delaney MVP
Practical, hands-on guidance for SQL Server with numerous code samples, table examples, practical advice, and best practices.
Inside Microsoft SQL Server 2005: The Storage Engine by Kalen Delaney MVP
Inside Microsoft SQL Server 2005: Query Tuning and Optimization by Kalen Delaney MVP
Inside Microsoft SQL Server 2008: Internals by Kalen Delaney MVP

Beginning Transact-SQL With SQL Server 2005 by Paul Turley et al
Optimize query performance, use views and stored procedures, manage multiple databases.

SQL Server 2005 Administrator's Pocket Consultant by William R. Stanek
Straightforward reference guide
Sample chapter (Importing and Exporting with DTS and BCP)

The Data Warehouse Toolkit by Ralph Kimball
The one must-read data warehousing book.

SQL Cookbook by Anthony Molinaro
Each recipe demonstrates how to accomplish a given task. Perfect for quick example code to 'make it do the right thing'.

SQL Server downloads and utilities

SQL Server Management Studio Express - Manage the SQL Server Express Database Engine.
Query Express - A free Query Analyzer look-alike
Microsoft Log Parser 2.2 - Tool to run SQL queries against a variety of log files, export to SQL table or CSV.
Online SQL formatter - dpriver.com

Related

SS64 SQL Server discussion forum
Newsgroup: microsoft.public.sqlserver.server

Book links on this page are in association with Amazon.com

"we'll ship it when it is ready" - Paul Flessner (Microsoft VP databases)


Back to the Top

© Copyright SS64.com 1999-2010
Some rights reserved