SQL Server MVP Deep Dives,Volume 2

SQL Server MVP Deep Dives, Volume 2
Author: Kalen Delaney (Editor), Louis Davidson (Editor), Greg Low (Editor), Brad McGhee (Editor), Paul Nielson (Editor), Paul Randal (Editor), Kimberly Tripp (Editor)
Publisher finelybook 出版社:‏ Manning Publications
Edition 版本:‏ 1st
Publication Date 出版日期:‏ 2011-11-01
Language 语言: English
Print Length 页数: 688 pages
ISBN-10: 1617290475
ISBN-13: 9781617290473

Book Description

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

1. 
   

   PART 1 ARCHITECTUREEdited by Louis Davidson

2. Where are my keys? by Ami Levin
3. “Yes, we are all individuals”A look at uniqueness in the world of SQL by Rob Farley
4. Architectural growth pains by Chris Shaw
5. Characteristics of a great relational database by Louis Davidson
6. Storage design considerations by Denny Cherry
7. Generalization: the key to a well-designed schema by Paul Nielsen
8. 
   

   PART 2 DATABASE ADMINISTRATION Edited by Paul Randal and Kimberly Tripp

9. Increasing availability through testing by Allan Hirt
10. Page restores by Gail Shaw
11. Capacity planning by Greg Larsen
12. Discovering your servers with PowerShell and SMO by Joe Webb
13. Will the real Mr. Smith please stand up? by John Magnabosco
14. Build your own SQL Server 2008 performance dashboard by Pawl Potasinski
15. SQL Server cost recovery by Peter Ward
16. Best practice compliance with Policy-Based Management by Rod Colledge
17. Using SQL Server Management Studio to the fullest by Rodney Landrum
18. Multiserver management and Utility Explorer – best tools for the DBA by Satya Shyam K. Jayanty
19. Top 10 SQL Server admin student misconceptions by Tibor Karaszi
20. High availability of SQL Server in the context of Service Level Agreements by Tobiasz Janusz Koprowski
21. 
    

    PART 3 DATABASE DEVELOPMENT Edited by Paul Nielsen

22. T-SQL: bad habits to kick by Aaron Bertrand
23. Death by UDF by Kevin Boles
24. Using regular expressions in SSMS by John Paul Cook
25. SQL Server Denali: what’s coming next in T-SQL by Sergio Govoni
26. Creating your own data type by Hugo Kornelis
27. Extracting data with regular expressions by Matija Lah
28. Relational division by Peter Larsson
29. SQL FILESTREAM: to BLOB or not to BLOB by Ben Miller
30. Writing unit tests for Transact-SQL by Luciano Moreira
31. Getting asynchronous with Service Broker by Mladen Prajdic
32. Effective use of HierarchyId by Denis Reznik
33. Let Service Broker help you scale your application by Allen White
34. 
    

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

35. Hardware 201: selecting and sizing database server hardware by Glenn Berry
36. Parameter sniffing: your best friend…except when it isn’t by Grant Fritchey
37. Investigating the plan cache by Jason Strate
38. What are you waiting for? An introduction to waits and queues by Robert Pearl
39. You see sets, and I see loops by Linchi Shea
40. Performance-tuning the transaction log for OLTP workloads by Brad M. McGehee
41. Strategies for unraveling tangled code by Jennifer McCown
42. Using PAL to analyze SQL Server performance by Tim Chapman
43. Tuning JDBC for SQL Server by Jungsun Kim
44. 
    

    PART 5 BUSINESS INTELLIGENCE Edited by Greg Low

45. Creating a formal Reporting Services report part library by Jessica M. Moss
46. Improving report layout and visualization by Greg Low
47. Developing sharable managed code expressions in SSRS by William Vaughn
48. Designing reports with custom MDX queries by Paul Turley
49. Building a scale-out Reporting Services farm by Edwin Sarmiento
50. Creating SSRS reports from SSAS by Robert Cain
51. Optimizing SSIS for dimensional data loads by Michael Coles
52. SSIS configurations management by Andy Leonard
53. Exploring different types of enumerators in the SSIS Foreach Loop container by Abolfazl Radgoudarzi and Shahriar Nikkhah
54. Late-arriving dimensions in SSIS by John Welch
55. Why automate tasks with SSIS? by Ted Krueger
56. Extending SSIS using the Script component by Tim Mitchell
57. ETL design checklist by Rafael Salas
58. Autogenerating SSAS cubes by Johan Ahlen
59. Scripting SSAS databases – AMO and PowerShell, Better Together by Darren Gosbell
60. Managing context in MDX by Boyan Penev
61. Using time intelligence functions in PowerPivot by Thiago Zavaschi
62. Easy BI with Silverlight PivotViewer by Gogula Aryalingam
63. Excel as a BI frontend tool by Pedro Perfeito
64. Real-time BI with StreamInsight by Allan Mitchell
65. BI solution development design considerations by Siddharth Mehta

Amazon page