(Dwaine R. Snow) Over the past couple years there has been a great deal of hype and interest in the concept of the data warehouse appliance. Much of this hype has been about the advantages the appliance is supposed to bring to organizations trying to balance the demands for ever increasing data alon
Other News
Configuring ClearQuest to use DB2 as your back-end RDBMS
(Forrest Xia) IBM DB2 is a comprehensive RDBMS product, which IBM Rational ClearQuest fully supports. This article provides a step-by-step configuration guide to give you a clear picture regarding how to configure DB2 as your ClearQuest back-end RDBMS.
Ten Managed Application Pitfalls that Kill Version Compatibility
(John Mueller) In days gone by, developers would cringe every time Microsoft released a new version of any product. Applications would commonly stop working or, worse yet, they would exhibit some very odd behaviors due to changes in runtime libraries.
An Examination of Visual Basic’s Random Number Generation
(Mark Hutchinson) While training and mentoring a new user with a Microsoft Access application I’d written for the client, a quite unexpected condition occurred in my application. This would normally be the kind of condition that prompts me to find an error I’d introduced and not trapped. However, th
REXML: Processing XML in Ruby
(Koen Vervloesem) REXML (Ruby Electric XML) is the XML processor of choice for Ruby programmers. It comes bundled with the standard Ruby distribution. It’s fast, written in Ruby, and can be used in two ways: tree parsing and stream parsing. In this article, we show some basic constructs on how to us
SQL Server freebie: TOAD for SQL Server
(Serdar Yegulalp) Most SQL Server development is done using SQL Server Enterprise Manager or Query Analyzer. The former provides a nice, hierarchical view of the entire server and its attendant database objects, but has many limitations. The latter provides the power of a command line, but is strict
Customizing XML Serialization in .NET 2.0 Using the IXmlSerializable Interface
(Thiru Thangarathinam) In .NET 2.0, Microsoft has exposed the methods of the IXmlSerializable interface, giving you far more control over the way your objects get serialized to XML than in previous versions. Implementing IXmlSerializable in your own classes gives you explicit control over the XML sc
FIX: You may receive the ‘Server Msg 8630, Level 17, State 34, Procedure , Line nn’ error message when you try to delete records from a table in SQL Server 2000
In Microsoft SQL Server 2000 with Service Pack 4 (SP4), a query that generates a very large query plan may not run. For example, the query may not run when you use the DELETE Transact-SQL statement and you try to delete records from a table that has FOREIGN KEY constraints on many tables. When this
Feature Pack for Microsoft SQL Server 2005 – November 2005
The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: –Latest versions of redistributable components for SQL Server 2005 –Latest versions of add-on providers for SQL Server 2005 –Latest versions of backward compatibi
Master the basic building blocks of an SQL database query
(Alan Beaulieus) Learn how queries are executed by the MySQL server, and then take a closer look at the select statement and how its parts interact. (pdf)