By Bob Pfeiff, 01/10/2002
Multiple vulnerabilities exist in Microsoft SQL Server 2000 and 7.0.
By Bob Pfeiff, 02/22/2001
Part 3 of Bob Pfeiff's "Relational to Dimensional" series shows you how to periodically refresh the data in your data mart.
By Bob Pfeiff, 02/22/2001
Use SQL Server 2000’s FOR XML EXPLICIT mode to produce data in XML format.
By Bob Pfeiff, 11/27/2000
CAST’s analysis tool lets you produce graphical views and reports of your application’s structure.
By Bob Pfeiff, 09/21/2000
In a follow-up to his June 2000 article "Relational to Dimensional," the author shows you how to extend a dimensional data mart with preaggregated dimensions and a user-friendly ...
By Bob Pfeiff, 04/20/2000
In real-world data warehouse solutions that involve disparate operating systems, you almost never find relatively clean data.
By Bob Pfeiff, 04/12/2000
This simple data mart solution demonstrates an effective way to pull operational data into a dimensional database so that decision makers can quickly and easily access business ...
By Bob Pfeiff, 02/01/2000
Whether you're a developer or a DBA, you need to become good friends with SQL Trace in SQL Server 6.5 or SQL Profiler in SQL Server 7.0.
By Bob Pfeiff, 01/26/2000
Here’s how to troubleshoot ADO programming techniques that might be bogging down your
application.
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 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 Bob Pfeiff, 10/01/1999
A development team uses SQL Server and Access to create an interactive Web application.
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 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.