(Alan Arnold) Globalization, the Internet, competitive pressures, and higher consumer expectations have significantly increased the need for dependable 24×7 information systems in businesses, as well as in not-for-profit and government organizations. Fortunately, a number of products, from a var
Other News
Simple XML website templates
(OOK) One of the most annoying things about .Net / web development is its growing complexity. As time goes on programming websites becomes more and more complex and the duration of projects are often much longer. Modern code is just full of too many objects and too many lines of code.
Auditing in XML
(Arup Nanda) One of the cornerstones of the security infrastructure in Oracle Database is accountability—the ability to record who did what. Oracle Database 10g provides auditing to record the activities of users in the database. When the activities occur (for example, a user updates a certain table
DB2 – the secret database
(Mark Whitehorn) DB2 is the most respectable and most powerful database engine in the world: it’s the pinnacle of database development. IBM makes a claim (undisputed to my knowledge) that more structured data is stored in DB2 than in any other database engine.
Using XML and XSLT
(Krishnan) XML Stylesheet Transformation(XSLT) is defined as a language for converting XML documents to other document formats.
Reduce upgrade unknowns with the SQL Server 2005 Upgrade Advisor
(Adam Machanic) If you are preparing to upgrade your company’s precious mission-critical systems to SQL Server 2005, it’s hardly an exaggeration to say that you need all the help you can get. Be sure to proceed with caution, however, as an installation hiccup could cost your company thousands of dol
IBM versus Microsoft data integration slugfest
(Vincent McBurney) I compare the data integration offerings of Microsft, with the release of SQL Server 2005, and IBM with the Ascential products. With major releases from both companies 2006 is shaping up as a data integration slugfest.
Database Opinion: A case for canned SQL
(Arthur Fuller) Like a Phoenix, the dynamic SQL versus canned procedures and user functions argument has resurfaced on the SQL newsgroups. Many of the proponents of the dynamic argument are web or Access developers, or developers of some other front end. Developers in the canned camp tend to be DBAs
Row_Number() function in SQL Server 2005 – Part II
(Muthusamy Anantha Kumar) In part I of this article, we saw how to generate row numbers and delete a simple single duplicate row. This article walks you through how to delete multiple duplicate rows. This article uses the new feature Row_Number() function, common table expression and the ANSI co-rel
Error Handling in PHP: Introducing Exceptions in PHP 5
(Alejandro Gervasio) Welcome to the last part of the series “Error Handling in PHP.” In two parts, this series introduces the basics of error handling in PHP. It demonstrates some of the most common methods for manipulating errors in PHP 4, and explains the implementation of exceptions in PHP 5, par