This Black Book shows you how to harness the full power of SQL Server 2008 R2 in your enterprise-level development or support efforts. It helps you to leverage the full potential of relational database technology to create a state of- the-art database solution with Reporting Services, Analysis Services, and Master Data Services. This comprehensive reference will help you learn SQL Server 2008 R2 quickly and easily. It covers the entire spectrum of SQL Server 2008 R2-Transact-Structured Query Language (T-SQL), SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Integrated Full-Text Search, Database Mirroring, Policy-Based Management, Reporting Services, Analysis Services, Integration Services, Master Data Services, and PowerPivot. Filled with examples and troubleshooting solutions, this book is your one stop reference for SQL Server 2008 R2; no doubt, every aspect is worth the price of the entire book.

About the Author

Kogent Learning Solutions Inc.

Table of Contents:
· Introducing SQL Server 2008 R2 · Introducing SQL Server 2008 R2 Tools · Building SQL Server Databases · SQL Statements,Operators, and Functions · Programming with T-SQL - I & II · Stored Procedures and User-Defined Functions · Triggers in SQL Server 2008 R2 · Cursors in SQL Server 2008 R2 · Managing Transactions and Locking · Error Handling in SQL Server 2008 R2 · Monitoring, Auditing, and Maintaining SQL Server · Data Replication · Log Shipping and Database Mirroring · Implementing Failover Clustering · Performing Bulk Copy Operations · SQL Server Service Broker · Policy-Based Management · Automating SQL Server 2008 R2 · Performance Optimization with Query Execution Plans · Indexing and Partitioning · Working with Full-Text Search · Data Compression · Resource Governor · Security in SQL Server 2008 R2 · Backing Up and Restoring Databases · SQL Server Reporting Services · SQL Server Analysis Services · SQL Server Integration Services · SQL Server 2008 R2 and XML · SQL Server 2008 R2 and Common Language Runtime · SQL Server 2008 R2 and Language-Integrated Query · Appendices: Migrating from MS Access to SQL Server · Spatial Data Types · xploring System Functions · Assemblies in SQL Server 2008 R2 · SQL Server Compact 3.5 SP2 · Management Data Warehouse in SQL Server 2008 R2 · Master Data Services · PowerPivot for Excel