http://www.sqlmag.com/authors/author/author/5063540/rss/5063540en-USFri, 25 May 2012 10:41:06 GMTFri, 25 May 2012 10:41:06 GMThttp://www.sqlmag.com/article/sql-server-2000/multiple-vulnerabilities-in-microsoft-sql-server-2000-and-7-0
By Bob Pfeiff
Multiple vulnerabilities exist in Microsoft SQL Server 2000 and 7.0. ]]>Bob PfeiffThu, 10 Jan 2002 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-2000/multiple-vulnerabilities-in-microsoft-sql-server-2000-and-7-0http://www.sqlmag.com/article/dts/refreshing-the-data
By Bob Pfeiff
Part 3 of Bob Pfeiff’s "Relational to Dimensional" series shows you how to periodically refresh the data in your data mart.]]>Bob PfeiffThu, 22 Feb 2001 00:00:00 GMThttp://www.sqlmag.com/article/dts/refreshing-the-datahttp://www.sqlmag.com/article/tsql3/in-control-with-for-xml-explicit
By Bob Pfeiff
Use SQL Server 2000’s FOR XML EXPLICIT mode to produce data in XML format.]]>Bob PfeiffThu, 22 Feb 2001 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/in-control-with-for-xml-explicithttp://www.sqlmag.com/article/sql-server-70/cast-e-analyzer-3-8-beta-2
By Bob Pfeiff
CAST’s analysis tool lets you produce graphical views and reports of your application’s structure.]]>Bob PfeiffMon, 27 Nov 2000 00:00:00 GMThttp://www.sqlmag.com/article/sql-server-70/cast-e-analyzer-3-8-beta-2http://www.sqlmag.com/article/data-access/building-a-cube-from-a-dimensional-database
By Bob Pfeiff
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.]]>Bob PfeiffThu, 21 Sep 2000 00:00:00 GMThttp://www.sqlmag.com/article/data-access/building-a-cube-from-a-dimensional-databasehttp://www.sqlmag.com/article/reporting2/data-transformation-in-the-real-world
By Bob Pfeiff
In real-world data warehouse solutions that involve disparate operating systems, you almost never find relatively clean data.]]>Bob PfeiffThu, 20 Apr 2000 16:16:02 GMThttp://www.sqlmag.com/article/reporting2/data-transformation-in-the-real-worldhttp://www.sqlmag.com/article/reporting2/relational-to-dimensional
By Bob Pfeiff
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.]]>Bob PfeiffWed, 12 Apr 2000 09:06:59 GMThttp://www.sqlmag.com/article/reporting2/relational-to-dimensionalhttp://www.sqlmag.com/article/activex/the-investigative-tools
By Bob Pfeiff
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.]]>Bob PfeiffTue, 01 Feb 2000 13:04:58 GMThttp://www.sqlmag.com/article/activex/the-investigative-toolshttp://www.sqlmag.com/article/activex/6-ways-to-boost-ado-application-performance
By Bob Pfeiff
Here’s how to troubleshoot ADO programming techniques that might be bogging down your application. ]]>Bob PfeiffWed, 26 Jan 2000 08:20:08 GMThttp://www.sqlmag.com/article/activex/6-ways-to-boost-ado-application-performancehttp://www.sqlmag.com/article/performance/merge-zoneDistributed data environments present a constant challenge. We’ll show you how to configure merge replication to meet your environment’s needs.]]>Ted DaleyMon, 01 Nov 1999 00:00:00 GMThttp://www.sqlmag.com/article/performance/merge-zonehttp://www.sqlmag.com/article/data-access/behind-the-scenesReplication is built directly into SQL Server 7.0 and SQL Server Enterprise Manager; it isn’t an add-on.]]>Ted DaleyMon, 01 Nov 1999 00:00:00 GMThttp://www.sqlmag.com/article/data-access/behind-the-sceneshttp://www.sqlmag.com/article/tsql3/access-and-sql-server-interoperability
By Bob Pfeiff
A development team uses SQL Server and Access to create an interactive Web application. ]]>Bob PfeiffFri, 01 Oct 1999 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/access-and-sql-server-interoperabilityhttp://www.sqlmag.com/article/database-development/olap-resistance-is-futile-
By Bob Pfeiff
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.]]>Bob PfeiffThu, 01 Apr 1999 00:00:00 GMThttp://www.sqlmag.com/article/database-development/olap-resistance-is-futile-http://www.sqlmag.com/article/database-development/navigating-the-pivottable-service
By Bob Pfeiff
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.]]>Bob PfeiffThu, 01 Apr 1999 00:00:00 GMThttp://www.sqlmag.com/article/database-development/navigating-the-pivottable-service