SQL Server Magazine

		Options
Distributed Systems and Replication Here's how database administrators can design distributed systems to optimize performance, satisfy departmental reporting needs, and boost reliability.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Merge Zone

Distributed data environments present a constant challenge. We'll show you how to configure merge replication to meet your environment's needs.
By Bob Pfeiff  , et al.

Validating Replicated Data

Here's how to deal with a common replication gotcha--verifying the subscriber's data.
By Jeffrey Rogers 

DTS: Error Handling Revealed

Find out how DTS deals with errors, and you'll be on your way to building robust custom packages.
By Don Awalt  , et al.

OLE DB or ODBC?

ODBC and OLE DB offer developers different advantages. Here's how to choose the right technology for your environment.
By Dino Esposito 

Use ADO to Maximize Stored Procedures

If you don't use stored procedures for data access in your ADO/SQL Server applications, you're missing out on a SQL Server feature that can improve performance, maintainability, and security.
By Dan Fox 

Certifiably SQL: Creating SQL Server 7.0 Databases

This month, I cover a topic from the 70-28 SQL Server 7.0 Administration exam, creating and managing databases. This topic includes creating data files, filegroups, transaction log files, and specifying growth characteristics.
By Michael D. Reilly 

Inside SQL Server: Controlling Locking

In most cases, SQL Server determines the best locking mechanism for your situation, so you can usually leave the locking decisions to SQL Server. However, in certain situations, you might need to give SQL Server some direction.
By Kalen Delaney 

Mastering OLAP: Writing Applications with ADO MD

This month we take MDX a step further and introduce ADO MD, a set of multidimensional extensions to ADO.
By Brian Moran  , et al.

SQL By Design: The Four Integrities

Proper use of the four integrities--entity integrity, referential integrity, domain integrity, and business integrity--can ensure that your databases' content is accurate and consistent.
By Michelle A. Poolet 

VB Toolkit: Saving and Restoring Recordsets

Microsoft has increased recordsets' functionality with the addition of Extensible Markup Language (XML) features that work with ADO recordsets.
By Ken Spencer 

Editorial: From Alpha to Omega

On August 23, Compaq announced that it was dropping Alpha support for the current 32-bit version of Windows NT, and that Linux and Open VMS would become the main OS for the Alpha.
By Michael Otey 

Reader Challenge: Cutting Down on Servers

Test your SQL Server savvy with this month's reader challenge on minimizing the number of machines you need.
By Tibor Karaszi 

Reader to Reader: Undocumented Stored Procedures

Extended stored procedures are a useful way to display information about files or your system. Any noninteractive program you can write in C or C++, you can write as an extended stored procedure as long as it's compiled as a DLL file.
By Brian Knight 

SQL Server Q & A

Answers from Microsoft about transferring data, creating a history log, replicating from 6.5 to 7.0 and more.
By Richard Waymire 

SQL Seven: Performance Tuning Tips

SQL Server performance depends on the interaction of many of factors. Here are seven ways you can improve SQL Server's performance.
By Michael Otey