|
|
| Book details / order |
| MICROSOFT SQL SERVER 2008 R2 ADMINISTRATION COOKBOOK OVER 70 PRACTICAL RECIPES FOR ADMINISTERING A HIGH-PERFORMANCE SQL SERVER 2008 R2 SYSTEM |
Microsoft sql server is a powerful relational database engine, widely used to store and maintain data in enterprises of various levels – be they small, medium, or large. sql server delivers a rich set of integrated services and reporting features that enable you to do more with your data such as query, search, synchronize, report, and analyze. sql server 2008 r2 accelerates the capabilities to scale database operations and is a highly scalable data platform.
this practical cookbook will show you the advanced administration techniques for managing and administering a scalable and high-performance sql server 2008 r2 system. it contains over 85 practical, task-based, and immediately useable recipes covering a wide range of advanced administration techniques for administering a high-performance sql server 2008 r2 system and solving specific administration problems. it shows how the sql server 2008 r2 system can be taken further.
packed with reusable, real-world recipes, the book starts by providing an overview of the server and specialized editions of sql server 2008 r2 technologies, features, and solutions. next it covers database administration and management principles with real-world examples. the book then dives deep into topics such as administration of core business intelligence services, management of core sql server 2008 r2 technologies, availability, security, and programmability, implementing new manageability features and practices, and maintenance and monitoring, amongst others.
administer a scalable and high-performance sql server 2008 r2 system using advanced administration techniques
what you will learn from this book :
discover best practice solutions for upgrading to sql server 2008 r2
employ the new enhancements in sql server 2008 r2
build a strategic multi-server management
automate administration tasks
implement the inter-operability of sql server analysis services and sql server reporting services with sharepoint 2010 services
manage and administer core sql server 2008 r2 business intelligence services
implement and manage essential availability and programmability enhancements
implement best practices and build troubleshooting techniques on a multi-instance and multi-database environment
approach
this book offers practical, task-based, and immediately usable recipes covering a wide range of advanced techniques for administering a high-performance sql server 2008 r2 system. in addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, its explanations go into great detail, which makes it good learning material for everyone who has experience in sql server and wants to improve. the book is designed in such a way that you can either read it chapter by chapter or refer to recipes that you want in no particular order.
although the book is focused on specific although the book is focused on specific microsoft sql server 2008 r2, most of the concepts and explanations are also applicable to sql server 2008.
who this book is written for
if you are an experienced database administrator and database architect who wants to design, administer, and manage a scalable and high-performance sql server 2008 r2 system, then this book is for you. the book assumes that you have a good understanding of database management systems, specifically experience in if you are an experienced database administrator and database architect who wants to design, administer, and manage a scalable and high-performance sql server 2008 r2 system, then this book is for you. the book assumes that you have a good understanding of database management systems, specifically experience in microsoft sql server 2008 administration.
about the author
satya shyam k jayanty is an independent consultant working as a principal architect and director for d bi a solutions limited based in the uk. he has a master's degree in economics and commerce from osmania university, hyderabad (india) and an mba – systems from the university of the west of england. satya started his career in the it industry in 1992, and he has been working with sql server (from version 4.2) for more than 15 years and has been an accomplished microsoft sql server mvp for the last six years. satya is a frequent speaker and sme volunteer at microsoft tech-ed, sql pass, sql bits, scottish area sql server user group. he maintains a blog at http://www.sqlserver-qa.net and http://www.sql-server-performance.com.
--------------------------------------------------------------------------------------------------------------
preface
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
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: more dba manageability best practices
index
Author : Satya shyam k jayanty
Publication : Packt publication
Isbn : 9789350235348
Store book number : 109
NRS 1160.00
|
 |
|
|
|
|
|
|
|
| |
|
|
