---

[Focus]

---

Custom Replication
Using T-SQL to develop custom stored procedures for copying data gives you maximum flexibility in a method that combines features of snapshot and transactional replication.
 — John D. Lambert


Two-Way Replication with SQL Server 7.0
With SQL Server 7.0's immediate-updating subscription feature, not only can you can replicate changes from a Publisher to Subscribers, but you can replicate changes on the Subscribers back to the Publisher.
 — Baya Pavliashvili

---

[Features]

---

Build a Better Search Engine
Implement SQL Server 7.0’s full-text search capabilities to avoid time-consuming table scans, enable advanced pattern matching, and deliver quick results in high-performance, robust corporate applications and Web sites.
 — David Jones


Maintaining Hierarchies
SQL Server doesn't inherently support hierarchies, such as those between employees and managers, but you can add columns to your database tables to hold hierarchical information, then use triggers and T-SQL queries to manage that data.
 — Itzik Ben-Gan


Referential Integrity in SQL Server
Learn how to use SQL Server 2000's new methods of enforcing referential integrity in your databases.
 — Kalen Delaney

---

[SQL Server Savvy]

---

Questions, Answers, and Tips
Read about SQL Server 2000's new cascading Declarative Referential Integrity support, how to change default client-side Netlib settings when you don't have the SQL Server Client Configuration Utility installed, and more.
 — Brian Moran

---

[Editorial]

---

Scaling Up vs. Scaling Out
Scaling out might be a viable solution for database implementations that have reached the limits of SMP scalability.
 — Michael Otey

---

[Reader to Reader]

---

Readers' Tips and Tricks
Readers share their tips for finding and inserting missing records, for using cursors to perform operations on multiple objects, for expanding the Databases node in Enterprise Manager, and more.
 — Various Authors

---

[SQL Server Q&A]

---

Answers from Microsoft
A Microsoft program manager answers your SQL Server questions.
 — Richard Waymire

---

[SQL Seven]

---

SQL Server White Papers
Michael Otey lists his favorite SQL Server white papers, all of which you can find on Microsoft’s Web site.
 — Michael Otey

---

[SQL Server/Office Integration]

---

Programming SQL-DMO from Access
Learn how to build a custom application with Access projects and SQL Distributed Management Objects (SQL-DMO).
 — Rick Dobson

---

[Inside SQL Server]

---

Multiple Instances
SQL Server 2000 brings you the long-awaited capability to run multiple SQL Server installations on one machine.
 — Kalen Delaney

---

[Web Dev]

---

Introducing Queued Components
A new feature of COM+—queued components—offers benefits to developers of Web applications on the SQL Server platform.
 — Ken Spencer

---

[Solutions by Design]

---

Logical Modeling
Working from the concept model, take the next step in database design and manually create a logical model of your database.
 — Michelle A. Poolet

---

[T-SQL Black Belt]

---

Using Joins to Modify Data
In the debut T-SQL Black Belt article, SQL Server MVP Itzik Ben-Gan demonstrates how you can use joins and subqueries to modify a table based on data in another table.
 — Itzik Ben-Gan

---

[Mastering OLAP]

---

Analysis Services Actions
A new Analysis Services feature, called actions, can link structured or unstructured data or commands to almost any part of an OLAP cube.
 — Russ Whitney