SQL Server Magazine

		Options
Web Development Make the connection between SQL Server data and the Web! In this issue, we cover design and implementation issues involved in using the Web to retrieve, analyze, and report on data, including tips on security.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

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.
By

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.
By 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.
By Michael Otey 

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.
By 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.
By Morris Lewis 

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.
By 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.
By 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.
By 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.
By 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.
By 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.
By Ken Spencer 

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.
By 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.
By Marc Jones 

SQL Server Q & A

Microsoft Answers Your Questions.
By Richard Waymire 

SQL Seven

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