The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Russ Whitney
November's MDX Puzzle.
By Itzik Ben-Gan
Dynamic crosstab queries let you produce pivoted, denormalized output from normalized data.
Here's the solution to the October MDX puzzle.
By Brian Knight
Red Matrix Technologies' auditing tool provides an easy-to-use trigger-based system for tracking inserts, updates, and deletes to your data.
Calculated cells, a new Analysis Services feature, go beyond the capability and power of calculated members.
By Richard Waymire
Richard Waymire answers readers' questions about unclustering SQL Server, measuring memory consumption, and more.
By Brian Moran
A new SQL Server 2000 function called fn_virtualfilestats lets you track I/O statistics from the SQL Server 2000 version of T-SQL without relying on the Windows 2000 or Windows NT Performance Monitor.
By Ken Spencer
Review the fundamentals of application partitioning and component load balancing.
By Paul Thurrott
Although Microsoft only recently completed SQL Server 2000, the company has been working on the follow-upcode-named Yukonwhich will take SQL Server fully into the Web-enabled .NET environment.
By
Readers share their tips for generating a simple table description and for generating a job schedule report.
By Dino Esposito
RDS lets you choose security level for access to your data.
By Michael Otey
Does Microsoft .NET meet customers’ needs--or Microsoft’s?
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 Vikash K. Agarwal
Build an ASP page that lets you access your database schema through the Internet.
Zona Research recently released a study that showed SQL Server as the most used database on the Web.
By Kalen Delaney
SQL Server 2000's new trigger type lets you check data changes before they happen.
By Robert Vieira
Use SQL Server 2000 to create UDFs for greater power, readability, reusability, and performance.
Microsoft's new C# language combines Visual Basic's ease of use with Visual C++'s power and flexibility.
By Rick Dobson
Learn how to use FrontPage 2000 to customize SQL Server datasheets for publication to the Web or an intranet.
No Microsoft application, including SQL Server, will remain untouched as the company rolls out its .NET strategy over the next several years.
The Microsoft Data Access Components software development kit (SDK) comes with the source code of the default handler, MSDFMAP.Handler. You can use this code as a reference for implementing new handlers.
Before authorizing a Remote Data Services (RDS) handler-based operation, the server needs to check the credentials of the currently connected user.
Learn how to convert varbinary fields to hexadecimal strings, generate a list of currently executing SPIDs, and more.
SQL Server 2000 is full of new functionality; here are seven of its coolest new features.
advertisement