Pre Check List for 64 BIT SQL Server 2008 Cluster Installation

My tips for cluster installation with Windows 2008 and SQL 2008 on a 64 BIT server which is clustered.

Windows Server 2008 Cluster feature

Understanding why there is still downtime with Microsoft Clustering

I want to institute a high availability solution for SQL Server with no downtime. I am planning on using Microsoft clustering, but I have been told that in the event that the cluster moves the SQL Server from one physical server to another, that there is some downtime. Why is this so?

SQL Server 2008 Failover Clustering

This white paper complements the existing documentation on planning, implementation, and administration of a SQL Server 2008 failover cluster, which can be found in Microsoft SQL Server 2008 Books Online. There are links to relevant existing content throughout the paper, which is intended primarily for a technical audience. This white paper covers failover cluster architecture and concepts for Windows Server (2003 and 2008) and SQL Server 2008; installation of a SQL Server 2008 failover cluster; upgrades and updates to SQL Server 2008 failover clustering; and maintenance and administration of SQL Server 2008.

Attribute Discretization: Using the “Clusters” Method

Join BI Architect Bill Pearson as he leads hands-on practice with the “Clusters” discretization method in Analysis Services. In this article we continue to explore attribute discretization, as a part of an extended examination of the dimensional model lying at the heart of the integrated Microsoft Business Intelligence solution.

Failing SQL 2005 Cluster Installation because of too many cpu's

A Failing cluster installation because of too many processors. Sander Stad explains how you might be able to solve this in your environment.

Estimating the table size...

This is an effort to program the "Estimating the Table size" section given in BOL.

Prepare SQL Server 2005 in a Clustered Environment for SP3

This article from shows how to prepare your SQL Server 2005 clustered environment for Service Pack 3 and avoid some common problems.

Planning Ahead - Single Node Clusters

People don't plan to fail; they fail to plan. Single node clustering provides organisations with a ready made scale-up or high availability platform from the beginning of the deployment.

Setting up a SQL cluster under MS VS2005 R2 Part2

Continuing with setting up a 2 node SQL cluster under MS Virtual server 2005 Ent R2 SP1, Perry Whittle looks at the SQL configuration in this article.