Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Overview

Summary SQL Server MVP Deep Dives, Volume 2 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. 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. 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

This unique book is your chance to learn from the best in the business. It offers valuable insights for readers of all levels. ========================================?======= Table of Contents
PART 1 ARCHITECTURE
  1. Where are my keys?

  2. "Yes, we are all individuals" A look at uniqueness in the world of SQL

  3. Architectural growth pains

  4. Characteristics of a great relational database

  5. Storage design considerations

  6. Generalization: the key to a well-designed schema

    PART 2 DATABASE ADMINISTRATION

  7. Increasing availability through testing

  8. Page restores

  9. Capacity planning

  10. Discovering your servers with PowerShell and SMO

  11. Will the real Mr. Smith please stand up?

  12. Build your own SQL Server 2008 performance dashboard

  13. SQL Server cost recovery

  14. Best practice compliance with Policy-Based Management

  15. Using SQL Server Management Studio to the fullest

  16. Multiserver management and Utility Explorer - best tools for the DBA

  17. Top 10 SQL Server admin student misconceptions

  18. High availability of SQL Server in the context of Service Level Agreements

    PART 3 DATABASE DEVELOPMENT

  19. T-SQL: bad habits to kick

  20. Death by UDF

  21. Using regular expressions in SSMS

  22. SQL Server Denali: what's coming next in T-SQL

  23. Creating your own data type

  24. Extracting data with regular expressions

  25. Relational division

  26. SQL FILESTREAM: to BLOB or not to BLOB

  27. Writing unit tests for Transact-SQL

  28. Getting asynchronous with Service Broker

  29. Effective use of HierarchyId

  30. Let Service Broker help you scale your application

    PART 4 PERFORMANCE TUNING AND OPTIMIZATION

  31. Hardware 201: selecting and sizing database server hardware

  32. Parameter sniffing: your best friend...except when it isn't

  33. Investigating the plan cache

  34. What are you waiting for? An introduction to waits and queues

  35. You see sets, and I see loops

  36. Performance-tuning the transaction log for OLTP workloads

  37. Strategies for unraveling tangled code

  38. Using PAL to analyze SQL Server performance

  39. Tuning JDBC for SQL Server

    PART 5 BUSINESS INTELLIGENCE

  40. Creating a formal Reporting Services report part library

  41. Improving report layout and visualization

  42. Developing sharable managed code expressions in SSRS

  43. Designing reports with custom MDX queries

  44. Building a scale-out Reporting Services farm

  45. Creating SSRS reports from SSAS

  46. Optimizing SSIS for dimensional data loads

  47. SSIS configurations management

  48. Exploring different types of enumerators in the SSIS Foreach Loop container

  49. Late-arriving dimensions in SSIS

  50. Why automate tasks with SSIS?

  51. Extending SSIS using the Script component

  52. ETL design checklist

  53. Autogenerating SSAS cubes

  54. Scripting SSAS databases - AMO and PowerShell, Better Together

  55. Managing context in MDX

  56. Using time intelligence functions in PowerPivot

  57. Easy BI with Silverlight PivotViewer

  58. Excel as a BI frontend tool

  59. Real-time BI with StreamInsight

  60. BI solution development design considerations

Subscriber Reviews

Average Rating: 4.5 out of 5 rating Based on 2 Ratings

"Wonderful secrets uncovered" - by Lokesh Vij on 20-APR-2012
Reviewer Rating: 1 star rating2 star rating3 star rating4 star rating5 star rating
This book is a must read for advanced SQL study. It presents concepts in a simple and thought provoking manner to understand. Author has done an extensive research and presented in a manner which people like us would have thought the things to be.

I am sure that you will find this book very sitcky; I bet you will not be able to hold yourself to flip the pages.

Report as Inappropriate

Table of Contents

 Index