(David Marston and Joanne Tong) If you are concerned with the adoption of XSLT 2.0 and what will happen to your legacy stylesheet code, this is the article you need. It focuses on those features of 2.0 that address cross-version compatibility with 1.0. It explains how 1.0 and 2.0 processors recogniz
Other News
Data Analytics: A Huge Opportunity
(Stephen Gallagher) For years, the writers of columns like this one have been tantalizing data management (DM) and marketing professionals alike with visions of a future in which personalized, relevant, context-sensitive marketing messages are delivered electronically to specific individuals. The re
SQL Server 2005 Command Line Tool ‘SQLCMD’ – Part II
(Muthusamy Anantha Kumar) In Part I we saw a few ways of using the SQL Server 2005 SQLCMD command line utility. In Part II of this article, I illustrate how to use transact SQL files and generate output.
High-availability architecture and clusters (Sample Chapter)
(K. Gopalakrishnan) In today’s super-fast world, data and application availability can make or break a business. With access to these businesses granted via the ubiquitous and “always-on” Internet, data availability is an extremely important component in any business function. (R)
DB2 9 Application Development exam 733 prep, Part 4: Embedded SQL programming
(Roger E. Sanders) This tutorial introduces you to embedded SQL programming and walks you through how to construct an embedded SQL application. This tutorial introduces the process for converting one or more high-level programming language source code files containing embedded SQL into an executable
Getting use of Slave in MySQL Replication
(Peter Zaitsev) MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data. It is true delay is often insignificant but in times of heavy load or in case you was running some heavy queries on the master which not take time to replicate t
The Seven Deadly Habits of a DBA
(Paul Vallee) Calling widespread bad habits in database administration “deadly” may seem extreme. However, when you consider the critical nature of most data, and just how damaging data loss or corruption can be to a corporation, “deadly” seems pretty dead-on.
Building an Inexpensive Oracle10g Release 2 RAC on Linux – (RHEL 4.4 / iSCSI)
(Jeff Hunter) One of the most efficient ways to become familiar with Oracle10g Real Application Cluster (RAC) technology is to have access to an actual Oracle10g RAC cluster. In learning this new technology, you will soon start to realize the benefits Oracle10g RAC has to offer like fault tolerance,
Database Independent Development using ASP.NET 2.0: Dealing with Stored Procedures
(Jagadish Chaterjee) This is the second part of a two-part article. In the previous part we focused on developing database independent applications using ASP.NET 2.0. In this part, we will extend the functionality of the data access layer to the stored procedure level.
Using the FILLBY Method to Filter DB2 9 Data Sets…with a Twist
(Paul Zikopoulos) Since the middle of 2006, I’ve been writing about all the great integration features in IBM DB2 9 for the Microsoft Visual Studio 2005 integrated development environment (IDE) and the accompanying ADO.NET 2.0 API.