---

[Focus]

---

Building a Web-Based Analysis System
Follow the choices that one development team made to create a secure Web-based analysis system.
 — Mark Scott , et al.


Data Mining on a Shoestring
Did you know that your database can tell you how to increase your revenue and build customer loyalty? With Analysis Services, mining your data for gold is easy.
 — Frances Keeping

---

[Features]

---

Stay in Control
Keep your complex software-development projects in check by building a version-control system that uses Enterprise Manager and Visual SourceSafe.
 — Wayne Kurtz , et al.

---

[SQL Server Savvy]

---

Counting Lines in a File
Learn how to calculate the number of lines in a bulk copy data file.
 — Brian Moran


How to Influence Microsoft
Learn how to provide feeback to the SQL Server development team in a forum that it responds to: sqlwish@microsoft.com.
 — Brian Moran


Pasting DDL in SQL Server 2000
Discover what the Paste command actually does in SQL Server 2000.
 — Brian Moran


Tip: When Is Real Not Real?
Learn about the pitfalls of using the approximate data types float and real.
 — Brian Moran

---

[Editorial]

---

The Data Is Job One
Solving problems, learning about new technology, or writing stored procedures to address user requests might be more fun, but ensuring database consistency and recoverability comes first.
 — Michael Otey

---

[Reader to Reader]

---

Refresh Database Objects
A reader shares a tip for solving the problems that crop up when a view's objects change.
 — Readers

---

[SQL Seven]

---

SQL Server in the Fast Lane
Here are seven facts that reveal why SQL Server’s market share is increasing so quickly.
 — Michael Otey

---

[Inside SQL Server]

---

Tune In to Data Modification
Knowing what happens under the data-modification covers can help you tune your indexes for your most frequent operations.
 — Kalen Delaney

---

[Mastering Analysis]

---

Tracking Time
Track the time employees spend working on projects.
 — Russ Whitney

---

[Solutions by Design]

---

Simple Inventory Metamodel
The who, what, when, where, and how of inventory control can quickly get out of hand. Take charge by applying this metamodel for basic inventory management.
 — Michelle A. Poolet

---

[T-SQL Black Belt]

---

The Shape of T-SQL
Next time someone tells you to think outside the box, try this rectangular technique.
 — Itzik Ben-Gan

---

[Answers from Microsoft]

---

Backing Up Transaction-Log Records
Microsoft’s SQL Server development team explains why you should set up your databases to retain transaction-log records.
 — Microsoft's SQL Server Development Team


Changes in Enterprise Manager and Query Analyzer
Microsoft’s SQL Server development team gives examples of the changes SQL Server users should be aware of when upgrading their systems from SQL Server 7.0 to 2000.
 — Microsoft's SQL Server Development Team


Inserting Data When the Column Name Is a Variable
Microsoft’s SQL Server development team provides code that shows how to get around the T-SQL INSERT command’s lack of support for a variable argument.
 — Microsoft's SQL Server Development Team


Log-File Growth and DBCC DBREINDEX
Microsoft’s SQL Server development team explains why a log-file backup is huge after large tables are reindexed.
 — Microsoft's SQL Server Development Team


Ownership Changes in SQL Server 7.0's Merge Replication
Microsoft’s SQL Server development team explains why ownership changes when you’re using SQL Server 7.0’s merge replication utility and why it doesn’t change in SQL Server 2000.
 — Microsoft's SQL Server Development Team


Returning a Trigger's Results to a Stored Procedure
Microsoft’s SQL Server development team provides statements that return a trigger’s single and multiple results.
 — Microsoft's SQL Server Development Team

---

[Exploring XML]

---

Creating a Web Service
Web services is the hot new topic for the Internet. Find out how to use them to access your SQL Server databases.
 — Rich Rollman

---

[Letters]

---

Letters, June 2002
Readers write in about using realistic data in testing, handling data-flow design, using Profiler to see how SQL Server tools work, and more.
 — Various Authors

---

[New Products]

---

New Products, June 2002
Check out these new and enhanced products.
 — Carolyn Mader