SQL Server MVP Deep Dives, Volume 2

SQL Server MVP Deep Dives, Volume 2

<div><p><b>Summary</b> </p><p><i>SQL Server MVP Deep Dives, Volume 2</i> 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. </p> <b>About this Book</b> <p>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.</p> <p><i>SQL Server MVP Deep Dives, Volume 2</i> 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.</p> <p> 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. </p> <b>What's Inside</b><ul><li>Discovering servers with PowerShell</li> <li>Using regular expressions in SSMS</li> <li>Tuning the Transaction Log for OLTP</li> <li>Optimizing SSIS for dimensional data</li> <li>Real-time BI and much more</li></ul><p>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.</p> <p>========================================​=======</p> <b><h4>Table of Contents</h4></b> <ol><h5>PART 1 ARCHITECTURE <i>Edited by Louis Davidson</i></h5> <li>Where are my keys? <i>by Ami Levin</i></li> <li>"Yes, we are all individuals" A look at uniqueness in the world of SQL <i>by Rob Farley</i></li> <li>Architectural growth pains <i>by Chris Shaw</i></li> <li>Characteristics of a great relational database <i>by Louis Davidson</i></li> <li>Storage design considerations <i> by Denny Cherry</i></li> <li>Generalization: the key to a well-designed schema <i>by Paul Nielsen</i></li> <h5>PART 2 DATABASE ADMINISTRATION <i>Edited by Paul Randal and Kimberly Tripp</i></h5> <li>Increasing availability through testing <i>by Allan Hirt</i></li> <li>Page restores <i>by Gail Shaw</i></li> <li>Capacity planning <i>by Greg Larsen</i></li> <li>Discovering your servers with PowerShell and SMO <i>by Joe Webb</i></li> <li>Will the real Mr. Smith please stand up? <i>by John Magnabosco</i></li> <li>Build your own SQL Server 2008 performance dashboard <i>by Pawl Potasinski</i></li> <li>SQL Server cost recovery <i>by Peter Ward</i></li> <li>Best practice compliance with Policy-Based Management <i>by Rod Colledge</i></li> <li>Using SQL Server Management Studio to the fullest <i>by Rodney Landrum</i></li> <li>Multiserver management and Utility Explorer - best tools for the DBA <i>by Satya Shyam K. Jayanty</i></li> <li>Top 10 SQL Server admin student misconceptions <i>by Tibor Karaszi</i></li> <li>High availability of SQL Server in the context of Service Level Agreements <i>by Tobiasz Janusz Koprowski</i></li> <h5>PART 3 DATABASE DEVELOPMENT <i>Edited by Paul Nielsen</i></h5> <li>T-SQL: bad habits to kick <i>by Aaron Bertrand</i></li> <li>Death by UDF <i>by Kevin Boles</i></li> <li>Using regular expressions in SSMS <i>by John Paul Cook</i></li> <li>SQL Server Denali: what's coming next in T-SQL <i>by Sergio Govoni</i></li> <li>Creating your own data type <i>by Hugo Kornelis</i></li> <li>Extracting data with regular expressions <i>by Matija Lah</i></li> <li>Relational division <i>by Peter Larsson</i></li> <li>SQL FILESTREAM: to BLOB or not to BLOB <i>by Ben Miller</i></li> <li>Writing unit tests for Transact-SQL <i>by Luciano Moreira</i></li> <li>Getting asynchronous with Service Broker <i>by Mladen Prajdic</i></li> <li>Effective use of HierarchyId <i>by Denis Reznik</i></li> <li>Let Service Broker help you scale your application <i>by Allen White</i></li> <h5>PART 4 PERFORMANCE TUNING AND OPTIMIZATION <i>Edited by Brad M. McGehee</i></h5> <li>Hardware 201: selecting and sizing database server hardware <i>by Glenn Berry</i></li> <li>Parameter sniffing: your best friend...except when it isn't <i>by Grant Fritchey</i></li> <li>Investigating the plan cache <i>by Jason Strate</i></li> <li>What are you waiting for? An introduction to waits and queues <i>by Robert Pearl</i></li> <li>You see sets, and I see loops <i>by Linchi Shea</i></li> <li>Performance-tuning the transaction log for OLTP workloads <i>by Brad M. McGehee</i></li> <li>Strategies for unraveling tangled code <i>by Jennifer McCown</i></li> <li>Using PAL to analyze SQL Server performance <i>by Tim Chapman</i></li> <li>Tuning JDBC for SQL Server <i>by Jungsun Kim</i></li> <h5>PART 5 BUSINESS INTELLIGENCE <i>Edited by Greg Low</i></h5> <li>Creating a formal Reporting Services report part library <i>by Jessica M. Moss</i></li> <li>Improving report layout and visualization <i>by Greg Low</i></li> <li>Developing sharable managed code expressions in SSRS <i>by William Vaughn</i></li> <li>Designing reports with custom MDX queries <i>by Paul Turley</i></li> <li>Building a scale-out Reporting Services farm <i>by Edwin Sarmiento</i></li> <li>Creating SSRS reports from SSAS <i>by Robert Cain</i></li> <li>Optimizing SSIS for dimensional data loads <i>by Michael Coles</i></li> <li>SSIS configurations management <i>by Andy Leonard</i></li> <li>Exploring different types of enumerators in the SSIS Foreach Loop container <i>by Abolfazl Radgoudarzi and Shahriar Nikkhah</i></li> <li>Late-arriving dimensions in SSIS <i>by John Welch</i></li> <li>Why automate tasks with SSIS? <i>by Ted Krueger</i></li> <li>Extending SSIS using the Script component <i>by Tim Mitchell</i></li> <li>ETL design checklist <i>by Rafael Salas</i></li> <li>Autogenerating SSAS cubes <i>by Johan Ahlen</i></li> <li>Scripting SSAS databases - AMO and PowerShell, Better Together <i>by Darren Gosbell</i></li> <li>Managing context in MDX <i>by Boyan Penev</i></li> <li>Using time intelligence functions in PowerPivot <i>by Thiago Zavaschi</i></li> <li>Easy BI with Silverlight PivotViewer <i>by Gogula Aryalingam</i></li> <li>Excel as a BI frontend tool <i>by Pedro Perfeito</i></li> <li>Real-time BI with StreamInsight <i>by Allan Mitchell</i></li> <li>BI solution development design considerations <i>by Siddharth Mehta</i></li></ol></div>