SQL Server websites and books

Microsoft SQL Server home page
Transact-SQL reference
SQL Server - Documentation centre
Ola Hallegren - backup scripts.
About Sql Server - Database design and development
Disk Partition Alignment Best Practices (SQL 2012 / 2014)

Recommended Books

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.

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 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
DBA Tools - PowerShell tools to Automate Instance to Instance Migration.
Command Line Utilities 14 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.
Instant SQL formatter - Online code tidy, upper/lower case etc.

Related

SS64 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 © 1999-2024 SS64.com
Some rights reserved