The Informit SQL Server Reference Guide: Techniques, Insight, and Practical Advice on SQL Server

by Buck Woody

Informit.com brings its SQL Server online reference guide to print! The SQL Server Reference Guide strikes a balance between basic information and more advanced topics. You can use this book as a training guide for a new DBA, or as a reference in case you're managing SQL Server for the first time after working with other relational systems. You'll also find helpful code to manage, maintain, and document your servers. All in all, this book is an excellent addition to your technical library. Chapter 1 deals with the architecture of SQL Server. Here you'll learn things like what each edition of SQL Server has to offer and why you should choose one version over another. Chapter 2 deals with one of the most important topics in SQL administration. This chapter covers everything from backups and maintenance to system sizing and filegroup placement. Chapter 3 helps you to understand database design, from the basics of tables and indexes to stored procedures and user-defined functions. With your databases laid out in perfect form, you'll need to concern yourself with performance tuning. Chapters 4 and 5 address this topic, focusing heavily on the most important thing you can indexes. Chapters 6-9 cover the wide topic of database programming, from getting requirements from your users to learning Transact-SQL to forming efficient queries. Finally, Chapter 10 explores professional development for the DBA.

545 pages, Paperback

Published January 1, 2006