This step-by-step article describes the steps you must use to change domains for an existing SQL Server 2000 Failover Cluster.

Give Us Your Nightmare Vote

by Site Owners

SQLServerCentral.com

SQLServerCentral

All the submissions for the Nightmare Contest are in, now take a moment and vote for your favorite.

Exotic use of User Defined Function

by Leo Peysakhovich

SQLServerCentral.com

User Defined Function (UDF)

User defined functions were added in SQL Server 7 and enhanced in SQL Server 2000, but they are still a relatively little used feature. Here's a look at a unique way that Leo Peysakhovich solved a problem using a UDF.

Pie Charts in Reporting Services

by Additional Articles

Database Journal

Development

Reporting Services is one of the hottest new tools that adds on to SQL Server. William Pearson continues his series on this new product with a look at how to add pie charts to your report.

Review: SQL Auditor

by Mike Pearson

SQLServerCentral.com

Product and Book Reviews

How solid is your SQL Server database design? Will it perform well in practice? SSW has a product, SQL Auditor, that compares your design against a number of well known design rules and gives you reports based on how well your design does. Read Mike Pearson's review of this product.

Schemas in ADO.NET 2.0

by Additional Articles

MSDN Communities

.Net

When you decide on a connection string and add a Data Connection, each Data Connection also displays a tree of information about the database objects (like tables, views, and stored procedures) visible directly through the connection. But where does this information come from? Read this article from MSDN on the new features of ADO.NET.

Review of IIS Admin Tool (No, its not a SQL article)

by Andy Warren

SQLServerCentral.com

Miscellaneous

Win XP Pro limits users to one web site, but developers often need to be able to switch between sites when coding locally. This free tool let's you easily do just that. Why an article on an IIS tool on a SQL site? We think it might be useful to you or someone on your team, and lots of SQL developers use IIS as well.

The State Of IT

by Steve Jones

SQLServerCentral.com

Rants

In 2004 is the IT industry expanding or contracting? Is your job secure? Steve Jones recently completed a survey and just got the results. Read this short summary of the results.