SQL Server Magazine

		Options
OLAP and Data Warehousing OLAP tools will prove indispensable for organizations that want to turn corporate data into meaningful information. Here's an overview of the OLAP industry and a guide to data warehouse-building basics.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

7 Steps to Data Warehousing

Data warehouse systems provide decision-makers with consolidated, consistent historical data about an organization's activities. With careful planning, the system can provide vital information on how factors interrelate to help or harm the organization.
By Mark D. Scott  , et al.

Data Warehousing Step by Step

To build a successful data warehouse system, you need to understand what questions the decision-makers will ask and implement the self-service data analysis concept.
By Brian Moran 

Data Warehousing: Back to Basics

Careful planning can make your data warehouse a success. Use these tips and tricks for planning a successful data-warehousing project.
By Don Awalt  , et al.

Implementing Slowly Changing Dimensions

Changes in dimensional data have far-reaching implications in a data warehouse. Here’s how to design and maintain a data warehouse that accurately and efficiently handles slowly changing dimensions.
By Joe Luedtke 

DTS Scripts and Tricks

Put DTS through its paces by applying these common scripting patterns to package development, including invoking a package from within another package, accessing properties the Package Designer doesn't directly expose, and more.
By Don Awalt  , et al.

Inside SQL Server: System Tables

SQL Server maintains a set of tables of information about objects, data types, constraints, configuration options, and resources available to the SQL Server called the system catalog. Here's how to identify them.
By Kalen Delaney 

Mastering OLAP: Local Cube Files

Use OLAP Services, Excel 2000, and ADO MD to create a local cube slice file from an OLAP cube to work with while you’re traveling.
By Russ Whitney 

Solutions By Design: A Data Access Solution

Here are the final three steps to distribute data views to a user's desktop: creating a query file, automatically distributing that query file to every user's desktop computer, and introducing the user to this new way of accessing data on the SQL Server.
By Michelle A. Poolet 

SQL Server/Office Integration: What Is MSDE?

The Microsoft Data Engine (MSDE) makes SQL Server technology available in development contexts that were previously restricted to the Jet database engine. This new database engine is a compelling new option.
By Rick Dobson 

Web Dev: Storing Session Data in SQL Server

Look at how you can store session data in SQL Server databases to make it available through ASP.
By Ken Spencer 

Lab Reports: Db Maint 2.01

Db Maint is an easy-to-use, centralized application that automates SQL Server's management, monitors management task results, and performs other database administrative tasks.
By Denis Haskin 

Editorial: Beyond Y2K

It's over; let's get back to business as usual.
By Michael Otey 

Reader Challenge

What date is it?
By Tibor Karaszi 

Reader to Reader: Storing and Sorting IP Addresses

Store and sort IP address in a database to save disk space and speed up database queries.
By Alexey Ruban 

SQL Server Q & A

Answers from Microsoft
By Richard Waymire 

SQL Server Seven: SQL Server Web Resources

Seven great SQL Server Web resources
By Michael Otey