SQL Server MVP Deep Dives, Volume 2, Kalen Delaney, Louis Davidson, Greg Low, Brad McGhee, Paul Nielson, Paul Randal,

SQL Server MVP Deep Dives, Volume 2, Kalen Delaney, Louis Davidson, Greg Low, Brad McGhee, Paul Nielson, Paul Randal, Kimberly Tripp, more купить книгу в Україні

Обкладинка - м"яка

Рік видання - 2011

Кількість сторінок - 688

Папір - білий, офсет

Про книгу SQL Server MVP Deep Dives, Volume 2, Kalen Delaney, Louis Davidson, Greg Low, Brad McGhee, Paul Nielson, Paul Randal, Kimberly Tripp, more

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

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

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

Також ви можете залишити відгук про книгу: SQL Server MVP Deep Dives, Volume 2, Kalen Delaney, Louis Davidson, Greg Low, Brad McGhee, Paul Nielson, Paul Randal, Kimberly Tripp, more