Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring - Paperback

by Michael Otey (Author)

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Create a Highly Available Microsoft SQL Server 2008 Environment

Written by the technical director for SQL Server Magazine, this expert guide shows you how to implement clustering and database mirroring in SQL Server 2008. Learn proven techniques for ensuring zero database loss, avoiding system downtime, and providing instant data backups. Filled with detailed instructions, Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring takes you from planning to management of a robust high availability solution.

• Configure Windows Failover Clustering
• Set up the Microsoft Distributed Transaction Coordinator on a two node failover cluster
• Install SQL Server 2008 on your cluster
• Handle cluster management and backup
• Configure and manage database mirroring for high availability
• Implement Hyper-V virtualization and Live Migration
• Manage a SQL Server virtual machine

Michael Otey is the technical director for SQL Server Magazine and Windows IT Pro and the bestselling author of Microsoft SQL Server 2005 Developer's Guide, Microsoft SQL Server 2008 New Features, and several other books. He is president of TECA, Inc., a software development and consulting company.

Back Jacket

CREATE ROBUST DATA MANAGEMENT AND BUSINESS INTELLIGENCE APPLICATIONS

Build powerful, enterprise-wide database programs using Microsoft SQL Server 2005 and the comprehensive information contained in this definitive volume. "Microsoft SQL Server 2005 Developer's Guide" explains how to develop server-side and client-side database applications and analyze business intelligence data. All of the brand-new features are covered in-depth -- including .NET CLR Integration, Reporting Services, Integration Services, Notification Services, and Service Broker. Real-world examples and practical tips detail how to use SQL Server 2005 as a cross-tier database platform with Visual Studio 2005, create custom management scripts with SQLCMD, and improve performance with SQL Profiler.

ESSENTIAL SKILLS FOR DATABASE PROFESSIONALS Use SQL Server Management Studio and Business Intelligence Development Studio Write stored procedures and use T-SQL Data Definition Language (DDL) and Data Manipulation Language (DML) Create custom database objects with .NET CLR Build enterprise database applications using ADO, ADO.NET, and ADOMD.NET Develop and deploy SQL Server Integration Services packages Design enterprise reports using Reporting Services and Report Builder Integrate cross-platform data using XML and Web services Extend SQL Server manageability using SQL Management Objects (SMO)

Author Biography

Michael Otey is the technical director for Windows IT Pro and SQL Server Magazine, and a bestselling SQL Server author.He is president of TECA, Inc., a software development and consulting company. He is the author of Microsoft SQL Server 2005 Developer's Guide, Microsoft SQL Server 2008 New Features, and several other books on SQL Server.