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.

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

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

PART 2 DATABASE ADMINISTRATION Edited by Paul Randal and Kimberly Tripp

7. Increasing availability through testing by Allan Hirt
8. Page restores by Gail Shaw
9. Capacity planning by Greg Larsen
10. Discovering your servers with PowerShell and SMO by Joe Webb
11. Will the real Mr. Smith please stand up? by John Magnabosco
12. Build your own SQL Server 2008 performance dashboard by Pawl Potasinski
13. SQL Server cost recovery by Peter Ward
14. Best practice compliance with Policy-Based Management by Rod Colledge
(Computer Bookshops Limited)

Bli först med att recensera och betygsätt boken SQL Server MVP Deep Dives Volume 2 - du kan vinna 200 kr varje månad i tävlingen "Månadens recension".

PART 1 ARCHITECTURE Edited by Louis Davidson

Where are my keys? by Ami Levin
"Yes, we are all individuals" A look at uniqueness in the world of SQL by Rob Farley
Architectural growth pains by Chris Shaw
Characteristics of a great relational database by Louis Davidson
Storage design considerations by Denny Cherry
Generalization: the key to a well-designed schema by Paul Nielsen
PART 2 DATABASE ADMINISTRATION Edited by Paul Randal and Kimberly Tripp

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

T-SQL: bad habits to kick by Aaron Bertrand
Death by UDF by Kevin Boles
Using regular expressions in SSMS by John Paul Cook
SQL Server Denali: what's coming next in T-SQL by Sergio Govoni
Creating your own data type by Hugo Kornelis
Extracting data with regular expressions by Matija Lah
Relational division by Peter Larsson
SQL FILESTREAM: to BLOB or not to BLOB by Ben Miller
Writing unit tests for Transact-SQL by Luciano Moreira
Getting asynchronous with Service Broker by Mladen Prajdic
Effective use of HierarchyId by Denis Reznik
Let Service Broker help you scale your application by Allen White
PART 4 PERFORMANCE TUNING AND OPTIMIZATION Edited by Brad M. McGehee

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

Creating a formal Reporting Services report part library by Jessica M. Moss
Improving report layout and visualization by Greg Low
Developing sharable managed code expressions in SSRS by William Vaughn
Designin...

(Computer Bookshops Limited)