Title
SQL Server MVP Deep Dives, Volume 2
Sold by Ergodebooks, an authorized reseller.
Returns accepted within 30 days | support@ergodebooks.com
Shipping Information
- Free Standard Shipping — United States only
- Processing Time: 1–3 business days
- Estimated Delivery: 3–5 business days after dispatch
- Double-boxed, fully insured & discreetly packaged
- Tracking number sent via email once dispatched
- Orders over $250 require signature upon delivery. Taxes calculated at checkout.
Returns & Refund
Returns accepted within 30 days of delivery.
Damaged or Defective Item
Free return shipping + replacement or full refund
Wrong Item Received
Free return shipping + replacement or full refund
Change of Mind
Return shipping at customer's expense · 25% restocking fee applies
Payment Option
SummarySQL 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 BookTo 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, handpicked 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 Realtime BI and much moreManning 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 welldesigned 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 PolicyBased 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 TSQL: 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 TSQL 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 TransactSQL 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 a
⚠️ WARNING (California Proposition 65):
This product may contain chemicals known to the State of California to cause cancer, birth defects, or other reproductive harm.
For more information, please visit www.P65Warnings.ca.gov.
- Q: What topics are covered in SQL Server MVP Deep Dives, Volume 2? A: The book covers a variety of topics including architecture and design, database administration, database development, performance tuning and optimization, and business intelligence.
- Q: Who are the authors of this book? A: The book features contributions from 64 SQL Server MVPs, experts in SQL Server administration, development, training, and design.
- Q: Is there any additional content available with the purchase of the print book? A: Yes, the purchase includes a free PDF, ePub, and Kindle eBook from Manning, along with access to all code from the book.
- Q: What is the page count of SQL Server MVP Deep Dives, Volume 2? A: The book contains 688 pages.
- Q: What is the intended audience for this book? A: This book is designed for readers of all levels, from beginners to advanced SQL Server professionals.
- Q: When was SQL Server MVP Deep Dives, Volume 2 published? A: The book was published on November 1, 2011.
- Q: What binding type is used for this book? A: The book is available in a paperback binding.
- Q: What kind of insights can readers expect from the chapters? A: Readers can expect valuable insights, best practices, and techniques from experienced professionals in each of the 60 concise chapters.
- Q: Does this book support any charitable causes? A: Yes, Manning Publications and the authors support Operation Smile, which provides free reconstructive surgeries for children with facial deformities.
- Q: Is this book suitable for self-study? A: Yes, it is suitable for self-study as it provides comprehensive coverage of SQL Server topics with practical examples.