Site sponsored by:

Home

Articles

Forums

Tips

FAQ's

Blogs

Software

Books

About Us

RSS Feeds

Article Topics

All Articles

Peformance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

Developer

General DBA

ASP.NET / ADO.NET

SQL Server 2008 - Worth the Wait

SQL Server’s first significant upgrade in three years features a number of envelope-pushing enhancements and improvements. Which will have the greatest impact on SQL administration and development? More...

Latest FAQ's

SSIS Lookups are Case Sensitive

Convert Number to Words in SSRS

After installing SP2 on SQL Server 2005 x64, when trying to ...

Remote Name Could not be Resolved in SQL Server Reporting Services ...

SQL Server Clustering Articles

Database Mirroring in SQL Server 2005
Mirroring allows a user to create an exact copy of a database on a different server. This article outlines how to implement mirroring in SQL Server 2005.

SQL Server 2005 Clustering Best Practices
This cluster checklist to success summarizes all of the best practices you should follow if you want to install, configure, and maintain a solid SQL Server 2005 cluster.

How to Cluster SQL Server 2005
The procedure to install a SQL Server 2005 instance onto a cluster is one of the easiest parts of getting your SQL Server 2005 cluster up and running. The SQL Server 2005 setup program is used for the install and does the hard work for you. All you have to do is make a few (but critically important) decisions.

SQL Server 7.0, 2000 and 2005 Clustering Resources
If you are seriously considering implementing SQL Server 2000 or 2005 under Windows 2000 or Windows 2003; then I highly recommend that you review these resources before you begin.

How to Cluster Windows Server 2003
Before you can install SQL Server 2005 clustering, you must first install Windows Server 2003 clustering services. In this article, we take a step-by-step approach to installing and configuring Windows 2003 clustering.

An Introduction to SQL Server 2005 Clustering Basics
Clustering is a complex technology with lots of messy details. To make it easier to understand, let's take a look at the big picture of how clustering works.

Preparing the SQL Server 2005 Clustering Infrastructure
Before you even begin building a SQL Server 2005 cluster, you must ensure that your network infrastructure is in place. Here's a checklist of everything that is required before you begin installing a SQL Server 2005 cluster.

Should You Upgrade Your Current SQL Server Cluster to a SQL Server 2005 Cluster?
If your organization is like many organizations, it may have some older version SQL Server clusters in production. If so, at some point you will have to make a choice about how to upgrade them to SQL Server 2005. Let's look at the available options.

How to Create Nonkey Columns in Nonclustered Indexes in SQL Server 2005
In SQL Server 2005, we now have a new feature called "nonkey column nonclustered indexes." This new feature is a variation of the standard covering index, but with some advantages. By Brad M. McGehee.

Does SQL Server 2005 Clustering Really Make Sense for My Organization's Needs?
As the forum administrator for SQL-Server-Performance.Com, I see hundreds of questions from DBAs on SQL Server clustering. What always surprises me is how misunderstood clustering is.

How to Configure Virtual Server 2005 in Order to Setup a Test SQL Server Cluster
Learn how to use Microsoft Virtual Server 2005 to create an inexpensive SQL Server cluster for learning and testing.

SQL Server 2000 & 2005 Clustering
Detailed article covering all aspects of SQL Server 2000 and 2005 clustering

How to Attain SQL Server High Availability at Minimal Cost
Attaining highly available SQL Servers amounts to doing a lot of little things right.

What is New with SQL Server Clustering on Windows 2003
.

Un-Install a SQL Server Cluster: Step-by-Step
.

Installation of SQL Server Clustering
.

Designing your SQL Server Cluster
.

How Clustering Works
.

Basics of SQL Server Clustering
.

Gigabit Ethernet Direct Connect Networking
If you need to direct connect two gigabit cards, as you might want to do in a SQL Server cluster, here's how to do it.

How to Implement SQL Server Log Shipping Using Visual Basic
Learn how you can use Visual Basic to create your own SQL Server log shipping solution.

Achieving Massive Scalability with SQL Server
Traditional and emerging techniques for clustering SQL Server for applications where scalability is paramount.

How to Upgrade a SQL Server 7.0 Cluster to a SQL Server 2000 Cluster
Learn how to upgrade your current SQL Server 7.0 cluster to a SQL Server 2000 cluster.

Real Life DBA: Dealing with a SQL Server Cluster Failover
What's is really like to experience a SQL Server cluster failover on your most important production server?

Testing SQL Server 2000 Clusters
Guider on how to test a SQL Server 2000 Cluster

Installing the SQL Server 2000 Service Pack
Instructions on how to install the latest service packs for SQL Server 2000

Installing SQL Server 2000 Clustering
Step by Step instructions on how to install a SQL Server 2000 Cluster

Preparing for SQL Server 2000 Clustering
Demonstrates how to install SQL Server 2000 clustering onto a Windows 2000 two-node cluster.

How to Install SQL Server 2000 Clustering
This extensive article series discusses how to install SQL Server 2000 Clustering on a Windows 2000 Cluster

An Introduction to SQL Server Clustering
Learn the basics of how to create high-availability SQL Server clusters

How to Perform SQL Server Log Shipping
You learn how to manually implement log shipping for SQL Server 7.0

Windows 2000 Cluster Services: Testing and Verifying the Windows 2000 Cluster Service
How to Test and Verify the Cluster Installation

Install Windows 2000 Cluster Services: Installing the Windows 2000 Cluster Service: Node 1
Installing the Windows 2000 Cluster Service

Install Windows 2000 Clustering Services: Establishing User Accounts and Security
Establishing User Accounts and Security for a Clustering Installation

Install Windows 2000 Cluster Services: Installing and Configuring Windows 2000
Configuring Windows 2000 for a Clustering Installation

Install Windows 2000 Cluster Services: Selecting and Preparing the Hardware
Selecting and Preparing the Hardware for a Windows 2000 Cluster Installation

How to Install Windows 2000 Cluster Services
This extensive article discusses how to install the Windows 2000 Cluster Service in preparation for installing SQL Server clustering.