SQL Server Magazine

		Options
ADO This issue contains ADO tips and tricks to help you with database development and administration.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

6 Ways to Boost ADO Application Performance

Here’s how to troubleshoot ADO programming techniques that might be bogging down your application.
By Bob Pfeiff 

Mastering ADO

ADO is a standard set of development COM objects for most applications built with Microsoft tools and technologies. Here are some tips to help you understand and master ADO.
By Ken Spencer 

Incremental Updates in OLAP Cubes

Here’s how to incrementally update cubes–manually, programmatically, and with DTS.
By Claude Seidman 

SQL Server 7.0 Update Strategies

Find out how SQL Server 7.0 updates work and how indexes affect them.
By Kalen Delaney 

The Open Information Model

A group of vendors and end-user companies determined the types of data-warehousing meta data, resulting in the Open Information Model.
By Patrick Cross  , et al.

Using the Microsoft Repository

A repository is a storage place for meta data, or data about data. Understanding Microsoft Repository technology can help you better manage your data-warehousing environment
By Patrick Cross  , et al.

Inside SQL Server: Accessing System Tables

In last month’s column ("System Tables"), I talked about what system tables are and how they're different from user tables. Here are a few more things that are special about system tables and some recommended methods for retrieving information from them.
By Kalen Delaney 

Mastering OLAP: Using English Query with OLAP

You can use English recognition with the SQL Server English Query component to generate a Multidimensional Expression (MDX) query, and with Visual Basic (VB) you can integrate the query into OLAP applications.
By Russ Whitney 

Solutions by Design: The Security Matrix

The security decision matrix can help you develop and document your security plan.
By Michelle A. Poolet 

Web Dev: Optimizing Web Servers

Web development requires careful planning and testing to build and maintain high-performance applications. Here’s how to get your project under way.
By Ken Spencer 

Lab Reports: Replic-Action 6.01c

Replic-Action from Casahl Technologies is one of the best replication tools available because of its rich feature set and easy-to-use screens, and primarily because of what it does after you set up replication.
By Kevin Cox 

Editorial: Scalability Soars

SQL Server continues to ride the wave of scalability that grows with each new generation of hardware. The new 8-way systems based on Intel Profusion chips from various vendors continue to move SQL Server 7.0 to new peaks.
By Michael Otey 

Reader Challenge: Unencrypted Information

The winner and answer to last month's reader challenge
By Tibor Karaszi 

SQL Server Q & A

Answers from Microsoft
By Richard Waymire 

SQL Seven: BackOffice Resource Kit Tools

Michael Otey’s seven favorite SQL Server tools included in the Microsoft BackOffice Resource Kit (BORK).
By Michael Otey 

SQL/Office Integration: Using Stored Procedures with Access Projects

SQL Server developers know stored procedures as powerful tools, but Access developers switching to SQL Server with Access projects might find the syntax of and techniques for building and using stored procedures unfamiliar. Here's help.
By Rick Dobson