---

[Focus]

---

ADO.NET 101: SqlCommand
Executing SQL commands from your applications is easy when you understand ADO.NET's SqlCommand object.
 — Michael Otey


SQL Server and .NET: A Dynamic Duo
SQL Server and the .NET framework make a powerful pair for developing enterprise applications. If you're not familiar with .NET's languages and capabilities, this article's sample Web application can quickly bring you up to speed.
 — Rick Dobson

---

[Features]

---

Opening Microsoft's Performance-Tuning Toolbox
Microsoft's SQL Server Customer Advisory Team uses a repeatable methodology involving waits and queues to diagnose and solve customer performance problems. In this article, the team opens its toolbox and shares its effective techniques.
 — Tom Davidson

---

[SQL Server Savvy]

---

Moving the Log File
With sp_detach_db, you can quickly detach the database from the server, then reattach it by using sp_attach_db, specifying a new location for the physical log file.
 — Brian Moran


Tracking Extended Stored Procedures in Profiler
Information about the correct values to use in an Object Type filter within SQL Server Profiler is poorly documented, but here's the full list of values for Profiler filters and some advice on using them.
 — Brian Moran

---

[Editorial]

---

Grading Grid Computing
Oracle's Oracle 10g grid computing technology has its advantages--and one big disadvantage. And so far, SQL Server's clustering capabilities remain competitive.
 — Michael Otey

---

[Inside SQL Server]

---

Inside ALTER TABLE
The ALTER TABLE command can make many changes at once and still gives better performance than dropping and recreating a table. Find out how it all works.
 — Kalen Delaney

---

[Mastering Analysis]

---

Analysis Services Security and HTTP
If you’ve ever tried to connect users to Analysis Services over HTTP, you know you can’t use the default security protocol. Fortunately, Analysis Services lets you choose from three security options.
 — Russ Whitney , et al.

---

[Solutions by Design]

---

Tracking Infectious Diseases
Few medical research organizations have funds to purchase and maintain elaborate database systems for tracking diseases, so many researchers must devise their own tracking systems. For these people, an effective database design is literally a lifesaver.
 — Michelle A. Poolet

---

[T-SQL Black Belt]

---

Take Control of Joins
Sometimes, the table order you specify doesn't affect the order in which SQL Server processes joins or the query result. But here are two techniques you can use to control the order while keeping your code simple.
 — Itzik Ben-Gan

---

[Letters]

---

Letters, January 2004
In response to Michael Otey's December 2003 editorial, "The Threat from Below," one reader agrees that Microsoft is leaving small business behind and another reader suggests that small businesses use MSDE.
 — Various Authors

---

[New Products]

---

New Products, January 2004
Check out the latest SQL Server-related new and improved products.
 — Dawn Cyr

---

[SELECT TOP(X)]

---

DBCC Commands
The DBCC command has powerful documented functions and a lot of undocumented capabilities that you might not know about. Here are seven undocumented DBCC commands that can give you a peek at what’s going on inside your SQL Server system.
 — Michael Otey

---

[Preparing for SQL Server 2005]

---

SMO Replaces SQL-DMO
One of the most exciting new technologies in SQL Server Yukon provides a programmatic access layer that lets database administrators and developers work directly with database objects in any Microsoft .NET language.
 — Eric Brown