(Willie Favero) Does this sound like the beginning of a discussion about one aspect of indexing in DB2 for z/OS Version 8? Well, it is.
Other News
Master the basic building blocks of an SQL database query (Sample Chapter)
(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)
Delving Deeper into Notification Services
(Bill Hamilton) In this second part of a multi-part article covering the Notification Services framework, you will learn how to create a Notification Services instance and application, a delivery channel, and more.
Comparing XML Documents with Oracle’s XDK 10g for Java
(Deepak Vohra) As a J2EE developer you might sometimes be interested in comparing a modified XML document with the pre-modified version of that document. Or you might want to compare two XML documents that are both based on the same DTD or XML schema. This article is designed to give you the inform
An error or an access violation occurs when you try to restore an archive file for a SQL Server 2000 Analysis Services database
Consider the following scenario. You try to restore an archive file for a Microsoft SQL Server 2000 Analysis Services database. The server on which you try to restore the archive file and the server on which the archive file was originally created have different regional settings or different langua
Using the MultiView and Wizard Controls in ASP.NET 2.0
(Wei-Meng Lee) One task that is common in web applications is data collection. For example, you may need to create a survey page for collecting user inputs. On that page, you may want to collect a fair bit of information such as username, profile, and answers to survey questions (often used to colle
Creating MS Word Document using C#, XML and XSLT
(Sudipta Sankar Das) This simple program demostrate how to create well formatted MS Word documents using C#, XML and XSLT. Using XSLT to create Word document requires the knowledge of RTF key words. RTF specification is available in MSDN site.
OLAP SQL Part 5 – Windowing Aggregates
(Chris Eaton) To date, I have talked about a number of aggregate functions that can be pretty powerful with analytic queries. But what I find even more interesting is the windowing clause that you can add onto some of these aggregates. This is the part of the OVER () clause that I have not described
Access your MySQL database for maintenance without a password
(Vincent Danen) MySQL is perhaps one of the most popular database systems currently available. It has a lot of great features, it’s open source, and a lot of Web-based applications use it for their back-end storage.
Building an XML Utilities Package, XML Debugger Part 3
(Lewis R Cunningham) If you haven’t already done so, I would strongly recommend you read the first and second parts of the coding part of this series before reading this entry. You can also read the requirements.