By Brad M. McGehee – The purpose of this article is to show you how to install SQL Server 2000 Enterprise Edition onto a Windows 2000, two-node cluster using an Active/Passive configuration. Installing SQL Server 2000 clustering is not an easy task. It requires a good knowledge of Windows 2000, SQL

Learn from Microsoft experts how to code scalable, secure, high-performance server and datacenter applications for Windows 2000 and Windows .NET Servers.

SQLXML allows you to send queries to your SQL Server database and to be able to retrieve the results in XML over the web. You can then take these results and use them in your applications or publish them on the web. This article will tell you how to set it up.

MCSE and MCDBA Steven Warren demonstrates how to restore a SQL Server database backup to working order. From completing a full restore or restoring using T-SQL to performing a differential database restore or transaction-log restore, Warren’s got it covered in these step-by-step illustrated instruct

By Michael Otey – Solving problems, learning about new technology, or writing stored procedures to address user requests might be more fun, but ensuring database consistency and recoverability comes first.

Table variables are just plain cool. If you’re using temporary tables and don’t need transactions on those tables and want better performance I’d strongly consider using table variables instead. Table variables were introduced in SQL Server 2000. You create a table variable the same way you c

From SQLMag – I have a 30GB database, and I use the Full recovery model. Whenever I use Database Consistency Checker (DBCC) DBREINDEX to periodically reindex certain large tables, I change the recovery model to Bulk_Logged, then return it to Full after the reindexing is complete. I expected that thi

By Jonathan Lurie & Timothy Stockstill – Microsoft was initially slow to develop an Internet product. I recently read a quote from a ranking Microsoft employee who said, “If you cut us, we bleed XML.” While this may seem a little dramatic, it happens to be true: XML seems to be everywhere in Microso

Sample chapter – Learn the basics of how to program Analysis Services using ADO MD from the book, Professional SQL Server 2000 Data Warehousing with Analysis Services from Wrox Press.

Software introduced by Lumigent Technologies Inc. audits Microsoft SQL Server database activity by monitoring the product’s transaction log. The goal is to identify causes of database problems and recover lost data.