SQL Server Magazine

		Options
Replication: Synchronize Databases on Demand This issue shows you how to synchronize selected data on the fly--without disrupting business, how to use a trigger-based solution to avoid stale data in your Web application cache, how to use XMLA to build flexible analytic applications, and more!		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Synchronizing on Demand

Transactional replication helps maintain data availability, but if data becomes unsynchronized, you might not be able to quickly synchronize by using conventional techniques. You can synchronize selected data on the fly--without disrupting business.
By Gary Zaika 

Fast Cache, Fresh Data

To avoid stale data in your Web applications' cache, try this trigger-based solution.
By Tim McCarthy 

XML for Analysis: Marrying OLAP and Web Services

Learn to use XML for Analysis to build an analytic application for any device, language, or platform that supports XML.
By Rob Ericsson 

Foreign Key Constraints (Without NOCHECK) Boost Performance and Data Integrity

Here are two examples of using foreign key constraints to improve performance.
By Brian Moran 

Stopping a Stubborn Trace

Learn how to disable C2 auditing to stop a constant SQL Server Profiler trace.
By Brian Moran 

XP SP2 and SQL Server

The question for SQL Server customers isn't whether to apply Windows XP SP2 but how to do so effectively.
By Michael Otey 

Get Into Index Structures

Grab your tools and get at the root of indexes' b-tree structure. The information you find can help you make your queries faster than ever.
By Kalen Delaney 

Design Testing with Questions and Views

Short timelines and limited budgets often force designers to forgo formal design testing. But you can use this question-and-view technique to integrate testing during your design creation.
By Michelle A. Poolet 

Accumulating Aggregations

These five examples show you how to query aggregated data over time.
By Itzik Ben-Gan 

New Products, November 2004

Check out new and improved SQL Server-related products.
By Dawn Cyr 

SQL Server 2005 Express

The newest MSDE debuts as SQL Server 2005 Express--a free, powerful, relational database engine. Here are SQL Server 2005 Express's six best new features.
By Michael Otey 

Archiving User Activity

Microsoft's Patrick Conlan shares the best way to retrieve data from an active archive database and an inactive archive database.
By Microsoft's SQL Server Development Team 

Changing a Column's Data Type

Microsoft's Patrick Conlan describes how to change a column's data type from numeric to float with the least impact on data availability.
By Microsoft's SQL Server Development Team 

Explaining UserOrAlias Values

Microsoft's Gert Drapers tells readers what the UserOrAlias column's values mean.
By Microsoft's SQL Server Development Team 

Identifying a Database's Files, Filegroups

Microsoft's Richard Waymire explains how to use sp_helpdb to identify files and filegroups.
By Microsoft's SQL Server Development Team