SQL Server Magazine

		Options
XML The September issue is your launch pad to Extensible Markup Language (XML), an essential technology that database developers and DBAs need to understand and use to compete in the e-commerce market.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

The XML Files

Which XML features are in SQL Server 2000 and not in Microsoft's XML technology preview--and vice versa? This article guides you through the versions' different XML implementations.
By Bob Beauchemin 

Extend SQL Server with COM Automation

Use SQL Server’s built-in COM automation environment to automate COM objects from within stored procedures and integrate SQL Server with other systems.
By James T. Stanley 

Optimizing Cube Performance with OLAP Services

Results from an OLAP cube performance study reveal steps you can take to optimize the performance of multidimensional databases.
By Rajiv Tewari 

Querying Distributed Partitioned Views

In the second article of a three-part series, the authors show you how to query distributed partitioned views in SQL Server 2000.
By Kalen Delaney  , et al.

ER/Studio 4.02a

Armed with a new interface and other enhancements, Embarcadero's data modeling tool is poised to go head-to-head with market leader PLATINUM ERwin/ERX.
By Ron Talmage 

Questions, Answers, and Tips

Learn about translating image data types to integers, configuring services to be dependent on SQL Server, determining the fastest way to load data, and starting column names with numbers.
By Brian Moran 

Scalability Wars

Shared-nothing clustering pushes SQL Server 2000 over the top.
By Michael Otey 

Readers' Tips and Tricks

A reader shares his tip for using Excel's SQL.REQUEST function.
By Various Authors 

Answers from Microsoft

Richard Waymire answers questions about comparing grid and text mode performance, determining SQL Server memory usage, and more.
By Richard Waymire 

SQL Server Knowledge Base Articles

Senior technical editor Michael Otey highlights seven recent Knowledge Base articles about SQL Server.
By Michael Otey 

Filtering Data with Access Forms

The author demonstrates two approaches to programming custom filters for the SQL Server Pubs database with Access forms.
By Rick Dobson 

Solving the Datetime Mystery

Kalen Delaney sheds light on the most misunderstood data type.
By Kalen Delaney 

Analysis Services Data Mining

Russ Whitney demystifies the data-mining features of Analysis Services.
By Russ Whitney 

The Physical Implementation

This last installment in Michelle A. Poolet's data-modeling series defines seven steps for bringing your database to life.
By Michelle A. Poolet 

Short Circuit

You can rewrite logical expressions to leverage the short circuit feature, which saves CPU cycles and prevents runtime errors.
By Itzik Ben-Gan 

Oracle Gets Caught in Garbagegate

Oracle took some heat this summer after hiring a private detective agency to dig up dirt about Microsoft during the Microsoft antitrust trial.
By Paul Thurrott 

TPC Overturns SQL Server Benchmark Record

The Transaction Processing Performance Council (TPC) has overturned the TPC-C and TPM-C benchmark records that SQL Server 2000 set in February 2000, citing a noncompliance issue that Microsoft rival Oracle discovered.
By Paul Thurrott