SQL Server Magazine

		Options
Data Warehousing Get ready to assimilate the OLAP concept by studying data warehousing tools and solutions, including OLAP Services in SQL Server 7.0. We'll also show you how to use SQL Server 6.5 to slice and dice data for decision support. And we'll show you how to use Data Transformation Services in SQL Server 7.0 to overcome troublesome warehousing tasks.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

OLAP: Resistance Is Futile!

Get ready for the OLAP wave by studying data warehousing tools and solutions. OLAP Services in Microsoft SQL Server 7.0 provides a rich tool set for building data warehouses that support decisions to optimize business processes.
By Bob Pfeiff 

SQL Server 6.5 Cube & Rollup

Although SQL Server 7.0's OLAP Services represents a significant leap in decision support, you can use the CUBE and ROLLUP operations to slice and dice data in SQL Server 6.5.
By Kalen Delaney 

Using DTS to Populate a Data Warehouse

Learn how DTS attacks two troublesome warehousing tasks, data acquisition and data transformation, and how easily you can use the DTS Package Designer to script a package.
By Don Awalt  , et al.

Using SQL Server 6.5 for Application Control

With a basic understanding of how SQL Server stores permission information within the sysprotects table, you can construct nearly any type of application control.
By Michael P. Deignan 

Who's Afraid of the Big, Bad BLOB?

Learn how SQL Server and ADO handle the BLOBs that spice up your database applications by adding graphics and sounds.
By Michael Otey 

SQL by Design: How to Choose a Primary Key

Good database design starts with the right primary key.
By Michelle A. Poolet 

T-SQL for Starters: Writing Simple Select Statements

Use simple T-SQL queries to get the information you want from a database.
By Michael D. Reilly 

Trends & Insights: Drucker and Database Management

If you probe the similarities between modern factories and information production systems, you'll discover ways to leverage high-powered data products.
By Karen Watterson 

SQL Insider: Hit the Books

Here are must-reads for database aficionados, sizers for SQL Server, and a resource kit update.
By Hugh Willoughby-Davis 

The Oracle Challenge

Oracle offers $1 million to anyone, Microsoft employees included, who can show that SQL Server 7.0 is not 100 times slower than Oracle when performing one specific TPC-D benchmark.
By Michael Otey 

Compression, Log Files, and More

Answers from Microsoft
By Richard Waymire 

T-SQL Control-Flow Statements

A look at seven control-flow statements that you can use in SQL Server's T-SQL batches and stored procedures.
By Michael Otey 

The New Space Management

Change in space management conventions from SQL Server 6.5 to SQL Server 7.0 is significant for DBAs who create and manage database space. By understanding SQL Server's space management protocol, you can create and maintain high-performing databases.
By Kalen Delaney 

The Amazing English Query Tool

SQL Server 7.0's English Query tool lets your Web site's visitors use a simple English phrase to find any information in the database.
By Ken Miller 

Using Data Commands

Use the data commands in this article as an example to create database objects and reuse them in your code for robust, easy-to-maintain applications.
By Ken Spencer 

Getting to Know OLAP and MDX

Learn the definition of MDX and basic OLAP concepts and terminology.
By Brian Moran  , et al.