9781590598887: Pro SQL Server 2005, Second Edition
View all copies of this ISBN edition:

Pro SQL Server 2005, Second Edition is a revised and expanded version of this classic and bestselling book, which provides in-depth coverage of all the key new SQL Server features and enhancements. It focuses on what experienced SQL Server DBAs, developers, and Business Intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. Each new feature is carefully presented and precisely illustrated using examples to show you how to use it most effectively. The second edition expands on the original by adding chapters on encryption, full-text search, LINQ, and the ADO.NET 3.0 Entity Data Model, bringing it up to date for .NET 3.5, and making it even more attractive than ever to readers.

You'll find incisive, expert guidance on all of the major new functionality of SQL Server 2005 under one cover, including essential topics for all SQL Server professionals, such as

  • Transact-SQL enhancements
  • SQL Server Management Studio
  • CLR integration and programming stored procedures in C#
  • SQL Server Reporting Services enhancements
  • SQL Server Analysis Services enhancements
  • The new XML datatype and XQuery support
  • Security enhancements and Service Broker
  • SQL Server Integration Services for data extraction, transformation, and loading
  • Encryption
  • Full-text search
  • ADO.NET 3.0 Entity Data Model

A team of expert authors provides practical, in-depth coverage of the core topics each specializes in--all supported by realistic examples, so you'll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race to mastery of SQL Server 2005!

What you'll learn

  • How to use enhanced T-SQL statements and features
  • How to use SQL Server Management Studio to manage databases
  • How to program stored procedures in C# with SQLCLR
  • How to use Reporting Services and Analysis Services enhancements
  • How to use the new XML datatype and XQuery support
  • How to take advantage of enhanced security features
  • How to use Service Broker
  • How to use Integration Services to extract, transform, and load data
  • How to encrypt and decrypt data
  • How to do full-text searches
  • How to simply access data with LINQ
  • How to use the ADO.NET 3.0 Entity Data Model

Who is this book for?

Pro SQL Server 2005, Second Edition is for every experienced SQL Server 2000 user who wants to quickly learn about the many major new features of SQL Server 2005. It's also for experienced SQL Server 2005 users who need to quickly master new features and exploit them to solve problems in a more efficient and effective way. Each chapter is a self-contained, in-depth introduction to a new feature. The wealth of information contained makes the book an indispensable reference for every database user, programmer, and administrator.

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard-won solutions to problems you will face in your professional programming career.

Related Titles from Apress

  • Pro T-SQL 2005 Programmer's Guide
  • Pro SQL Server 2005 Reporting Services
  • Foundations of SQL Server 2005 Business Intelligence
  • Expert C# 2005 Business Objects. Second Edition
  • Foundations of LINQ in C#

"synopsis" may belong to another edition of this title.

About the Author:

Michael Coles has over a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He received a bachelor's of science (magna cum laude) in information technology from American Intercontinental University. A member of the United States Army Reserve, he was activated for two years following 9/11.

"About this title" may belong to another edition of this title.

(No Available Copies)

Search Books:

Create a Want

If you know the book but cannot find it on AbeBooks, we can automatically search for it on your behalf as new inventory is added. If it is added to AbeBooks by one of our member booksellers, we will notify you!

Create a Want

Other Popular Editions of the Same Title

9781590594773: Pro SQL Server 2005

Featured Edition

ISBN 10:  1590594770 ISBN 13:  9781590594773
Publisher: Apress, 2006