SQL Server Magazine

		Options
SQL Server and the Web This issue explores the interaction of SQL Server and the Web. We help you untangle Microsoft .NET, manage Remote Data Services security, and build an ASP page that lets you access your database schema across the Internet.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Keep Database Schema Online

Build an ASP page that lets you access your database schema through the Internet.
By Rohit Nadhani  , et al.

Remote Data Services Security

RDS lets you choose security level for access to your data.
By Dino Esposito 

Untangling Microsoft .NET

No Microsoft application, including SQL Server, will remain untouched as the company rolls out its .NET strategy over the next several years.
By Michael Otey 

User-Defined Functions

Use SQL Server 2000 to create UDFs for greater power, readability, reusability, and performance.
By Robert Vieira 

SQLAudit 1.7

Red Matrix Technologies' auditing tool provides an easy-to-use trigger-based system for tracking inserts, updates, and deletes to your data.
By Brian Knight 

Questions, Answers, & Tips

Learn how to convert varbinary fields to hexadecimal strings, generate a list of currently executing SPIDs, and more.
By Brian Moran 

Who Needs .NET?

Does Microsoft .NET meet customers’ needs--or Microsoft’s?
By Michael Otey 

Readers' Tips and Tricks

Readers share their tips for generating a simple table description and for generating a job schedule report.
By Various Authors 

Answers from Microsoft

Richard Waymire answers readers' questions about unclustering SQL Server, measuring memory consumption, and more.
By Richard Waymire 

SQL Server 2000's Coolest Features

SQL Server 2000 is full of new functionality; here are seven of its coolest new features.
By Michael Otey 

Custom Datasheets

Learn how to use FrontPage 2000 to customize SQL Server datasheets for publication to the Web or an intranet.
By Rick Dobson 

INSTEAD OF Triggers

SQL Server 2000's new trigger type lets you check data changes before they happen.
By Kalen Delaney 

Application Partitioning

Review the fundamentals of application partitioning and component load balancing.
By Ken Spencer 

Dynamic Crosstab Queries

Dynamic crosstab queries let you produce pivoted, denormalized output from normalized data.
By Itzik Ben-Gan 

Microsoft Heads to Yukon

Although Microsoft only recently completed SQL Server 2000, the company has been working on the follow-upcode-named Yukonwhich will take SQL Server fully into the Web-enabled .NET environment.
By Paul Thurrott 

SQL Server Licensing Model to Shift

Microsoft's plans for the .NET future are still coalescing, but the company's change from shrink-wrapped software to Web-delivered services is already affecting SQL Server’s licensing model.
By Paul Thurrott 

SQL Server: Most Deployed Web Database

Zona Research recently released a study that showed SQL Server as the most used database on the Web.
By Paul Thurrott 

The Power of Calculated Cells

Calculated cells, a new Analysis Services feature, go beyond the capability and power of calculated members.
By Russ Whitney