Read Anywhere and on Any Device!

Subscribe to Read | $0.00

Join today and start reading your favorite books for Free!

Create Free Account

Quick and Easy Sign Up!

It takes less then 1 minute to sign up, then you can enjoy Unlimited eBooks.

Sign Up Browse

Popular Genres

Read Anywhere and on Any Device!

  • Download on iOS
  • Download on Android
  • Download on iOS

SQL Server MVP Deep Dives, Volume 2

SQL Server MVP Deep Dives, Volume 2

Louis Davidson
4.3/5 ( ratings)
Read Download
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
PART 1 ARCHITECTUREEdited 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

Designing reports with custom MDX queries by Paul Turley

Building a scale-out Reporting Services farm by Edwin Sarmiento

Creating SSRS reports from SSAS by Robert Cain

Optimizing SSIS for dimensional data loads by Michael Coles

SSIS configurations management by Andy Leonard

Exploring different types of enumerators in the SSIS Foreach Loop container by Abolfazl Radgoudarzi and Shahriar Nikkhah

Late-arriving dimensions in SSIS by John Welch

Why automate tasks with SSIS? by Ted Krueger

Extending SSIS using the Script component by Tim Mitchell

ETL design checklist by Rafael Salas

Autogenerating SSAS cubes by Johan Ahlen

Scripting SSAS databases - AMO and PowerShell, Better Together by Darren Gosbell

Managing context in MDX by Boyan Penev

Using time intelligence functions in PowerPivot by Thiago Zavaschi

Easy BI with Silverlight PivotViewer by Gogula Aryalingam

Excel as a BI frontend tool by Pedro Perfeito

Real-time BI with StreamInsight by Allan Mitchell

BI solution development design considerations by Siddharth Mehta
Language
English
Pages
688
Format
Paperback
Publisher
Manning
Release
October 24, 2011
ISBN
1617290475
ISBN 13
9781617290473

SQL Server MVP Deep Dives, Volume 2

Louis Davidson
4.3/5 ( ratings)
Read Download
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
PART 1 ARCHITECTUREEdited 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

Designing reports with custom MDX queries by Paul Turley

Building a scale-out Reporting Services farm by Edwin Sarmiento

Creating SSRS reports from SSAS by Robert Cain

Optimizing SSIS for dimensional data loads by Michael Coles

SSIS configurations management by Andy Leonard

Exploring different types of enumerators in the SSIS Foreach Loop container by Abolfazl Radgoudarzi and Shahriar Nikkhah

Late-arriving dimensions in SSIS by John Welch

Why automate tasks with SSIS? by Ted Krueger

Extending SSIS using the Script component by Tim Mitchell

ETL design checklist by Rafael Salas

Autogenerating SSAS cubes by Johan Ahlen

Scripting SSAS databases - AMO and PowerShell, Better Together by Darren Gosbell

Managing context in MDX by Boyan Penev

Using time intelligence functions in PowerPivot by Thiago Zavaschi

Easy BI with Silverlight PivotViewer by Gogula Aryalingam

Excel as a BI frontend tool by Pedro Perfeito

Real-time BI with StreamInsight by Allan Mitchell

BI solution development design considerations by Siddharth Mehta
Language
English
Pages
688
Format
Paperback
Publisher
Manning
Release
October 24, 2011
ISBN
1617290475
ISBN 13
9781617290473

More books from Louis Davidson

Rate this book!

Write a review?

loader