---

[Focus]

---

Before Disaster Strikes
Don't wait until a disaster hits your company. Make a solid backup plan and test it now to make sure that your data will survive a crash.
 — Kimberly L. Tripp


Safe Transit
Before you move your database to a new server, be sure you know how to solve one of the most common restore problems: mismatched usernames and logins.
 — Kalen Delaney

---

[SQL Server Savvy]

---

A Set-Based Way to Find Specific Rows
Solutions that assume positioning of particular rows within a result set aren't easy for T-SQL, but learning how to handle such solutions is important.
 — Brian Moran


New Behavior of SQL:StmtCompleted
With the release of SQL Server 2000 Service Pack 1, the behavior of SQL:StmtCompleted changed. Learn what to expect when you try to capture events within a procedure.
 — Brian Moran


Profiler Pauses
Why does SQL Server Profiler seem to miss some events when you're processing a heavy load?
 — Brian Moran


Tip: Take a Peek at Information Schema Views
Got some free time? Take a look at the information schema views in the master database to learn undocumented tips and cool T-SQL tricks.
 — Brian Moran


Trying to Recover Without an .ldf
Learn what you can do to recover a database when you don't have the log file.
 — Brian Moran

---

[Editorial]

---

Shaken and Stirred
A shake-up in the database market has yielded a new database champ in terms of new license revenue: IBM. But on the fast-growing Windows platform, SQL Server claims the number-one spot and shows no signs of slowing.
 — Michael Otey

---

[SQL Seven]

---

Free SQL Server Tools
Many free tools are available on the Web to help DBAs and database developers. Here are my seven favorite free SQL Server utilities.
 — Michael Otey

---

[Inside SQL Server]

---

Two's a Crowd
Don't let your transactions get locked out. Use the best indexes for multiuser queries to help SQL Server avoid blocking problems.
 — Kalen Delaney

---

[Mastering Analysis]

---

Using ADO MD with .NET
Developers who are using Visual Studio .NET to develop production applications are discovering .NET and COM interoperability isn’t simple. Here’s how to avoid a couple of common problems when you try to integrate .NET with your existing COM applications.
 — Russ Whitney

---

[Solutions by Design]

---

Tracking Across Space and Time
Learn how to take advantage of pre-existing forms of identification such as Social Security numbers, define and use domains, and pick an appropriate primary key in this multifaceted approach to tracking student movement between schools.
 — Michelle A. Poolet

---

[T-SQL Black Belt]

---

The T-SQL Banker
This set-based T-SQL query might not solve all your financial problems, but it can help you compute balances and track index growth.
 — Itzik Ben-Gan

---

[Answers from Microsoft]

---

Replicating Referential Integrity
Microsoft’s SQL Server development team tells a reader how to propagate primary and foreign keys in both SQL Server 2000 and 7.0.
 — Microsoft's SQL Server Development Team


Updating Columns from One Table to Another
What’s your algebra quotient? Microsoft’s SQL Server development team explains how relational algebra comes into play when you update specified columns from a second table.
 — Microsoft's SQL Server Development Team

---

[Exploring XML]

---

Duplicating Virtual Directories
If you use SQLXML in your development environment and need to transfer projects between computers, here’s a handy script that quickly duplicates your virtual directories.
 — Rich Rollman

---

[Letters]

---

Letters, September 2002
Readers write in about speedier solutions for missing number queries and more Query Analyzer shortcuts.
 — Various Authors

---

[New Products]

---

New Products, September 2002
Check out the latest SQL Server-related new and improved products.
 — Carolyn Mader