Pro SQL Server 2005 Second Edition Author:Michael Coles, Louis Davidson, Robin Dewson, Fabio Claudio Ferracchiati, Adam Machanic, Jan D. Narkiewicz, Thomas Rizzo, Joseph Sack, Julian Skinner, Rob Walters 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 S... more »erver 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