SQL Server MVP Deep Dives, Volume 2

Summary

SQL Server MVP Deep Dives, Volume 2 is a unique book that lets you learn from the best in the business - 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques...and more.

About this Book

To become an MVP requires deep knowledge and impressive skill. Together, the 64 MVPs who wrote this book bring about 1,000 years of experience in SQL Server administration, development, training, and design. This incredible book captures their expertise and passion in 60 concise, hand-picked chapters and offers valuable insights for readers of all levels.

SQL Server MVP Deep Dives, Volume 2 picks up where the first volume leaves off, with completely new content on topics ranging from testing and policy management to integration services, reporting, and performance optimization. The chapters fall into five parts: Architecture and Design, Database Administration, Database Development, Performance Tuning and Optimization, and Business Intelligence.

Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

What's Inside

Discovering servers with PowerShell

Using regular expressions in SSMS

Tuning the Transaction Log for OLTP

Optimizing SSIS for dimensional data

Real-time BI and much more

Manning Publications and the authors of this book support the children of Operation Smile, an international children's medical charity that performs free reconstructive surgery for children suffering from facial deformities such as cleft lips and cleft palates by mobilizing medical volunteers who provide education and training programs to local doctors on the latest surgical techniques.

===============================================

Table of Contents

PART 1 ARCHITECTURE Edited by Louis Davidson

PART 2 DATABASE ADMINISTRATION Edited by Paul Randal and Kimberly Tripp

PART 3 DATABASE DEVELOPMENT Edited by Paul Nielsen

PART 4 PERFORMANCE TUNING AND OPTIMIZATION Edited by Brad M. McGehee

PART 5 BUSINESS INTELLIGENCE Edited by Greg Low