sqlCrunch.com :: SQL Server HAL Links

Flash demo that focuses on high-availability capabilities in SQL Server 2005, which translates to infrastructure architecture touch points necessary to build a highly available enterprise data service ... Source : Microsoft.com - Article

Database Architecture at Microsoft

An overview of Microsoft’s internal SQL Server 2005 Operations. How they manage their own databases internally for High Availability ... Source : Microsoft.com - Technet Article

Table Partitioning

SQL Server 2005 Partitioned Tables

A comprehensive whitepaper by Kimberly Tripp on the new Partitioned Table feature in SQL Server 2005. Includes scripts and examples. Covers the history of partitioning in previous versions of SQL Server and how the new feature can be used to dramatically increase performance and availability whilst significantly decreasing administration costs ... Source : SQLskills.com

How to Implement an Automatic Sliding Window in a Partitioned Table on SQL Server 2005

This article shows how to implement an automatic sliding window in a partitioned table on Microsoft SQL Server 2005 ... Source : Microsoft.com - MSDN Article

Bulk Loading Data into Partitioned Tables

A white paper on best practices for loading bulk data into partitioned tables. Particularly useful for data warehouse loads ... Source : Microsoft.com - Technet Article

Partition Management Tool on CodePlex

Stuart Ozer from the SQLCat team has posted an excellent utility on CodePlex for managing partition staging tables ... Source : MSDN Blog - SQLCat Team - Blog Post

Database Mirroring

Database Mirroring Best Practices

Database Mirroring Best Practices and Performance Considerations ... Source : Microsoft.com - Technet Article

Database Mirroring FAQ

Common questions surrounding Database Mirroring features and requirements ... Source : Microsoft.com - Technet Article

Can defragging an index break synchronous mirroring ?

In this post, Paul talks about some of the situations in which a synchronous mirror may enter the "Synchronizing" status ... Source : Paul Randall - SQLskills.com - Blog Post

Implementing Application Failover with Database Mirroring

Database mirroring allows a database to fail over from one server to another. For a seamless user experience, it is important that the application automatically reconnect to the current principal server. This paper describes how to enable your application to automatically fail over when database mirroring failover occurs ... Source : Microsoft.com - Technet Article

Database Mirroring

A comprehensive overview of Database Mirroring in SQL Server 2005 ... Source : Microsoft.com - Technet Article

Database Mirroring Event Alerts

This document describes the database mirroring events that SQL Server generates and how to configure alerts on these events using SQL Server Agent. Two sample scripts are also provided to demonstrate these concepts ... Source : Microsoft.com - Technet Article

Combining Database Mirroring and Log Shipping in SQL Server 2005

This topic discusses considerations for combining log shipping and database mirroring ... Source : Microsoft.com - MSDN Article

Database Mirroring and Log Shipping Working Together

Log shipping and database mirroring can work together to provide solutions for high availability and disaster recovery. You can convert an existing log shipping configuration to a database mirroring configuration. Although Microsoft only supports a single mirror database, you can set up log shipping from a database mirroring pair to additional servers, to provide multiple failover sites. Moreover, you can easily switch which pair of instances is using database mirroring and which instances are configured with log shipping ... Source : Microsoft.com - Whitepaper

Clustering

Clustering Whitepaper

Comprehensive document about implementing failover clustering for SQL Server 2005 and Analysis Services ... Source : Microsoft.com - Download

Top Tips for SQL Server Clustering

Running SQL Server on a cluster, Hardware and software requirements, Clustering one node, Cost-effective options ... Source : Microsoft.com - Technet Article

SQL Server Disaster Recovery (DR) and SANs, Remote Mirrors and Geo-Clusters

Great blog entry discussing the various DR options including remote mirrors and geo-clustering ... Source : Mat Stephen - Blog Post

Microsoft Windows Clustering

Four white papers covering Windows Clustering technology including geo-clustering and san mirroring ... Source : Microsoft.com Article

Using Microsoft Virtual Server 2005 to Create and Configure a Two-Node Microsoft Windows Server 2003 Cluster

This guide provides step-by-step instructions for creating and configuring a typical, single quorum device, two-node server cluster using Microsoft Virtual Server 2005 ... Source : Microsoft.com - Technet Article

Other HAL Techniques

Achieving Scalability & Availability with Peer to Peer Transactional Replication

Discusses the benefits and evolution of peer-to-peer transactional replication. It then outlines the steps for configuring a peer-to-peer topology and provides scripts and detailed directions for completing setup of this topology ... Source : Microsoft.com - Technet Article

Scalable Shared Databases

Shared Scalable Databases are a feature of SQL Server Enterprise edition to access the same database hosted on a SAN from several server instances. That means that read-only workloads can be scaled out by adding additional servers accessing the same database, and each server operates with it’s own CPU’s, RAM and TempDB ... Source : Microsoft.com - Knowledge Base Article