You create a maintenance plan on SQL2000 and...

Exploring SQL Server 2000 Configuration Properties

The SQL Server tools are top notch and often other platforms attempt to duplicate their handiness. Enterprise Manager is one that every DBA uses and it can perform a myriad of functions to configure your server. Read this new article by Dale Elizabeth Corey that looks that the wide range of items in the Configuration Properties of this tool.

What does ACID stand for?

Changing Domains for a SQL Server 2000 Failover Cluster

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

Sending SQL Notifications with CDOSYS

SQL Server has a nice alert system, but SQLMail leaves something to be desired. New author Desiree Harris, from hosting provider Orcsweb, looks at an alternative method for sending alerts using an SMTP server and without requiring Outlook to be installed.

You are using SQL Server 2000 SP3. You...

What is the Maximum number of tables and...

Troubleshooting and Debugging SQL Web Services Configurations

A Q&A look at the new Web Services configurations in SQL Server 2005.

Beginning SQL Server - Logins and Users

Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security.

Auditing with SQL Profiler

SQL Server includes a great auditing tool: Profiler. It's not the easiest tool to use, however, and it's one that takes some getting used to. Our resident security export, Brian Kelley looks at a simple example of using this tool to audit logins.