The Fictioning Horror Sale
 
 

Recently Viewed clear list


Original Essays | September 4, 2014

Edward E. Baptist: IMG The Two Bodies of The Half Has Never Been Told: Slavery and the Making of American Capitalism



My new book, The Half Has Never Been Told: Slavery and the Making of American Capitalism, is the story of two bodies. The first body was the new... Continue »
  1. $24.50 Sale Hardcover add to wish list

spacer
Qualifying orders ship free.
$59.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
13 Local Warehouse Database- Design
1 Remote Warehouse Computer Languages- SQL

SQL Server MVP Deep Dives, Volume 2

by

SQL Server MVP Deep Dives, Volume 2 Cover

 

Synopses & Reviews

Publisher Comments:

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 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
  7. PART 2 DATABASE ADMINISTRATION Edited by Paul Randal and Kimberly Tripp
  8. Increasing availability through testing by Allan Hirt
  9. Page restores by Gail Shaw
  10. Capacity planning by Greg Larsen
  11. Discovering your servers with PowerShell and SMO by Joe Webb
  12. Will the real Mr. Smith please stand up? by John Magnabosco
  13. Build your own SQL Server 2008 performance dashboard by Pawl Potasinski
  14. SQL Server cost recovery by Peter Ward
  15. Best practice compliance with Policy-Based Management by Rod Colledge
  16. Using SQL Server Management Studio to the fullest by Rodney Landrum
  17. Multiserver management and Utility Explorer - best tools for the DBA by Satya Shyam K. Jayanty
  18. Top 10 SQL Server admin student misconceptions by Tibor Karaszi
  19. High availability of SQL Server in the context of Service Level Agreements by Tobiasz Janusz Koprowski
  20. PART 3 DATABASE DEVELOPMENT Edited by Paul Nielsen
  21. T-SQL: bad habits to kick by Aaron Bertrand
  22. Death by UDF by Kevin Boles
  23. Using regular expressions in SSMS by John Paul Cook
  24. SQL Server Denali: what's coming next in T-SQL by Sergio Govoni
  25. Creating your own data type by Hugo Kornelis
  26. Extracting data with regular expressions by Matija Lah
  27. Relational division by Peter Larsson
  28. SQL FILESTREAM: to BLOB or not to BLOB by Ben Miller
  29. Writing unit tests for Transact-SQL by Luciano Moreira
  30. Getting asynchronous with Service Broker by Mladen Prajdic
  31. Effective use of HierarchyId by Denis Reznik
  32. Let Service Broker help you scale your application by Allen White
  33. PART 4 PERFORMANCE TUNING AND OPTIMIZATION Edited by Brad M. McGehee
  34. Hardware 201: selecting and sizing database server hardware by Glenn Berry
  35. Parameter sniffing: your best friend...except when it isn't by Grant Fritchey
  36. Investigating the plan cache by Jason Strate
  37. What are you waiting for? An introduction to waits and queues by Robert Pearl
  38. You see sets, and I see loops by Linchi Shea
  39. Performance-tuning the transaction log for OLTP workloads by Brad M. McGehee
  40. Strategies for unraveling tangled code by Jennifer McCown
  41. Using PAL to analyze SQL Server performance by Tim Chapman
  42. Tuning JDBC for SQL Server by Jungsun Kim
  43. PART 5 BUSINESS INTELLIGENCE Edited by Greg Low
  44. Creating a formal Reporting Services report part library by Jessica M. Moss
  45. Improving report layout and visualization by Greg Low
  46. Developing sharable managed code expressions in SSRS by William Vaughn
  47. Designing reports with custom MDX queries by Paul Turley
  48. Building a scale-out Reporting Services farm by Edwin Sarmiento
  49. Creating SSRS reports from SSAS by Robert Cain
  50. Optimizing SSIS for dimensional data loads by Michael Coles
  51. SSIS configurations management by Andy Leonard
  52. Exploring different types of enumerators in the SSIS Foreach Loop container by Abolfazl Radgoudarzi and Shahriar Nikkhah
  53. Late-arriving dimensions in SSIS by John Welch
  54. Why automate tasks with SSIS? by Ted Krueger
  55. Extending SSIS using the Script component by Tim Mitchell
  56. ETL design checklist by Rafael Salas
  57. Autogenerating SSAS cubes by Johan Ahlen
  58. Scripting SSAS databases - AMO and PowerShell, Better Together by Darren Gosbell
  59. Managing context in MDX by Boyan Penev
  60. Using time intelligence functions in PowerPivot by Thiago Zavaschi
  61. Easy BI with Silverlight PivotViewer by Gogula Aryalingam
  62. Excel as a BI frontend tool by Pedro Perfeito
  63. Real-time BI with StreamInsight by Allan Mitchell
  64. BI solution development design considerations by Siddharth Mehta

Synopsis:

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 InsideDiscovering servers with PowerShellUsing regular expressions in SSMSTuning the Transaction Log for OLTPOptimizing SSIS for dimensional dataReal-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 ContentsPART 1 ARCHITECTUREWhere are my keys?Yes, we are all individuals A look at uniqueness in the world of SQLArchitectural growth painsCharacteristics of a great relational databaseStorage design considerationsGeneralization: the key to a well-designed schemaPART 2 DATABASE ADMINISTRATIONIncreasing availability through testingPage restoresCapacity planningDiscovering your servers with PowerShell and SMOWill the real Mr. Smith please stand up?Build your own SQL Server 2008 performance dashboardSQL Server cost recoveryBest practice compliance with Policy-Based ManagementUsing SQL Server Management Studio to the fullestMultiserver management and Utility Explorer - best tools for the DBATop 10 SQL Server admin student misconceptionsHigh availability of SQL Server in the context of Service Level AgreementsPART 3 DATABASE DEVELOPMENTT-SQL: bad habits to kickDeath by UDFUsing regular expressions in SSMSSQL Server Denali: what's coming next in T-SQL Creating your own data typeExtracting data with regular expressionsRelational divisionSQL FILESTREAM: to BLOB or not to BLOBWriting unit tests for Transact-SQLGetting asynchronous with Service BrokerEffective use of HierarchyIdLet Service Broker help you scale your applicationPART 4 PERFORMANCE TUNING AND OPTIMIZATIONHardware 201: selecting and sizing database server hardwareParameter sniffing: your best friend...except when it isn'tInvestigating the plan cacheWhat are you waiting for? An introduction to waits and queuesYou see sets, and I see loopsPerformance-tuning the transaction log for OLTP workloadsStrategies for unraveling tangled codeUsing PAL to analyze SQL Server performanceTuning JDBC for SQL ServerPART 5 BUSINESS INTELLIGENCECreating a formal Reporting Services report part libraryImproving report layout and visualizationDeveloping sharable managed code expressions in SSRSDesigning reports with custom MDX queriesBuilding a scale-out Reporting Services farmCreating SSRS reports from SSASOptimizing SSIS for dimensional data loadsSSIS configurations managementExploring different types of enumerators in the SSIS Foreach Loop containerLate-arriving dimensions in SSISWhy automate tasks with SSIS?Extending SSIS using the Script componentETL design checklistAutogenerating SSAS cubesScripting SSAS databases - AMO and PowerShell, Better TogetherManaging context in MDXUsing time intelligence functions in PowerPivotEasy BI with Silverlight PivotViewer Excel as a BI frontend toolReal-time BI with StreamInsightBI solution development design considerations

Synopsis:

SQL Server is a big, powerful database, and it boasts an equally big and powerful community of professionals. Over 50 of the best known SQL Server gurus, each designated by Microsoft as a Most Valuable Professional, offer their favorite tips, techniques, and insights in this unique book.

SQL Server MVP Deep Dives, Volume 2 is designed to appeal to working SQL Server practitioners, and covers a wide range of topics including architecture, administration, programming, reporting, performance, and business intelligence. Volume 2 includes all new materials--no repeats from Volume 1. And like the original MVP Deep Dives book, all author royalties will be donated to charity.

About the Author

Over 50 SQL Server MVPs contributed to this book, which was assembled and edited by Kalen Delaney and SQL Server legends Victor Isakov (Administration), Dave Dustin (Architecture and Design), Aaron Nelson (Business Intelligence), Denis Gobo (Development) and Mike Walsh (Performance.)

Product Details

ISBN:
9781617290473
Author:
Delaney, Kalen
Publisher:
Manning Publications
Author:
64 MVP A
Author:
Low, Greg
Author:
Tripp, Kimberly
Author:
Nelson, Aaron
Author:
ripp
Author:
Randal, Paul
Author:
Isakov, Victor
Author:
Authors, 64 MVP
Author:
Gobo, Denis
Author:
Kimberly T
Author:
Davidson, Louis
Author:
Walsh, Mike
Author:
uthors
Author:
Nielson, Paul
Author:
McGhee, Brad
Author:
Dustin, Dave
Subject:
Programming Languages - SQL
Subject:
General-General
Subject:
Database-SQL
Subject:
Database design
Subject:
.NET;R2;SQL;Server 2008;administration;architecture;business intelligence;database;performance;programming;reporting;server
Edition Description:
Print PDF
Publication Date:
20111031
Binding:
TRADE PAPER
Language:
English
Pages:
688
Dimensions:
9.5 x 7.5 in

Other books you might like

  1. Microsoft(r) SQL Server(r) 2008... New Trade Paper $49.99

Related Subjects

Computers and Internet » Computer Architecture » General
Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

SQL Server MVP Deep Dives, Volume 2 New Trade Paper
0 stars - 0 reviews
$59.99 In Stock
Product details 688 pages Manning Publications - English 9781617290473 Reviews:
"Synopsis" by , 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 InsideDiscovering servers with PowerShellUsing regular expressions in SSMSTuning the Transaction Log for OLTPOptimizing SSIS for dimensional dataReal-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 ContentsPART 1 ARCHITECTUREWhere are my keys?Yes, we are all individuals A look at uniqueness in the world of SQLArchitectural growth painsCharacteristics of a great relational databaseStorage design considerationsGeneralization: the key to a well-designed schemaPART 2 DATABASE ADMINISTRATIONIncreasing availability through testingPage restoresCapacity planningDiscovering your servers with PowerShell and SMOWill the real Mr. Smith please stand up?Build your own SQL Server 2008 performance dashboardSQL Server cost recoveryBest practice compliance with Policy-Based ManagementUsing SQL Server Management Studio to the fullestMultiserver management and Utility Explorer - best tools for the DBATop 10 SQL Server admin student misconceptionsHigh availability of SQL Server in the context of Service Level AgreementsPART 3 DATABASE DEVELOPMENTT-SQL: bad habits to kickDeath by UDFUsing regular expressions in SSMSSQL Server Denali: what's coming next in T-SQL Creating your own data typeExtracting data with regular expressionsRelational divisionSQL FILESTREAM: to BLOB or not to BLOBWriting unit tests for Transact-SQLGetting asynchronous with Service BrokerEffective use of HierarchyIdLet Service Broker help you scale your applicationPART 4 PERFORMANCE TUNING AND OPTIMIZATIONHardware 201: selecting and sizing database server hardwareParameter sniffing: your best friend...except when it isn'tInvestigating the plan cacheWhat are you waiting for? An introduction to waits and queuesYou see sets, and I see loopsPerformance-tuning the transaction log for OLTP workloadsStrategies for unraveling tangled codeUsing PAL to analyze SQL Server performanceTuning JDBC for SQL ServerPART 5 BUSINESS INTELLIGENCECreating a formal Reporting Services report part libraryImproving report layout and visualizationDeveloping sharable managed code expressions in SSRSDesigning reports with custom MDX queriesBuilding a scale-out Reporting Services farmCreating SSRS reports from SSASOptimizing SSIS for dimensional data loadsSSIS configurations managementExploring different types of enumerators in the SSIS Foreach Loop containerLate-arriving dimensions in SSISWhy automate tasks with SSIS?Extending SSIS using the Script componentETL design checklistAutogenerating SSAS cubesScripting SSAS databases - AMO and PowerShell, Better TogetherManaging context in MDXUsing time intelligence functions in PowerPivotEasy BI with Silverlight PivotViewer Excel as a BI frontend toolReal-time BI with StreamInsightBI solution development design considerations

"Synopsis" by ,

SQL Server is a big, powerful database, and it boasts an equally big and powerful community of professionals. Over 50 of the best known SQL Server gurus, each designated by Microsoft as a Most Valuable Professional, offer their favorite tips, techniques, and insights in this unique book.

SQL Server MVP Deep Dives, Volume 2 is designed to appeal to working SQL Server practitioners, and covers a wide range of topics including architecture, administration, programming, reporting, performance, and business intelligence. Volume 2 includes all new materials--no repeats from Volume 1. And like the original MVP Deep Dives book, all author royalties will be donated to charity.

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.