Mastering SQL Server 2008 [Paperback]

Michael Lee (Author), Gentry Bieker (Author)

Book Description

Series: Mastering | Publication Date: January 20, 2009

As Microsoft’s bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.

Editorial Reviews

From the Back Cover

Harness the Powerful New Features of SQL Server 2008

Whether you're a database administrator or application developer, this in-depth guide is your key to delivering improved data collection, storage, reporting, and security with SQL Server 2008. Mastering SQL Server 2008 brings you up to speed on architecture, installation, and configuration essentials, before moving to the step-by-step instruction you need for more advanced topics such as procedural programming, query optimization, how to use spatial data, SQL Server in the .NET world, and more.

You'll master the extensive toolset, explore useful third-party tools, and most importantly, find out how to choose and use the right SQL Server features for the specific tasks you have.

Coverage includes:

• Installing and configuring SQL Server 2008

• Understanding SQL Server's place within the Microsoft architecture

• Making data reliably and efficiently available to your consumers

• Securing your data with SQL Server 2008's new Transparent Data Encryption feature

• Integrating XML technology into SQL Server

• Creating index architectures for maximum benefit and minimum cost

• Exploring new geometry and geography data types for today's businesses

• Maximizing data warehousing and business intelligence tools

About the Author

Michael Lee, MCT, MCITP, MCPD, SCJP, has been teaching SQL Server since 1995. Over the last 13 years, Michael has provided trainingand consulting services in SQL Server and Enterprise Data Architecture to companies across the U.S. and Europe. Gentry Bieker, MCT, MCITP, MCDBA, MCSE, has been a consultant, mentor, and trainer since 1998. He has been architecting, developing, and administering SQL Server databases since version 6.0.

Product Details

• Paperback: 792 pages
• Publisher: Sybex; 1 edition (January 20, 2009)
• Language: English
• ISBN-10: 047028904X
• ISBN-13: 978-0470289044
• Product Dimensions: 9.3 x 7.5 x 1.7 inches
• Shipping Weight: 2.4 pounds (View shipping rates and policies)
• Average Customer Review: 4.5 out of 5 stars  See all reviews (2 customer reviews)
• Amazon Best Sellers Rank: #463,703 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

1 of 1 people found the following review helpful:

4.0 out of 5 stars Good background for SQL admin, September 5, 2010

By 

Mr. Mark J. E. Ellis "Mark Ellis" (Sydney, Australia) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Mastering SQL Server 2008 (Paperback)

A well written, easy to read book. If you are looking for SQL programming and commands look elsewhere. If you are an experienced Windows Server admin wanting to increase your SQL skills for day to day admin tasks I highly recommend this book.

3 of 4 people found the following review helpful:

5.0 out of 5 stars Excellent book for everyone in the office, October 20, 2009

By 

Anthony Patton "Tony" (Las Vegas, NV) - See all my reviews
(REAL NAME)   

This review is from: Mastering SQL Server 2008 (Paperback)

I rarely write reviews, but I was shocked to see no one had reviewed this book yet. I have been working with SQL Server for a long time, so I am pretty critical of reference manuals overall. This book, however, does not disappoint. There is information in here that everyone in the office can use - from the standard 3 or 4 pages explaining normal form, to the chapter on using spatial data in 2008 (very cool). It's a really good and thorough reference, and these guys do a good job of giving you the information you need to make intelligent decisions. I have a couple of other books written by Michael Lee, and I really like his style. Lots of good information that's an easy read - the kind you have to write your name on the inside cover to make sure you get it back after you lend it out and it makes it's way around the office.