(David Chu) As a practitioner of the bottom-up development methodology, advocated by Ralph Kimball and my colleague Pieter Mimno, I am involved daily in the creation of enterprise data warehouse applications using an iterative bottom-up approach. However, as a “software development geek” with a long
Other News
Forming Opinions, Part 3
(Micah Dubinko) The previous two installments of XML-Deviant looked at Web Forms 2.0, or WF2, a Member Submission to the W3C. This week’s installment concludes the review of that document.
FIX: You experience delays and receive a 17883 error message when SQL Server 2000 performs a large and complex query plan that uses hash operators on a 64-bit computer
In Microsoft SQL Server 2000, when you run a large and complex query plan that uses hash operators, you may experience delays when SQL Server 2000 compiles and optimizes the plan for the query. You may also receive a 17883 error message in the SQL Server 2000 error log that is similar to the followi
The Unicode Imperative
(Barry Trute) Designing and setting up a new database system can take a lot of planning. But typically, one important decision is overlooked: choosing the right character set.
Database Manipulation with ADO.NET for beginners
(Huseyin Altindag) This is the second part of Using ADO.NET for beginners. It is a simple Personal Address Program that returns results from a database table, writes the output to textboxes, and uses buttons (First, Previous, Next, Last) to navigate through the records.
XML Features in SQL Server 2000
(John Papa) SQL Server 2000 includes several XML features that let you transform relational rowsets into hierarchical XML documents, read XML documents, and bulk load data via XML. For example, you can pass an XML document to a stored procedure, join the XML to some tables and return a rowset, or ev
IBM Express Runtime V2.1
(Aleksandr Nartovich, Sougat Ghosh, Richard Johnson, Kwang Sik Kang, Kimberly D Price, Gaetano Rinciari and Marcelino Villanueva) Mid-Market companies are looking for complete solutions from Independent Software Vendors (ISVs) who know their businesses and specialize in a particular solution categor
Finding and Fixing Bad SQL in Microsoft SQL Server 2000
This article will teach you the basic techniques used to find and fix poorly performing SQL statements (usually SELECT statements, but also INSERT, UPDATE and DELETE statements) on Microsoft’s SQL Server 2000 relational database management system. (R)
An Email Custom Class…
(John Kilgo) Virtually any code that is repeated in more than one program you write should be self-contained in one form or another. Page headers and footers, for example, are often placed in user controls so that they can be easily, and consistently, added to every page. Other code and controls oft
Using ADO.NET, XML & XSL to generate HTML – Introduction
(Bill Burris) If your website has several pages with a similar layout it can become a pain to update using an HTML editor. What is needed is a way to automate the page generation from database tables, XML, & XSL files. By separating content and page layout for you website it is much easier to update