{"product_id":"9781617290473","title":"SQL Server MVP Deep Dives, Volume 2","description":"\u003cp\u003e\u003cb\u003eSummary\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003e \u003ci\u003eSQL Server MVP Deep Dives, Volume 2\u003c\/i\u003e 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. \u003c\/p\u003e\u003cp\u003e \u003cb\u003eAbout this Book\u003c\/b\u003e \u003c\/p\u003e\u003cp\u003eTo 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.\u003c\/p\u003e\u003cp\u003e \u003ci\u003eSQL Server MVP Deep Dives, Volume 2\u003c\/i\u003e 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.\u003c\/p\u003e\u003cp\u003ePurchase 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. \u003c\/p\u003e\u003cp\u003e \u003cb\u003eWhat's Inside\u003c\/b\u003e \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDiscovering servers with PowerShell\u003c\/li\u003e\n\u003cli\u003eUsing regular expressions in SSMS\u003c\/li\u003e\n\u003cli\u003eTuning the Transaction Log for OLTP\u003c\/li\u003e\n\u003cli\u003eOptimizing SSIS for dimensional data\u003c\/li\u003e\n\u003cli\u003eReal-time BI and much more\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eManning 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.\u003c\/p\u003e\u003cp\u003e========================================​=======\u003c\/p\u003e\u003cp\u003e \u003cb\u003e \u003cb\u003eTable of Contents\u003c\/b\u003e \u003c\/b\u003e \u003c\/p\u003e\u003col\u003e \u003cb\u003ePART 1 ARCHITECTURE \u003ci\u003eEdited by Louis Davidson\u003c\/i\u003e \u003c\/b\u003e \u003cli\u003eWhere are my keys? \u003ci\u003eby Ami Levin\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003e\"Yes, we are all individuals\"A look at uniqueness in the world of SQL \u003ci\u003eby Rob Farley\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eArchitectural growth pains \u003ci\u003eby Chris Shaw\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eCharacteristics of a great relational database \u003ci\u003eby Louis Davidson\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eStorage design considerations \u003ci\u003e by Denny Cherry\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eGeneralization: the key to a well-designed schema \u003ci\u003eby Paul Nielsen\u003c\/i\u003e \u003c\/li\u003e \u003cb\u003ePART 2 DATABASE ADMINISTRATION \u003ci\u003eEdited by Paul Randal and Kimberly Tripp\u003c\/i\u003e \u003c\/b\u003e \u003cli\u003eIncreasing availability through testing \u003ci\u003eby Allan Hirt\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003ePage restores \u003ci\u003eby Gail Shaw\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eCapacity planning \u003ci\u003eby Greg Larsen\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eDiscovering your servers with PowerShell and SMO \u003ci\u003eby Joe Webb\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eWill the real Mr. Smith please stand up? \u003ci\u003eby John Magnabosco\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eBuild your own SQL Server 2008 performance dashboard \u003ci\u003eby Pawl Potasinski\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eSQL Server cost recovery \u003ci\u003eby Peter Ward\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eBest practice compliance with Policy-Based Management \u003ci\u003eby Rod Colledge\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eUsing SQL Server Management Studio to the fullest \u003ci\u003eby Rodney Landrum\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eMultiserver management and Utility Explorer - best tools for the DBA \u003ci\u003eby Satya Shyam K. Jayanty\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eTop 10 SQL Server admin student misconceptions \u003ci\u003eby Tibor Karaszi\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eHigh availability of SQL Server in the context of Service Level Agreements \u003ci\u003eby Tobiasz Janusz Koprowski\u003c\/i\u003e \u003c\/li\u003e \u003cb\u003ePART 3 DATABASE DEVELOPMENT \u003ci\u003eEdited by Paul Nielsen\u003c\/i\u003e \u003c\/b\u003e \u003cli\u003eT-SQL: bad habits to kick \u003ci\u003eby Aaron Bertrand\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eDeath by UDF \u003ci\u003eby Kevin Boles\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eUsing regular expressions in SSMS \u003ci\u003eby John Paul Cook\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eSQL Server Denali: what's coming next in T-SQL \u003ci\u003eby Sergio Govoni\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eCreating your own data type \u003ci\u003eby Hugo Kornelis\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eExtracting data with regular expressions \u003ci\u003eby Matija Lah\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eRelational division \u003ci\u003eby Peter Larsson\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eSQL FILESTREAM: to BLOB or not to BLOB \u003ci\u003eby Ben Miller\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eWriting unit tests for Transact-SQL \u003ci\u003eby Luciano Moreira\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eGetting asynchronous with Service Broker \u003ci\u003eby Mladen Prajdic\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eEffective use of HierarchyId \u003ci\u003eby Denis Reznik\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eLet Service Broker help you scale your application \u003ci\u003eby Allen White\u003c\/i\u003e \u003c\/li\u003e \u003cb\u003ePART 4 PERFORMANCE TUNING AND OPTIMIZATION \u003ci\u003eEdited by Brad M. McGehee\u003c\/i\u003e \u003c\/b\u003e \u003cli\u003eHardware 201: selecting and sizing database server hardware \u003ci\u003eby Glenn Berry\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eParameter sniffing: your best friend...except when it isn't \u003ci\u003eby Grant Fritchey\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eInvestigating the plan cache \u003ci\u003eby Jason Strate\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eWhat are you waiting for? An introduction to waits and queues \u003ci\u003eby Robert Pearl\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eYou see sets, and I see loops \u003ci\u003eby Linchi Shea\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003ePerformance-tuning the transaction log for OLTP workloads \u003ci\u003eby Brad M. McGehee\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eStrategies for unraveling tangled code \u003ci\u003eby Jennifer McCown\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eUsing PAL to analyze SQL Server performance \u003ci\u003eby Tim Chapman\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eTuning JDBC for SQL Server \u003ci\u003eby Jungsun Kim\u003c\/i\u003e \u003c\/li\u003e \u003cb\u003ePART 5 BUSINESS INTELLIGENCE \u003ci\u003eEdited by Greg Low\u003c\/i\u003e \u003c\/b\u003e \u003cli\u003eCreating a formal Reporting Services report part library \u003ci\u003eby Jessica M. Moss\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eImproving report layout and visualization \u003ci\u003eby Greg Low\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eDeveloping sharable managed code expressions in SSRS \u003ci\u003eby William Vaughn\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eDesigning reports with custom MDX queries \u003ci\u003eby Paul Turley\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eBuilding a scale-out Reporting Services farm \u003ci\u003eby Edwin Sarmiento\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eCreating SSRS reports from SSAS \u003ci\u003eby Robert Cain\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eOptimizing SSIS for dimensional data loads \u003ci\u003eby Michael Coles\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eSSIS configurations management \u003ci\u003eby Andy Leonard\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eExploring different types of enumerators in the SSIS Foreach Loop container \u003ci\u003eby Abolfazl Radgoudarzi and Shahriar Nikkhah\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eLate-arriving dimensions in SSIS \u003ci\u003eby John Welch\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eWhy automate tasks with SSIS? \u003ci\u003eby Ted Krueger\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eExtending SSIS using the Script component \u003ci\u003eby Tim Mitchell\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eETL design checklist \u003ci\u003eby Rafael Salas\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eAutogenerating SSAS cubes \u003ci\u003eby Johan Ahlen\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eScripting SSAS databases - AMO and PowerShell, Better Together \u003ci\u003eby Darren Gosbell\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eManaging context in MDX \u003ci\u003eby Boyan Penev\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eUsing time intelligence functions in PowerPivot \u003ci\u003eby Thiago Zavaschi\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eEasy BI with Silverlight PivotViewer \u003ci\u003eby Gogula Aryalingam\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eExcel as a BI frontend tool \u003ci\u003eby Pedro Perfeito\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eReal-time BI with StreamInsight \u003ci\u003eby Allan Mitchell\u003c\/i\u003e \u003c\/li\u003e\n\u003cli\u003eBI solution development design considerations \u003ci\u003eby Siddharth Mehta\u003c\/i\u003e \u003c\/li\u003e\n\u003c\/ol\u003e","brand":"Manning Publications Company","offers":[{"title":"Default Title","offer_id":47065524011248,"sku":"9781617290473","price":59.99,"currency_code":"USD","in_stock":false}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781617290473_p0.jpg?v=1763850029","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781617290473","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}