Accelerated SQL Server 2008 (Expert's Voice)

The expert tuition and approach to rapid learning in __Accelerated SQL Server 2008__, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer. * Lightning–quick introduction to SQL Server 2008 * Written by top experts in the field * Provides a solid grounding in key features and technologies ## What you’ll learn * Manage SQL Server installations through the brand–new Declarative Management Framework. * Protect yourself from downtime with high–availability features such as failover clustering. * Speed your applications by taking advantage of new performance–enhancement features in SQL Server 2008. * Find what you need using full–text search. * Store, retrieve, and manage XML in the database. * Derive competitive advantage from business intelligence tools such as Analysis Services and Reporting Services. ## Who is this book for? Database professionals who need to make the leap to SQL Server 2008, and who need to make that leap __quickly__. This audience primarily includes users of previous releases of SQL Server such as SQL Server 2000 and SQL Server 2005. The audience also includes database professionals with experience on competing platforms who are moving laterally to SQL Server.

The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the 2008 release of Microsoft’s flagship database management system quickly. Take full advantage of the features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer.

• Lightning–fast introduction to SQL Server 2008
• Written by top experts in the field
• Provides a solid grounding in key features and technologies

What you’ll learn

• Manage SQL Server installations through the brand–new Declarative Management Framework
• Protect yourself from downtime with high–availability features such as failover clustering
• Speed your applications by taking advantage of new performance–enhancement features in SQL Server 2008
• Find what you need using full–text search
• Store, retrieve, and manage XML in the database
• Derive competitive advantage from business intelligence tools such as Analysis Services and Reporting Services

Who this book is for

Database professionals who need to make the leap to SQL Server 2008, and who need to make that leap quickly. This audience primarily includes users of previous releases of SQL Server such as SQL Server 2000 and SQL Server 2005. The audience also includes database professionals with experience on competing platforms who are moving laterally to SQL Server.

Front Matter....Pages i-xxix Front Matter....Pages 1-1 SQL Server 2008 Overview....Pages 3-8 SQL Server Installation and Configuration....Pages 9-23 Front Matter....Pages 25-25 Policy Management....Pages 27-45 High Availability....Pages 47-80 Performance....Pages 81-108 Security....Pages 109-140 SQL Server Encryption....Pages 141-163 Automation and Monitoring....Pages 165-220 Service Broker....Pages 221-262 Integrated Full-Text Search....Pages 263-284 Front Matter....Pages 285-285 New Datatypes in SQL Server 2008....Pages 287-314 T-SQL Enhancements for Developers....Pages 315-366 T-SQL Enhancements for DBAs....Pages 367-401 .NET Integration....Pages 403-426 Programming Assemblies....Pages 427-471 SQL Server and XML....Pages 473-513 SQL Server XML and XQuery Support....Pages 515-552 LINQ to SQL....Pages 553-582 Front Matter....Pages 583-583 Reporting Services....Pages 585-640 Analysis Services....Pages 641-685 Front Matter....Pages 583-583 Integration Services....Pages 687-749 Back Matter....Pages 751-784 Accelerated SQL Server 2008 is a fast introduction to SQL Server 2008 for experienced database professionals. The book will appeal to readers who are smart, who learn fast, and who do not want to wade through a large amount of introductory material. The goal is to impart the essentials of using SQL Server 2008 as quickly as possible. Discusses SQL Server management technologies, performance and security issues, encryption, search functions, T-SQL programming for developers and administrators, SQL Server and XML, XQuery support, LINQ, and reporting, analysis, and integration services. One of the first books on SQL Server 2008 available, this title enables SQL Server database professionals to make the leap to the latest release on Microsoft's flagship database management system quickly Overview of SQL Server Enterprise data platform Development in SQL Server Business intelligence in SQL Server.