By Michael P. Deignan, 04/01/1999
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 Ken Miller, 04/01/1999
English Query 7.0 installs Microsoft Data Access Components 2.1, which can cause problems on your devleopment machine.
By Michael D. Reilly, 04/01/1999
Use simple T-SQL queries to get the information you want from a database.
By Russ Whitney, 04/01/1999
Learn the definition of MDX and basic OLAP concepts and terminology.
By Kalen Delaney, 04/01/1999
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 Hugh Willoughby-Davis, 04/01/1999
Here are must-reads for database aficionados, sizers for SQL Server, and a resource kit update.
By Bob Pfeiff, 04/01/1999
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 ...
By Michael Otey, 04/01/1999
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 Bob Pfeiff, 04/01/1999
The PivotTable Service is the client side of Microsoft SQL Server OLAP Services. It provides the layer that lets client applications connect with SQL Server OLAP Server.
By Ken Spencer, 04/01/1999
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 Miller, 04/01/1999
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 Brian Lawton, 04/01/1999
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 Karen Watterson, 04/01/1999
If you probe the similarities between modern factories and information production systems, you'll discover ways to leverage high-powered data products.
By Richard Waymire, 04/01/1999
Answers from Microsoft
By Michael Otey, 04/01/1999
A look at seven control-flow statements that you can use in SQL Server's T-SQL batches and stored procedures.
By Ken Miller, 04/01/1999
Developers of OLAP and multidimensional databases speak their own language and use terms such as cubes, dimensions, measures, and members.
By Michelle A. Poolet, 04/01/1999
Good database design starts with the right primary key.
By Michael Otey, 04/01/1999
Learn how SQL Server and ADO handle the BLOBs that spice up your database applications by adding graphics and sounds.
By Kalen Delaney, 04/01/1999
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 ...