RSS Feeds

Article Topics

All Articles

Performance Tuning

Audit

Business Intelligence

Clustering

Reporting Services

SQL Azure

Developer

General DBA

PowerShell

Windows Server

ASP.NET / ADO.NET

SQL Azure

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...

Latest FAQ's

SQL Agent job getting suspended.

Queries which include DMFs return a syntax error ...

Could not find stored procedure 'dbo.sp_MSins_dboTest'

How to change server name when replication is enabled.

SQL Server General DBA Articles

Overview of SQL Server 2008 R2 Express Edition
This article outlines the new features in SQL Server 2008 R2 Express as well as providing a detailed installation guider.

Physical Join Operators in SQL Server - Hash Operator
In the concluding part of the Physical Operators series we look at the Hash operator.

Physical Join Operators in SQL Server - Merge Operator
Part II of the Physical Joins series looks at the Merge operator.

Physical Join Operators in SQL Server - Nested Loops
SQL Server implements three different physical operators to perform joins. Part one of this three part series looks at nested loops.

Using SQL Server Default Trace
Default Trace is a useful tool for gathering data and information on your SQL Server environment and can be very useful in troubleshooting your environment.

Running SQL Server Jobs using a Proxy Account
Proxy accounts are a useful tool to enable teams to work independently allow users who do not have administrative access to SQL Server to run jobs.

Getting Started with PowerShell for SQL Server
PowerShell is a powerful scripting tool which can be used to interact with SQL Server objects as well as monitor SQL Server instances. WinServerHelp.com

Restoring a Publisher Database in SQL Server
A guide to performing a restore on a publisher database.

A High Level Comparison Between Oracle and SQL Server - Part IV
The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.

A High Level Comparison Between Oracle and SQL Server - Part III
Part III of the Oracle / SQL Server comparison looks at the configuration options for each database, their storage options as well as the startup and shutdown procedures.

A High Level Comparison Between Oracle and SQL Server - Part II
Part II or the Oracle / SQL Server comparison dives deeper into databases by exploring the architectural differences.

A High Level Comparison Between Oracle and SQL Server
Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.

SQL Server 2008 R2 Multi-server Administration - A First Look
One of the most useful new features of SQL 2008 R2 for DBA’s is the ability to manage and administer multiple instances of SQL Server from a central location using the new SQL Server Utility tool.

An overview of Master Data Services - MDS in SQL Server 2008 R2
With Master Data Services, IT organizations can centrally manage critical data assets companywide.

Upgrade SSIS 2005 Packages to SSIS 2008
Follow this setp-by-step walkthrough to upgrade your SSIS 2005 packages to 2008

Copy Only Backups for Adhoc Backups
Copy only backups are independent of the sequence of normal SQL Server backups and are useful for ah-hoc scenarios where a backup/restore is necessary.

Using WMI Data Reader and WMI Event Watcher Tasks in SSIS
Windows Management Instrumentation (WMI) Tasks within SSIS can be used by to read WMI data and to watch for WMI events.

SQL Server Employment Trends
The latest employment trends in the SQL Server marketplace.

Using The Transfer Jobs Task in SQL Server Integration Services
Database Administrators can use the Transfer Jobs Task to transfer one or more SQL Server Agent Jobs between different SQL Server instances

Using Transfer Error Messages and Transfer Master Stored Procedures Tasks in SSIS
DBA's can use the Transfer Error Messages and Transfer Master Stored Procedures tasks to transfer error messages and stored procedures between difference SQL Server instances.

Migrating SQL Server Databases - The DBA's Checklist (Part 3)
The final part of the series will examine full text catalogs and indexing, database collation, service broker considerations, encryption and high availability.

Migrating SQL Server Databases - The DBA's Checklist (Part 2)
Part 2 of the database migration series examines setting database options, mapping database users to logins, recovery models, backups, and changing the code associated with configurations.

Migrating SQL Server Databases - The DBA's Checklist (Part 1)
Migrating a database is often a task fraught with complications, this series examines the key issues in a simple checklist.

Understanding Scans And Seeks
Whether a query uses Scan or Seek can have a big impact on the cost of excuting that query. This article examines when each is used and which is optimal.

SQL Server Security Audit (Part 2) - Database Level Audit
The second in the Security Audit series looks at securing an individual database.

Using Transfer SQL Server Objects Task and Execute SQL Tasks in SSIS
The Transfer SQL Server Objects Tasks is a very useful tool in SQL Server 2005 to move objects between SQL Server Instances.

12 Essential Steps After Installing SQL Server
Rolling out SQL Servers is a key task for DBAs, this articles provides 12 essential post-installation steps.

Context Switching or Database Impersonation using EXEC AS
SQL Server 2005/2008 provides the ability to change the execution and security context with the EXEC or EXECUTE AS clause to allow a user to perform high privileged activities without allowing the user to have high privilege access.

Transfer Logins Task and Transfer Database Task in SSIS
The Transfer Logins and Transfer Database tasks can be used in combination to easily and efficient migrate databases and users across different SQL Servers.

Practical Database Change Management (Part 2)
The final article on Change Management examines the more technical aspects of Change Management.

Practical Database Change Management (Part 1)
Changing a database an integral and crucial part in every application's life cycle. Part 1 of this series looks at the steps and procedures prior to implementing the change

Execute SQL and Bulk Insert Tasks in SSIS
Learn how the Execute SQL and Bulk Insert tasks can be combined to create a database and insert data into the database.

Container Tasks in SQL Server 2008 Integration Services
Learn how container control flow tasks within SSIS can be used by database developers to provide a structure to a package and repeat control flows.

Analyzing SQL Server Permissions
This article shows the steps to analyze SQL Server logins and permissions to ensure that there are no logins and users that exist who are have unnecessary access

Surface Area Configuration Using Policy Based Management
This article shows how the SQL Server Surface Area Configuration can be managed in SQL Server 2008

New Features in SQL Server 2008 Management Studio – Part 3
This article looks at the Transact SQL Debugger features which was reintroduced in SQL Server 2008

New Features in SQL Server 2008 Management Studio – Part 2
This article is the second article in a series that explores new features that are available in SQL Server 2008 Management Studio

New Features in SQL Server 2008 Management Studio – Part 1
This article shows the new features that are available in SQL Server 2008 Management Studio

Understanding the Basic of Triggers
The following article looks at how a DML Trigger can be used in SQL Server

Steps to Install SQL Server 2008
This article walks through the steps to install SQL Server 2008

How to Configure and Use the Central Management Server Feature in SQL Server 2008
This article shows how the Central Management Server (CMS) can be used as a repository to store all the SQL Servers instances within an organization that need to be managed

Peer-to-Peer Replication in SQL Server 2008
This article describes the new Peer-to-Peer replication features in SQL Server 2008

Create Backups without Breaking the Database Backup Sequence
This article shows how the COPY_ONLY clause can be used to ensure that an ad-hoc database backup do not break the backup sequence

Recover Data Using Database Snapshots
This article shows how database snapshots can be used to recover data in a source database

Backup User Databases Using a Maintenance Plan
This article shows how to create Full, Differential and Transactional Log backups using a Database Maintenance Plan

Differential Database Backups in SQL Server
The article describes how a DBA can use a differential backup strategy to perform a database backup

Backup System Databases Using Maintenance Plans
This article describes the process of how to backup system databases using a Maintenance Plan

Overview of Maintenance Plans in SQL Server 2008
After reading this article you will understand the different types of maintenance plan tasks that are available and their usage

Dedicated Administrator Connection in SQL Server
This article describes how a DBA can use the Dedicated Administrator Connection to troubleshoot SQL Server when the when a standard connection is not possible

How to Use the Microsoft SQL Server 2008 Upgrade Advisor Tool
This article shows how to use the SQL Server 2008 Upgrade Advisor Tool to improve the SQL Server 2008 upgrade experience

Grouping Sets in SQL Server 2008
This article shows how to use the GROUPING SETS feature in SQL Server 2008

Configure Windows Firewall for SQL Server Integration Services
In this article the steps to access SQL Server Integration Services through a firewall are described

Restore Transaction Logs for Point in Time Recovery
This article shows how a database can be restored to achieve point in time recovery

Super Sizing Columns in SQL Server
This article describes how to work with large objects in SQL Server using the MAX Specifier

Fixing Orphaned Users in SQL Server Database
This article will show the steps that a DBA needs to follow in order to resolve Orphaned Logins

Table Valued Parameters in SQL Server 2008
This article describes how a table variable can be passed to a Stored Procedure in SQL Server 2008

System Databases in SQL Server
This article will explore the system databases in SQL Server

Database Recovery Models in SQL Server
This article discusses in detail the three database recovery models and how to choose the appropriate recovery model

Filtered Indexes in SQL Server 2008
This article demonstrates the performance improvements that can be achieved using Filtered Indexes in SQL server 2008

Importance of Database Backups and Recovery Plan
As a DBA you need to ensure that the databases you manage are backed up regularly. This article details the importance of database backups and a recovery plan

Data Compression in SQL Server 2008
This article looks at how Data Compression can be used to reduce the space of database objects in SQL Server 2008

SQL Server 2008 MERGE Statement
This article introduces how the SQL Server 2008 MERGE statement can be used

Obtain Exclusive Access to Restore a SQL Server Database
Being able to restore a SQL Server database in one of the most important DBA skills. This article shows how to obtain exclusive access to a database to perform a restore

Configure Windows Firewall for SQL Server Remote Connections
This article describes the process of how to configure the Windows firewall for SQL Server

Understanding Service Level Agreements
This article is excerpted from the upcoming title SQL Server 2008 Administration by Rod Colledge and published by Manning Publications. This article introduces the role of service-level agreements as part of an overall strategy to maintain a reliable SQL Server network.

Database Audit Specifications in SQL Server 2008
This is the final article of a three part series on Auditing in SQL Server 2008. This article shows how to setup a Database Audit Specification.

How Change Data Capture Can be Used
This article describes how Change Data Capture can be used in SQL Server 2008

Server Audit Specifications in SQL Server 2008
This is the second article of a three part series on Auditing in SQL Server 2008. This article shows how to setup a Server Audit Specification.

Server and Database Auditing in SQL Server 2008
This article is the first in a three part series on Auditing in SQL Server 2008

So, you find yourself On-Call
In this article TJay shares some of his experience of being the on call DBA

Administrator & Monitoring Change Data Capture in SQL Server 2008
This article explores how a DBA can administer and monitor Change Data Capture in SQL Server 2008

Importance of the Resource Database
This article describes the importance of the Resource database in SQL Server 2005 & 2008

SQL Server 2008 Capture DML Changes Using Change Data Capture
In this article Ashish continues to explore the Change Data Capture feature in SQL Server 2008. This article demonstrates how to track DML changes

Configure Filestream in SQL Server 2008
SQL Server 2008 offers a wide variety of features and FILESTREAM is one of the most anticipated. This article describes how to configure the FILESTREAM feature.

Capture DDL Changes using Change Data Capture with SQL Server 2008
In this article we will see how Change Data Capture (CDC) in SQL Server 2008 can help DBA's to track DML changes

Configure and Manage Policy Based Management in SQL Server 2008
The following article describes how to use the Policy Based Management feature in SQL Server 2008

Using Column Sets with Sparse Columns
This article provides an overview of the use of Column Sets with Spare Columns in SQL Server 2008

Loading XML data into SQL Server 2008
This article provides a step by step guide on how to create and configure an SSIS package which can be used to import XML data

How to configure and Use Database Backup Compression in SQL Server 2008
SQL Server 2008 introduces the Database Backup Compression feature. This article describes how to take advantage of this new feature

Fast Database File Creation for Large Databases in SQL Server 2005
This article describes how to enable Instant File Initialization in SQL Server 2005

Transparent Data Encryption in SQL Server 2008
This article describes how the Transparent Data Encryption feature in SQL Server 2008 can be used to secure your databases

Usage of SQL Server Database Snapshots
Database Snapshots are a new feature in SQL Server 2005 which many DBA's are not aware of. In this article Dinesh Asanka provides an overview of this feature.

Creating Custom Reports for SSMS
The new custom report feature of SQL Server 2005 SP2 allows you to incorporate Reporting Services report definitions (.rdl) files into SQL Server Management Studio (SSMS).

Importing Poorly Formatted Text Files using SSIS
Importing text files is a common task for DBA's and Developers, but what happens when the text file is not properly formatted?

Data Cleansing with SSIS
SSIS introduces several new tools including Fuzzy Logic to aid data cleaning.

Isolation Levels in SQL Server 2005
Isolation levels are used to prioritize the acccess to a resource. SQL Server 2005 extends upon the support for isolation levels in 2000 with several new features including an additional level.

SSIS Package Configuration in SQL Server 2005
SQL Server 2005 allows DBAs to set configurations for SSIS packages outside the package to facilitate a smooth transition between different environments.

A Look at Microsoft SQL Server Upgrade Advisor
Microsoft SQL Server Upgrade Advisor tool helps the user with the process of upgrading SQL Server 2000 (or 7.0) instances to SQL Server 2005. It analyzes the configuration of installed SQL Server 2000 (or 7.0) components and generates reports. The reports give an idea of the issues that will hinder the upgrade process.

Server System Architecture, 2007 (Preliminary)
The original article in this series was published in 2002 and covered Pentium III and Pentium III Xeon systems. It is now time for an update to the Core 2 and Opteron based systems of 2007 and a look ahead to 2008. By Joe Chang.

DDL Replication in SQL Server 2000 and 2005
You may have wondered how to add, drop, or alter (type or size) a column of a table that is an article of a publication. I have seen this question in many forums and discussion boards. Obviously, dropping the replication, making the necessary changes, and then recreating the replication is not efficient. By Dinesh Asanka.

Keeping Your SQL Server Databases Defragmented with Diskeeper
Physical file fragmentation can hinder SQL Server's performance. Learn how Diskeeper can help resolve this problem.

Security Enhancements in SQL Server 2005: Schema
This article will discuss the key features of authorization in SQL Server 2005. Among the several authorization features, schema is the most valuable and confusing special feature.

How To Configure SQL Mail to Work With GroupWise
Learn how to configure GroupWise to work with SQL Server Mail.

Centralized SQL Server 2000 Monitoring
Learn two different ways to help centrally manage your SQL Servers

Creating Backup Jobs in SQL Server 2005
The SQL Server 2005 Maintenance Plan feature has been significantly modified in comparison with SQL 2000: now it utilizes new Integration Services. Also, creating database and transaction log backups is not as clear as it was in SQL 2000. This article does not describe all available SQL Server 2005 backup features or provide some tricks dealing with them; instead, it offers solutions for the most commonly used backup jobs.

E-Mail Functionality in SQL Server 2005
With the arrival of SQL Server 2005, users now have the new functionality of Database Mail, which is different from SQL Server 2000 SQL Mail. The purpose of this article is to introduce Database Mail and highlight the advantages of using it over legacy SQL Mail.

Peer-to-Peer Transactional Replication in SQL Server 2005
As you may be aware, SQL Server 2000 provides three types of replication: Snapshot replication, transactional replication, and merge replication. SQL Server 2005 includes a new replication method: Peer-to-peer transactional replication.

SQL Server Books Online: A Primer for New Users
This article is for new users of SQL Server … I'm a big fan of SQL Server Books Online (BOL). It has helped me a lot and I have saved a fair amount of time that I would have spent searching through books or on the Web for answers.

Interview with SQL Server Master Trainer Scott Whigham, Owner of LearnSQLServer.com
Scott Whigham is a SQL Server consultant and trainer. Recently, he started a new website called LearnSQLServer.Com. I recently met Scott at a training event and was impressed with his teaching ability, so I decided to interview him.

Select Based on List of Random Values — Dynamic SQL or CSV Parsing UDF?
How do you pass random-list based criteria to a stored procedure and how do you achieve a good execution plan without a recompilation each time the query is executed?

Dealing with the Dodgy GO Command
The GO command signals the end of a batch of SQL statements and executes them as a whole. Seems simple enough. But using GO can be disastrous if you don't understand its usage in a certain scenario.

Scripts for Space Monitoring Report
Scripts to complement the 'Monitor Your Database Servers with DTS, Part 3: Space Monitoring of SQL Servers' article.

Monitor Your Database Servers with DTS, Part 3: Space Monitoring of SQL Servers
In this final article on how to monitor a large number of servers from a centralized location using Data Transformation Services (DTS), I explain how to monitor space utilization of databases on all the servers.

Generate Log Files with a Trigger
The following article will show you how to log DML changes to specific tables in your database, using triggers.

SQL 2000 to SQL 2005: Where Have All the Old Features Gone?
Although Management Studio has some very nice long-awaited features, some of the good old stuff just isn't there.

Scripts for Errorlog Monitoring of SQL Servers
Scripts to complement the 'Monitor Your Database Servers with DTS, Part 2: Errorlog Monitoring of SQL Servers' article.

Monitor Your Database Servers with DTS, Part 2: Errorlog Monitoring of SQL Servers
In the second of three articles on how to monitor a large number of servers from a centralized location using Data Transformation Services (DTS), I explain how to monitor SQL Server errorlogs.

Scripts for Backup SLA Report
Scripts to complement the 'Monitor Your Database Servers with DTS, Part 1: Backup SLA Report' article.

Monitor Your Database Servers with DTS, Part 1: Backup SLA Report
In the first of three articles on how to monitor a large number of servers from a centralized location using Data Transformation Services (DTS), I explain the setup of a report that ensures that backups are happening as per the backup policy.

SQL PASS Community Summit vs. SQL Server Connections Conference
Don't know which SQL Server conference to attend, get one person's opinion here.

Implementing the SQL Server Multiple Publishers and Central Subscriber Replication Topology
Learn how to configure replication for multiple publishers with a central subscriber.

SQL Server Replication Across Domains and the Internet
Learn how to configure replication to work across domains or the Internet.

SQL Server 2005: The Replication GUI
The replication GUI screen has changed substantially in SQL Server 2005.

Replicating Stored Procedure Execution
Learn how to replicate stored procedure execution to reduce replication overhead and boost performance.

Kerberos Protocol Transition and Constrained Delegation
Learn how to implement Kerberos protocol transition and constrained delegation in SQL Server and IIS.

Learn About SQL Server Disaster Recovery from Vas Srinivasan of Sonasoft.com
Learn about the importance of disaster recovery in this interview with an industry expert.

An Interview with Simon Galbraith, Marketing Director of Red Gate Software, on Major Trends in the SQL Server Market
One person's perspective on what's happening in the SQL Server tools marketplace.

SQL Server 2000: View Basics
Learn the basics of Views in SQL Server 2000.

Taking a Proactive Approach with SQL Server Agent
Learn some of the basics of using SQL Server Agent.

How to Find a SQL Server Database Object
Learn how to write a stored procedure to make it easy for you to locate objects anywhere on a SQL Server.

Pros & Cons of Using SELECT, Views, and Stored Procedures in SQL Server
Learn how SQL Server treats SELECTs, views, and stored procedures

Keep Your SQL Servers Synchronized with SQL Compare and SQL Data Compare
Do you need to keep SQL Server database in synch? If so, find out if SQL Compare and SQL Data Compare are for you.

Can Amazon Serve Customers and Protect Privacy at the Same Time? (What Data Should DBAs Keep and Discard)
As a DBA, you need to consider the kind of data you collect, and whether or not is should be kept or discarded.

Migrating from Oracle to SQL Server
Migrating from Oracle to SQL Server is not a problem, if you know how.

Sample SQL Server Disaster Recover Plans
Learn how other companies put together their SQL Server disaster recovery plans.

SQL Server Stored Procedures for Beginners
Learn the basics of writing SQL Server stored procedures.

SQL Server Upgrade Recommendations and Best Practices Part 2: SQL Server 6.5 to 2000 Critical Upgrade Decisions and Redundant Upgrade Architecture
Part two of this article series focuses on the the technical components faced by DBAs and Developers during the upgrade process.

Making the Move from Sybase to SQL Server
If you are planning a move from Sybase to SQL Server, you had better check this article out.

How to Connect to SQL Server from Visual FoxPro
If you use Visual FoxPro to connect to SQL Server, then you will want to read this article.

How to Identify and Delete Duplicate SQL Server Records
Deleting duplicate SQL Server records is not as easy as you might expect. Learn how to identify and delete duplicate records in this article.

Create Your Own SQL Server Job Management System
If you don't have the ability to easily manage the jobs on your SQL Server, then you may want to consider writing your own SQL Server job management system, like the one described in this article.

SQL Server Startup Parameters
Learn how to take advantage of SQL Server startup options.

Track SP Changes by Automatically Saving Your SQL Server SP Text
Track SP Changes by Automatically Saving Your SQL Server SP Text

SQL Server Upgrade Recommendations and Best Practices Part 1: Upgrade Overview and Project Planning
First in a series of new articles on how to best upgrade SQL Server

SQL Server 2000 Undocumented Stored Procedures
Still more from author Alexander Chigrik on the secret world of undocumented SQL Server 2000 stored procedures.

Using Stored Procedures to Manage SQL Server Security
Stored Procedures are not only good for performance, they are also good for security.

Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions
Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions

Introduction to Data Mining with SQL Server
Learn the basics of data mining using SQL Server.

Troubleshooting SQL Server Full-Text Search Problems
Learn how to troubleshoot common full-text search problems.

Use This SP to Generate a SQL Server Job Report
Use this SP to create a report listing all of your SQL Server 7.0 and 2000 jobs.

Server System Architecture, 2002
Learn about the various chipsets, and their pros and cons, available for your SQL Server.

A Comparison of SQL Server 7.0 with SQL Server 2000
Are you still using SQL Server 7.0 and considering upgrading to SQL Server 2000? If so, this article may help.

Interview with Tim Hayes, dbPAL Developer and CEO of IT-Map
Learn about the "big picture" of SQL Server-based software development from an industry veteran.

SQL Server 7.0 and 2000 Trace Flags
Learn about documented and undocumented SQL Server 7.0 and 2000 trace flags.

How 11GB of SQL Server Data Mysteriously Disappeared, and How I Ended Up Better Off than Before
What would you do if your SQL Server database mysteriously lost 11GB of data? Find out what happened to me. By Brad M. McGehee.

Inside SQL Server Maintenance Plans
Learn what happens under the covers when you use the Maintenance Wizard to create maintenance plans.

Manage Multiple SQL Server Installations and Databases with OSQL
Learn how to use OSQL to automate SQL Server management.

Some Useful Undocumented SQL Server 2000 Trace Flags
You can never know too much about SQL Server trace flags. In this article, find out about those that are undocumented in SQL Server 2000.

Auditing Your SQL Server Environment, Part II (Reviewing Role Memberships)
In this second article of a series, learn how to audit SQL Server role memberships

Interview with Carl Speshock, Author of the Microsoft SQL Server 2000 Database Administrator's Guidebook
Find out more about the author of the Microsoft SQL Server 2000 Database Administrator's Guidebook, and what he thinks about SQL Server.

Understanding SQL Server's DBCC SHOWCONTIG
Find out how to use the DBCC SHOWCONTIG command to boost the performance of your databases.

Some Useful Undocumented SQL Server 7.0 Trace Flags
Learn about these undocumented SQL Server 7.0 trace flags.

Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands
Author Alexander Chigrik is at it again, showing you more undocumented commands, this time DBCC commands for SQL Server 7.0 and 2000.

How to Script User and Role Object Permissions in SQL Server
Use these scripts to help you move object permissions from one database to another.

Auditing Your SQL Server Environment Part I
Learn how to audit login security in your SQL Servers.

The Self-Taught DBA
Are you thinking of becoming a master DBA? If so, find out how you can.

Overview of the SQL Server Security Model and Security Best Practices
Learn about the SQL Server security model and SQL Server security best practices.

SQL Server 7.0 Undocumented Stored Procedures
More from author Alexander Chigrik as he helps us discover the secret world of undocumented SQL Server 7.0 stored procedures.

SQL Server Replication from 6.5 to 2000
Find out how to replicate data from a SQL Server 6.5 database to a SQL Server 2000 database. Includes some related performance tips.

Data Page Structures in SQL Server 6.5
Learn about the underlying architecture of SQL Server 6.5 data storage.

How to Troubleshoot SQL Server 7.0 Installation Issues
Find out how to troubleshoot failed SQL Server 7.0 installations.

Creating Logins for Databases Restored to a Replacement SQL Server
Find out how you can easily move SQL Server logins from one server to another.

How Updates are Performed in SQL Server 6.5
If you are still using SQL Server 6.5, this article on how SQL Server internally handles updates might make for some interesting reading.

Start Preparing Today for the SQL Server 2000 Enterprise Certification Exam
This article provides tips on how to prepare to take the SQL Server 2000 Enterprise certification test.

Compare SQL Server Databases with sp_CompareDB
Use this powerful, free, stored procedure to compare database structures and data.

SQL Server 6.5 Useful Undocumented Stored Procedures
Author Alexander Chigrik helps us discover the secret world of undocumented SQL Server 6.5 stored procedures.

Useful Undocumented SQL Server Extended Stored Procedures
SQL Server offers many features that are not documented in the Books Online. Here are some of the undocumented extended stored procedures found in SQL Server 7.0 and 2000.

Undocumented SQL Server 7.0 System Tables
Learn the inner workings of these undocumented SQL Server 7.0 system tables.

Some Useful Undocumented SQL Server 6.5 DBCC Commands
If you are still supporting SQL Server 6.5, then this article on undocumented SQL Server 6.5 DBCC commands may prove very useful.