SQL Server websites and books

Microsoft SQL Server home page
SqlMag
Transact-SQL
MSDN/ SQL Server - Developer centre
About Sql Server - Database design and development
Disk Partition Alignment Best Practices
Microsoft MapPoint - Free mapping add on for SQL Server

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

sql 2008 book Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Brent Ozar et al
in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.

sql 2012 book Professional SQL Server 2012 Internals and Troubleshooting by Christian Bolton, Justin Langford et al
Quickly become familiar with the changes of this new release so that you can best handle database performance and troubleshooting.

Kalen Delaney book 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

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

SQL Cookbook 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'.

Downloads and utilities

SQL Express Edition

SQL Server Management Studio Express 2005 32 Bit or 2005 64 bit , 2008, 2008 R2, 2012
Use this to manage the SQL Server Express Database Engine.
Before installing SQL Server Management Studio Express, first install MSXML 6.0

Query Express - A free Query Analyzer look-alike

Command Line Utilities 11 for SQL Server Including SQLCMD and BCP

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)


© Copyright SS64.com 1999-2014
Some rights reserved