---

[Focus]

---

Building a Web-Based Search Tool
Here's how you can build a simple but powerful Web search tool for your data warehouse or database.



Building Interactive Web Applications
The fastest, easiest way to create a Web application is to use IIS, ASP, ADO, and SOM. Then add Visual InterDev as the development tool, and you have a powerful set of technologies to build a stunning Web application.
 — Ken Spencer


The ABCs of ADO and ASP
Active Server Pages (ASP) provides server-side scripting for Internet Information Server (IIS) Web servers. Use ASP, which supports any scripting language that follows the ActiveX Scripting standard, to create flexible and dynamic Web pages.
 — Michael Otey

---

[Features]

---

Constructing DTS Custom Tasks
We explain how to use custom packages to leverage the DTS object model further by examining custom tasks, what they are, and why you might use them. We then detail how to build a custom task and how to use it both graphically and programmatically.
 — Don Awalt , et al.


How ADO Uses Cursors
ADO uses cursors as a storage and access mechanism. Here's how to choose the best cursor for your application.
 — Morris Lewis

---

[Columns]

---

Inside SQL Server: SQL Server 7.0 Plan Caching
SQL Server's ability to reuse compiled plans for stored procedures has been a most heavily marketed feature since its first release. But from a performance standpoint, compiled plan reuse wasn't the most important reason for stored procedure use.
 — Kalen Delaney


Mastering OLAP: Multiple Hierarchies per Dimension
This month we discuss the implementation and use of multiple hierarchies in SQL Server 7.0 OLAP Services. Multiple hierarchies let you organize the same dimension of an OLAP cube in different ways.
 — Brian Moran , et al.


SQL By Design: Views and Stored Procedures
Occasionally, when you're designing a database schema, you need to go to fifth normal form (5NF). For situations that require a 5NF database, you can minimize the performance impact of multitable joins by creating views of your data.
 — Michelle A. Poolet


T-SQL For Starters: Creating SQL Server 6.5 Databases
Several steps are necessary before you can create SQL Server tables. This month, I look at another building block: creating the databases (and in SQL Server 6.5, the devices) to hold the tables.
 — Michael D. Reilly


Trends & Insights: Shiloh Mounts an Offensive
For Microsoft BackOffice and SQL Server users, Shiloh means the next major release of SQL Server.
 — Karen Watterson


VB Toolkit: Tweaking ADO for Performance
Let's talk about how to use ADO to create a high-performance application for the Internet or an intranet.
 — Ken Spencer

---

[Departments]

---

Editorial
Service Pack 1 contains some notable enhancements: OLAP Services now supports cell-level locking and Microsoft reverted cursor rollback behavior to how it was in SQL Server 6.5.
 — Michael Otey


Reader to Reader
Will SQL Server Go Corporate? A popular perception is that SQL Server is only a Windows NT solution--in other words, small-scale.
 — Marc Jones


SQL Server Q & A
Microsoft Answers Your Questions.
 — Richard Waymire


SQL Seven
SQL Server's seven network libraries (Net-Libraries) provide the communications connection between client applications and the server.
 — Michael Otey