舉報 
會員
Microsoft SQL Server 2008 R2 Administration Cookbook
最新章節：
Index
Thisbookofferspractical,task-based,andimmediatelyusablerecipescoveringawiderangeofadvancedtechniquesforadministeringahigh-performanceSQLServer2008R2system.Inadditiontoitscookbookstyle,whichensuresthesolutionsarepresentedinaclearstep-by-stepmanner,itsexplanationsgointogreatdetail,whichmakesitgoodlearningmaterialforeveryonewhohasexperienceinSQLServerandwantstoimprove.Thebookisdesignedinsuchawaythatyoucaneitherreaditchapterbychapterorrefertorecipesthatyouwantinnoparticularorder.AlthoughthebookisfocusedonspecificMicrosoftSQLServer2008R2,mostoftheconceptsandexplanationsarealsoapplicabletoSQLServer2008.Ifyouareanexperienceddatabaseadministratoranddatabasearchitectwhowantstodesign,administer,andmanageascalableandhigh-performanceSQLServer2008R2system,thenthisbookisforyou.Thebookassumesthatyouhaveagoodunderstandingofdatabasemanagementsystems,specificallyexperienceinMicrosoftSQLServer2008administration.
最新章節
- Index
- Appendix A. More DBA Manageability Best Practices
- Managing events capture to troubleshoot problems
- Administrating multiple Analysis Services using Tools
- Administrating resource health policies
- Automated administration across an enterprise
品牌：中圖公司
上架時間：2021-04-02 17:03:43
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Index 更新時間：2021-04-02 19:34:12
- Appendix A. More DBA Manageability Best Practices
- Managing events capture to troubleshoot problems
- Administrating multiple Analysis Services using Tools
- Administrating resource health policies
- Automated administration across an enterprise
- Introduction
- Chapter 10. Learning the Tricks of the Trade
- Implementing a benchmarking framework on multiple instances
- Building best usage processes of Dynamic Management Views
- Configuring and managing storage systems for optimized defragmentation processes
- Implementing the plan guide to enhance compile-time and run-time execution plans
- Implementing parallel query processing methods
- Designing sustainable locking methods to improve concurrency
- Implementing query hints for optimized performance
- Implementing table hints for advanced query tuning performance
- Designing a filtered indexes and statistics feature
- Implementing systematized monitoring methods for data platform optimization
- Introduction
- Chapter 9. Troubleshooting
- Managing a storage system for analyzing bottlenecks
- Configuring SQL server storage architecture for quick recovery
- Configuring a server storage system for scalability
- Configuring a manageable database consistency and integrity process for multiple databases and a VLDB environment
- Implementing sustainable index maintenance practices for a VLDB & 24/7 environment
- Planning and designing of a Disaster Recovery environment
- Implementing Piecemeal restore strategies
- Designing maintenance tasks on a mission-critical environment
- Implementing Management Data Warehouse features
- Monitoring resource usage with Extended Events
- Implementing performance baseline practices
- Introduction
- Chapter 8. Maintenance and Monitoring
- Designing Transparent Data Encryption features
- Implementing the SQL Server Best Practices Analyzer
- Implementing and running PowerShell for SQL Server features
- Implementing Policy-Based Management features
- Designing change tracking methodology
- Implementing backup compression for a VLDB environment
- Managing server-level securable and database-level permissions
- Implementing auditing and service level security features
- Introduction
- Chapter 7. Implementing New Manageability Features and Practices
- Deploying and managing data-tier applications
- Designing spatial data storage methods
- Implementing sparse columns and wide table features
- Designing data partitioning solutions for tables and indexes
- Designing a storage solution for unstructured data and new collations
- Implementing compressed storage features for tables and indexes
- Improving Replication scalability at multiple sites
- Managing Log Shipping scenarios in a Database Mirroring environment
- Managing Database Mirroring in a Failover Cluster environment
- Implementing Database Mirroring features and performance enhancements
- Recovering and troubleshooting Failover Cluster Failure
- Installing and configuring Failover Cluster Services
- Preparing new Failover Cluster features
- Introduction
- Chapter 6. Improving Availability and enhancing Programmability
- Designing and deploying framework to use Master Data Services
- Installing and configuring a Master Data Services Solution
- Implementing SQL Azure connectivity features
- Implementing Microsoft StreamInsight Technologies Platform
- Planning and implementing Self-Service Business Intelligence services
- Introduction
- Chapter 5. Managing Core SQL Server 2008 R2 Technologies
- Managing the ETL process efficiently
- Preparing and installing SQL Server Integration Services
- Implementing Scale-Out deployment of SQL Server Reporting Services
- Administering SQL Server Reporting Services
- Implementing Scale-Out of SQL Server Analysis Services
- Preparing and installing SQL Server Analysis Services
- Introduction
- Chapter 4. Administering Core Business Intelligence Services
- Multiserver Management Using Utility Explorer
- Implementing security for SQL Server Agent jobs management
- Managing SQL Server Replication processes
- Designing and refreshing a Scalable Shared database
- Implementing Utility & Non-utility collection sets
- Managing the Utility Control Point data warehouse database
- Designing Multi-server management from SQL Server 2008 R2
- Implementing Central Management feature enhancements
- Introduction
- Chapter 3. Managing the Core Database Engine
- Administering SQL Server Replication processes
- Troubleshooting multi-server instances with utility administration
- Designing SQL Server Agent scheduled jobs for ETL processes
- Administering SQL Server workloads with Resource Governor
- Implementing Monitoring and Tuning for performance
- Implementing Availability feature enhancements
- Implementing Security feature enhancements
- Designing automated administration practices
- Introduction
- Chapter 2. Administrating the Core Database Engine
- Designing applications to use federated servers
- Designing and adopting SQL Server 2008 R2 solutions
- Working with Data-Tier applications
- There's more.
- Designing a best practice approach to upgrading to SQL Server 2008 R2
- Adding SQL Server 2008 R2 Service Pack features using Slipstream technology
- Introduction
- Chapter 1. Getting Started with SQL Server 2008 R2
- Customer support
- Reader feedback
- Conventions
- Who this book is for
- What you need for this book
- SQL Server 2008 R2 Parallel Data Warehouse
- SQL Server 2008 R2 DataCenter
- SQL Server 2008 R2 new enhancements
- SQL Server 2008 R2 Prologue
- What this book covers
- Preface
- Support files eBooks discount offers and more
- www.PacktPub.com
- About the Reviewers
- Acknowledgment
- About the Author
- Foreword
- Credits
- 版權信息
- 封面
- 封面
- 版權信息
- Credits
- Foreword
- About the Author
- Acknowledgment
- About the Reviewers
- www.PacktPub.com
- Support files eBooks discount offers and more
- Preface
- What this book covers
- SQL Server 2008 R2 Prologue
- SQL Server 2008 R2 new enhancements
- SQL Server 2008 R2 DataCenter
- SQL Server 2008 R2 Parallel Data Warehouse
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Getting Started with SQL Server 2008 R2
- Introduction
- Adding SQL Server 2008 R2 Service Pack features using Slipstream technology
- Designing a best practice approach to upgrading to SQL Server 2008 R2
- There's more.
- Working with Data-Tier applications
- Designing and adopting SQL Server 2008 R2 solutions
- Designing applications to use federated servers
- Chapter 2. Administrating the Core Database Engine
- Introduction
- Designing automated administration practices
- Implementing Security feature enhancements
- Implementing Availability feature enhancements
- Implementing Monitoring and Tuning for performance
- Administering SQL Server workloads with Resource Governor
- Designing SQL Server Agent scheduled jobs for ETL processes
- Troubleshooting multi-server instances with utility administration
- Administering SQL Server Replication processes
- Chapter 3. Managing the Core Database Engine
- Introduction
- Implementing Central Management feature enhancements
- Designing Multi-server management from SQL Server 2008 R2
- Managing the Utility Control Point data warehouse database
- Implementing Utility & Non-utility collection sets
- Designing and refreshing a Scalable Shared database
- Managing SQL Server Replication processes
- Implementing security for SQL Server Agent jobs management
- Multiserver Management Using Utility Explorer
- Chapter 4. Administering Core Business Intelligence Services
- Introduction
- Preparing and installing SQL Server Analysis Services
- Implementing Scale-Out of SQL Server Analysis Services
- Administering SQL Server Reporting Services
- Implementing Scale-Out deployment of SQL Server Reporting Services
- Preparing and installing SQL Server Integration Services
- Managing the ETL process efficiently
- Chapter 5. Managing Core SQL Server 2008 R2 Technologies
- Introduction
- Planning and implementing Self-Service Business Intelligence services
- Implementing Microsoft StreamInsight Technologies Platform
- Implementing SQL Azure connectivity features
- Installing and configuring a Master Data Services Solution
- Designing and deploying framework to use Master Data Services
- Chapter 6. Improving Availability and enhancing Programmability
- Introduction
- Preparing new Failover Cluster features
- Installing and configuring Failover Cluster Services
- Recovering and troubleshooting Failover Cluster Failure
- Implementing Database Mirroring features and performance enhancements
- Managing Database Mirroring in a Failover Cluster environment
- Managing Log Shipping scenarios in a Database Mirroring environment
- Improving Replication scalability at multiple sites
- Implementing compressed storage features for tables and indexes
- Designing a storage solution for unstructured data and new collations
- Designing data partitioning solutions for tables and indexes
- Implementing sparse columns and wide table features
- Designing spatial data storage methods
- Deploying and managing data-tier applications
- Chapter 7. Implementing New Manageability Features and Practices
- Introduction
- Implementing auditing and service level security features
- Managing server-level securable and database-level permissions
- Implementing backup compression for a VLDB environment
- Designing change tracking methodology
- Implementing Policy-Based Management features
- Implementing and running PowerShell for SQL Server features
- Implementing the SQL Server Best Practices Analyzer
- Designing Transparent Data Encryption features
- Chapter 8. Maintenance and Monitoring
- Introduction
- Implementing performance baseline practices
- Monitoring resource usage with Extended Events
- Implementing Management Data Warehouse features
- Designing maintenance tasks on a mission-critical environment
- Implementing Piecemeal restore strategies
- Planning and designing of a Disaster Recovery environment
- Implementing sustainable index maintenance practices for a VLDB & 24/7 environment
- Configuring a manageable database consistency and integrity process for multiple databases and a VLDB environment
- Configuring a server storage system for scalability
- Configuring SQL server storage architecture for quick recovery
- Managing a storage system for analyzing bottlenecks
- Chapter 9. Troubleshooting
- Introduction
- Implementing systematized monitoring methods for data platform optimization
- Designing a filtered indexes and statistics feature
- Implementing table hints for advanced query tuning performance
- Implementing query hints for optimized performance
- Designing sustainable locking methods to improve concurrency
- Implementing parallel query processing methods
- Implementing the plan guide to enhance compile-time and run-time execution plans
- Configuring and managing storage systems for optimized defragmentation processes
- Building best usage processes of Dynamic Management Views
- Implementing a benchmarking framework on multiple instances
- Chapter 10. Learning the Tricks of the Trade
- Introduction
- Automated administration across an enterprise
- Administrating resource health policies
- Administrating multiple Analysis Services using Tools
- Managing events capture to troubleshoot problems
- Appendix A. More DBA Manageability Best Practices
- Index 更新時間：2021-04-02 19:34:12
