Bob Pfeiff
   


Bob Pfeiff is a database specialist with experience in data warehousing, business-to-business e-commerce, Web solutions, and application performance tuning. He is an MCDBA, an MCSD, an MCSE, an MCT, and a SQL Server MVP.
Email address: rpfeiff@microsoft.com

14 results found for Bob Pfeiff, displaying items 1 - 14
January 10, 2002

Multiple Vulnerabilities in Microsoft SQL Server 2000 and 7.0

Multiple vulnerabilities exist in Microsoft SQL Server 2000 and 7.0.

WinInfo

March 2001

Refreshing the Data This article is only available to subscribers. Sign up now and get instant access!

Part 3 of Bob Pfeiff's "Relational to Dimensional" series shows you how to periodically refresh the data in your data mart.

SQL Server Magazine

March 2001

In Control with FOR XML EXPLICIT This article is only available to subscribers. Sign up now and get instant access!

Use SQL Server 2000’s FOR XML EXPLICIT mode to produce data in XML format.

SQL Server Magazine

December 2000

CAST e-Analyzer 3.8 Beta 2 This article is only available to subscribers. Sign up now and get instant access!

CAST’s analysis tool lets you produce graphical views and reports of your application’s structure.

SQL Server Magazine

October 2000

Building a Cube from a Dimensional Database This article is only available to subscribers. Sign up now and get instant access!

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 interface.

SQL Server Magazine

June 2000

Data Transformation in the Real World This article is only available to subscribers. Sign up now and get instant access!

In real-world data warehouse solutions that involve disparate operating systems, you almost never find relatively clean data.

SQL Server Magazine

June 2000

Relational to Dimensional This article is only available to subscribers. Sign up now and get instant access!

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 information.

SQL Server Magazine

March 2000

The Investigative Tools This article is only available to subscribers. Sign up now and get instant access!

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.

SQL Server Magazine

March 2000

6 Ways to Boost ADO Application Performance This article is only available to subscribers. Sign up now and get instant access!

Here’s how to troubleshoot ADO programming techniques that might be bogging down your application.

SQL Server Magazine

November 1999

Merge Zone This article is only available to subscribers. Sign up now and get instant access!

Distributed data environments present a constant challenge. We'll show you how to configure merge replication to meet your environment's needs.

SQL Server Magazine

November 1999

Behind the Scenes This article is only available to subscribers. Sign up now and get instant access!

Replication is built directly into SQL Server 7.0 and SQL Server Enterprise Manager; it isn't an add-on.

SQL Server Magazine

October 1999

Access and SQL Server Interoperability This article is only available to subscribers. Sign up now and get instant access!

A development team uses SQL Server and Access to create an interactive Web application.

SQL Server Magazine

April 1999

OLAP: Resistance Is Futile! This article is only available to subscribers. Sign up now and get instant access!

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.

SQL Server Magazine

April 1999

Navigating the PivotTable Service This article is only available to subscribers. Sign up now and get instant access!

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.

SQL Server Magazine

Add these Headlines to your Website