By Russ Whitney, 11/01/1999
How can you write a Multidimensional Expression (MDX) query that returns the Unit Sales for the months of 1997 on columns and the top product brand names that account for 25 ...
By Michelle A. Poolet, 11/01/1999
Proper use of the four integrities--entity integrity, referential integrity, domain integrity, and business integrity--can ensure that your databases' content is accurate and ...
By Dino Esposito, 11/01/1999
ODBC and OLE DB offer developers different advantages. Here's how to choose the right technology for your environment.
By Jeffrey Rogers, 11/01/1999
Here's how to deal with a common replication gotcha--verifying the subscriber's data.
By Ted Daley, 11/01/1999
Replication is built directly into SQL Server 7.0 and SQL Server Enterprise Manager; it isn't an add-on.
By Michael Otey, 11/01/1999
On August 23, Compaq announced that it was dropping Alpha support for the current 32-bit version of Windows NT, and that Linux and Open VMS would become the main OS for the Alpha.
By Richard Waymire, 11/01/1999
Answers from Microsoft about transferring data, creating a history log, replicating from 6.5 to 7.0 and more.
By Michael D. Reilly, 11/01/1999
This month, I cover a topic from the 70-28 SQL Server 7.0 Administration exam, creating and managing databases. This topic includes creating data files, filegroups, transaction ...
By Brian Knight, 11/01/1999
Extended stored procedures are a useful way to display information about files or your system. Any noninteractive program you can write in C or C++, you can write as an extended ...
By Russ Whitney, 11/01/1999
This month we take MDX a step further and introduce ADO MD, a set of multidimensional extensions to ADO.
By Michael D. Reilly, 11/01/1999
The answers to last month's questions on building tables.
By Ted Daley, 11/01/1999
Distributed data environments present a constant challenge. We'll show you how to configure merge replication to meet your environment's needs.
By Brian Knight, 11/01/1999
Creating a SQL Server Agent job
By Brian Lawton, 11/01/1999
Find out how DTS deals with errors, and you'll be on your way to building robust custom packages.
By Michael Otey, 11/01/1999
SQL Server performance depends on the interaction of many of factors. Here are seven ways you can improve SQL Server's performance.
By Tibor Karaszi, 11/01/1999
Test your SQL Server savvy with this month's reader challenge on minimizing the number of machines you need.
By Kalen Delaney, 11/01/1999
In most cases, SQL Server determines the best locking mechanism for your situation, so you can usually leave the locking decisions to SQL Server. However, in certain situations, ...
By Ken Spencer, 11/01/1999
Microsoft has increased recordsets' functionality with the addition of Extensible Markup Language (XML) features that work with ADO recordsets.
By Russ Whitney, 11/01/1999
November's MDX Puzzle
By Michael D. Reilly, 11/01/1999
Four practice questions for the SQL Server 7.0 Administration exam on creating and managing databases.
By Dan Fox, 11/01/1999
If you don't use stored procedures for data access in your ADO/SQL Server applications, you're missing out on a SQL Server feature that can improve performance, maintainability, ...