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.

Effective Dating Series Part I - The Problem

by Sam Bendayan

SQLServerCentral.com

Effective Dating

What are the benefits of Effective Dating and what problems does it solve?

In Praise of Barebones Applications

by Phil Factor

SQLServerCentral.com

Editorial

The English voice of IT reason, Phil Factor, brings us a guest editorial. Today he waxes about the overbearing processes used to build internal corporate applications.

Explore XML Data Type in SQL Server

by Additional Articles

Database Journal

SQL Server 2005 and 2008 provide native XML data type and provides extensive support for XML data processing. The easy conversion from XML to a relational table provides a way for set-based updates based on user input.

Generating SQL Scripts using Windows PowerShell

by Additional Articles

MSSQLTips.com

PowerShell

In a previous tip on SQL Script Generation Programmatically with SMO, you've seen how you can use SMO to generate SQL scripts programmatically. In this tip I will cover how to generate scripts using Windows PowerShell.

The old INNER JOIN syntax vs. the new INNER JOIN syntax

by Brian Kelley

SQLServerCentral.com

Blogs

I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...

TSQL Challenge #14

by Press Release

Other

T-SQL Challenges

A new challenge is up. See if you are up for the task of identifying the longest sequence of characters in a string before Oct 12

COPY_ONLY Backups

by Charles Kincaid

SQLServerCentral.com

Backup and restore

What are COPY_ONLY backups and why do we care? New author Charles Kincaid walks us through the basics of how you can create one of these backups.

Generation X

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones is a part of Generation X, who surprisingly seems to be more Web 2.0 oriented than Generation Y.

Energy Intelligence

by Additional Articles

DMReview

Data Warehousing

Given that companies spend on average between 7 and 12 percent of their annual budgets on energy – a focus on reducing energy consumption can have significant bottom-line impact

SQL Server 2008 Failover Clustering

Effective Dating Series Part I - The Problem

In Praise of Barebones Applications

Explore XML Data Type in SQL Server

Generating SQL Scripts using Windows PowerShell

The old INNER JOIN syntax vs. the new INNER JOIN syntax

TSQL Challenge #14

COPY_ONLY Backups

Generation X

Energy Intelligence

Blogs

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

Cultural Change: Fostering a Cost-Aware Culture in Your Organisation

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

Forums

Creating a JSON Document I

Who is Irresponsible?

Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments

Question of the Day

Creating a JSON Document I