Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Microsoft SQL Server 2008 R2 Administration Cookbook
Satya Shyam K Jayanty
May, 2011 | 468 pages
No titles found
Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Credits
Foreword
Foreword
About the Author
About the Author
Acknowledgment
Acknowledgment
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Getting Started with SQL Server 2008 R2
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
2
Administrating the Core Database Engine
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
3
Managing the Core Database Engine
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
4
Administering Core Business Intelligence Services
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
5
Managing Core SQL Server 2008 R2 Technologies
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
6
Improving Availability and enhancing Programmability
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
7
Implementing New Manageability Features and Practices
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
8
Maintenance and Monitoring
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
9
Troubleshooting
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
10
Learning the Tricks of the Trade
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
More DBA Manageability Best Practices
More DBA Manageability Best Practices

Preparing and installing SQL Server Integration Services

The first release of Integration Services in SQL Server 2005 has changed the ETL functionality for SQL Server. It is a successor to SQL Server 2000 version's Data Transformation Services (DTS), and took a significant step forward by providing more intuitive designers, but also a native .NET execution environment. SQL Server 2008 R2 maintains that process with a significant scalability improvement in data pipeline and data warehouse enhancements such as persistent lookups. The SSIS enhancements from SQL Server 2008 R2 are improved scripting experience, data profiling task, an enhanced ADO.NET destination adapter, which also includes an option of Use bulk insert when available to improve the performance of bulk insert operations, improved data flow lookup, component with enhanced performance, and caching for Lookup transformation. The development tool for SSIS is Visual Studio 2008 development and in short BIDS too. BI Development Studio...

Previous Section
End of Section 7
Next Section