An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.

ANSI Joins

by Neil Boyle

SQLServerCentral.com

T-SQL

Are you confused by all this inner join style syntax that is becoming more and more prominent lately? This article by Neil Boyle will help you find your footing in the ANSI join syntax.

SQL Server 7.0 and 2000 Clustering Resources

by Additional Articles

SQL Server Performance

Performance Tuning

A good place to start before clustering. Written by Brad McGhee, the founder of sql-server-performance.com.

Your Friend the Computer

by Steve Jones

SQLServerCentral.com

The Lighter Side

You know it is time to reassess your relationship with
your computer when....

Removing NT Administrators as Sysadmins

by Brian Knight

SQLServerCentral.com

Security

By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.

Security Alerts and Information

by Steve Jones

SQLServerCentral.com

Security

Security information for SQL Server in one place.

Quickly Enabling and Disabling Constraints and Triggers

by Brian Knight

SQLServerCentral.com

Administration

In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.

Simplifying Instead Of Triggers

by Neil Boyle

SQLServerCentral.com

Administration

Instead of triggers are a new feature in SQL Server 2000 which greatly extend the functionality of triggers. This article covers a basic introduction to Instead of Triggers and illustrates possibilities for their use.