---

[Focus]

---

DTS on the Move
Optimum portability is one of the most important goals in creating a Data Transformation Services package that can execute properly on virtually any server.
 — Shane Dovers

---

[Features]

---

How Many's Too Many?
Now that you’re comfortable with many-to-many (M:N) relationships, don’t get complacent. Your database performance can often benefit from taking a relationship in a new direction--for example, by implementing the underused supertype-subtype model.
 — Jeffrey Bane

---

[SQL Server Savvy]

---

Finding the CD Key
Looking for an installed SQL Server's CD key from the Windows registry? Here are some ways to find it...
 — Brian Moran


Hyper-Threading Adds Logical CPUs
Certain Intel processors have a new feature called Hyper-Threading. The feature essentially makes one processor look like two to the OS.
 — Brian Moran


Hyper-Threading and SQL Server's Affinity Mask Option
If you use the affinity mask option on a machine that uses Hyper-Threading technology, you might get unanticipated behavior.
 — Brian Moran


Obscure Query Analyzer Option
Query Analyzer is packed with features that many people haven't experimented with. Here's an obscure capability that lets you set a variety of configuration options, save them to a configuration file, then start Query Analyzer using that file.
 — Brian Moran


Sending Mail from SQL Server
Looking for an alternative to Microsoft Outlook when sending mail from SQL Server? Check out XPSMTP.
 — Brian Moran

---

[Editorial]

---

Install Those Service Packs!
You might not need the new functionality a service pack provides, but prompt installation of service packs could be the very thing that beats virus writers to the punch.
 — Michael Otey

---

[SQL Seven]

---

ADO.NET Don'ts
Knowing what not to do is important because violating these precautions can ruin your ADO.NET application's performance or compromise the security of your SQL Server system.
 — Michael Otey

---

[Inside SQL Server]

---

Inside Recovery Models
Tips about testing and choosing the right recovery model for your system.
 — Kalen Delaney

---

[Mastering Analysis]

---

Data Discovery
When you're choosing between relational reporting and OLAP for data analysis, remember that the two tools are different. Relational reporting can provide solid data for decision makers, but OLAP addresses the human side of the equation.
 — Russ Whitney

---

[T-SQL Black Belt]

---

Set Members and Relationships
You can use Set Theory to identify groups of items that have a certain relationship to other items.
 — Itzik Ben-Gan

---

[Answers from Microsoft]

---

Full-Text Search Basics
Microsoft provides answers about the capabilities of SQL Server 2000's full-text search component.
 — Microsoft's SQL Server Development Team


Generating Scripts for SQL Server Jobs
SQL-DMO gives you a way to list jobs running on SQL Server and obtain their scripts.
 — Microsoft's SQL Server Development Team


Tracking Index Usage
Use SQL Server Profiler to determine which indexes you need to keep on your tables.
 — Microsoft's SQL Server Development Team

---

[Exploring XML]

---

On the Edge
Edge tables can help you find data that's hidden in XML open content.
 — Rich Rollman

---

[Letters]

---

Letters, June 2003
Readers write in about quickly installing service packs, frustrations over authentication modes, using 32-bit tools to migrate to 64-bit SQL Server, and much more!
 — Various Authors

---

[New Products]

---

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