Pro SQL Server 2005

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 tomastery 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-wonsolutions 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#