(Sérgio Fontes) Structured Query Language (SQL) is the most widely used commercial relational database language. It was developed by IBM and the current ANSI/ISO standard is called SQL: 1999.
Other News
Compression Classes Enhance I/O in .NET 2.0
(Mark Strawmyer) One of my previous articles, “Accessing Files and Directories,” covered how to get file and directory properties in the 1.0 and 1.1 versions of the .NET Framework. This article serves as a sequel of sorts, focusing on the I/O enhancements in the .NET Framework 2.0 release due out la
Understanding $_SERVER[’PHP_SELF’], $PHP_SELF, $_SERVER[’REQUEST_URI’] and $_SERVER[’SCRIPT_NAME’] in PHP and when to use what
(Angsuman Chakraborty) The above PHP variables have slight differences which are often ignored, often leading to problems in large scale deployments or product solutions. I have attempted to debug them for you.
Integration Management
(Mark Smith) The impetus for organizations to support business intelligence (BI) and the imperatives of performance management has brought a renewed focus on IT aspects of information management and the required foundation of integration technologies. The nuances of disparate integration technologie
MDX Essentials: Basic Set Functions: The TopCount() Function, Part II
(William Pearson) In this article, we will continue the examination of the TopCount() function that we began in the previous article of the MDX Essentials series, Basic Set Functions: The TopCount() Function, Part I. Before getting “hands-on” with TopCount() in our last session, we introduced the fu
Convert Excel to XML file/XML Schema, and validate Excel against XML Schema
(Gaurang Desai) Often we are in a need to convert Excel data to XML stream/XML file which can be used as a feed to various applications like web services or middle tiers such as BizTalk 2004. There will be many situations where we need to validate the format of Excel data sheet against a specified X
An interview with Don Demsak (aka DonXML)
(Douglas Reilly) Don Demsak is a developer and consultant who serves the developer community by his participation in user group activities and Code Camps throughout the area. Don also loves XML and is a tireless advocate for using it in the right way. He is one of a relatively small number of XML Mi
The Trash Destination Adapter
(Allan Mitchell) This article is as a result of a requirement from the Beta Newsgroups. Jamie Thomson from Conchango wanted a destination adapter that did nothing but consume rows with no setup requirement from himself. He uses this type of component when he’s debugging amongst other things. There a
XML certification success, Part 2
(Pradeep Chopra and Hari Vignesh Padmanaban) This is the second part of a three-part tutorial series designed specifically for those interested in taking the IBM Certified Solution Developer Exam for XML and Related Technologies. This tutorial follows up on the lessons in Part 1 by introducing t
Running Stored Procedures with ASP.NET
(Wayne Freeze) If you’re writing SQL Server database applications (or Oracle or DB2 for that matter), you spend a lot of time building and testing stored procedures, especially those stored procedures that pass and return information through parameters rather than row sets. No matter how much yo