買這商品的人也買了...
-
$650$553 -
$2,200$2,090 -
$680$578 -
$490$417 -
$1,330$1,131 -
$520$442 -
$500$425 -
$850$723 -
$750$675 -
$650$553 -
$590$502 -
$480$408 -
$680$537 -
$550$435 -
$450$351 -
$680$578 -
$450$383 -
$580$493 -
$620$558 -
$880$695 -
$780$663 -
$580$458 -
$580$522 -
$680$530 -
$980$774
相關主題
商品描述
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 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, 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 ContentsPART 1 ARCHITECTURE Edited by Louis Davidson
PART 2 DATABASE ADMINISTRATION Edited by Paul Randal and Kimberly Tripp
PART 3 DATABASE DEVELOPMENT Edited by Paul Nielsen
PART 4 PERFORMANCE TUNING AND OPTIMIZATION Edited by Brad M. McGehee
PART 5 BUSINESS INTELLIGENCE Edited by Greg Low
- 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
- 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
- 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
- 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
- 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深度探索,第2卷是一本獨特的書籍,讓您能夠向業界最佳人士學習 - 64位SQL Server MVP在這第二卷中提供全新的內容,涵蓋範圍從測試和策略管理到整合服務、報表和性能優化技術等等。
關於本書
成為MVP需要深厚的知識和令人印象深刻的技能。這本書的64位MVP作者在SQL Server管理、開發、培訓和設計方面擁有約1000年的經驗。這本令人難以置信的書籍以60個簡潔、精選的章節捕捉了他們的專業知識和熱情,為讀者提供了寶貴的見解,適合各個層次的讀者。
SQL Server MVP深度探索,第2卷延續了第一卷的內容,全新涵蓋了測試和策略管理、整合服務、報表和性能優化等主題。這些章節分為五個部分:架構和設計、數據庫管理、數據庫開發、性能調優和優化,以及商業智能。
內容簡介
- 使用PowerShell發現伺服器
- 在SSMS中使用正則表達式
- 針對OLTP調優交易日誌
- 針對維度數據優化SSIS
- 實時商業智能等等
Manning出版社和本書的作者支持Operation Smile的兒童,這是一個國際兒童醫療慈善機構,為患有唇裂和腭裂等面部畸形的兒童提供免費的重建手術,並動員醫療志願者向當地醫生提供最新的手術技術教育和培訓計劃。
===============================================
目錄
第1部分 架構 編輯:Louis Davidson
第2部分 數據庫管理 編輯:Paul Randal和Kimberly Tripp
第3部分 數據庫開發 編輯:Paul Nielsen
第4部分 性能調優和優化 編輯:Brad M. McGehee
第5部分 商業智能 編輯:Greg Low
- 我的鑰匙在哪裡? 作者:Ami Levin
- “是的,我們都是獨一無二的” - SQL世界中的獨特性 作者:Rob Farley
- 架構成長的痛點 作者:Chris Shaw
- 優秀關聯數據庫的特點 作者:Louis Davidson
- 存儲設計考慮事項 作者:Denny Cherry
- 泛化:設計良好模式的關鍵 作者:Paul Nielsen
- 通過測試提高可用性 作者:Allan Hirt
- 頁面還原 作者:Gail Shaw
- 容量規劃 作者:Greg Larsen
- 使用PowerShell和SMO發現您的伺服器 作者:Joe Webb
- 真正的史密斯先生請站出來 作者:John Magnabosco
- 構建自己的SQL Server 2008性能儀表板 作者:Pawl Potasinski
- SQL Server成本回收 作者:Peter Ward
- 通過基於策略的管理實現最佳實踐合規性 作者:Rod Colledge
- 充分利用SQL Server Management Studio 作者:Rodney Landrum
- 多伺服器管理和實用程式瀏覽器 - DBA的最佳工具 作者:Satya Shyam K. Jayanty
- SQL Server管理員學生的前10個誤解 作者:Tibor Karaszi
- 在服務水平協議的背景下實現SQL Server的高可用性 作者:Tobiasz Janusz Koprowski
- T-SQL:需要改掉的壞習慣 作者:Aaron Bertrand
- 被UDF搞死 作者:Kevin Boles
- 在SSMS中使用正則表達式 作者:John Paul Cook
- SQL Server Denali:T-SQL的下一步發展 作者:Sergio Govoni
- Cr