(Michael M. David) This is the third and final part in this series of articles on ANSI SQL’s inherent hierarchical processing capability and its support of transparent native XML integration. Part 1, Using XML to Link Below the Root described how SQL can naturally integrate native XML at a full
Other News
SQL Server Auditing – Part 1
(Brian Kelley) SQL Server has several methods of auditing logins and the simplest among these is to change the audit level within SQL Server. Using traces through Profiler or the set of trace stored procedures is another method, but most folks gets started by configuring auditing in Enterprise Manag
Jagged Arrays and Performance in .Net
(Poonam) There are three types of arrays you can use in .NET: single-dimensional arrays, multidimensional arrays, and jagged arrays. Jagged arrays, also known as arrays of arrays, offer not only a space savings in certain conditions, but also a performance enhancement, as we will demonstrate. In
Understanding .NET Framework at a glance
(Chandrakant P. Parmar) In this article we are going to look at Microsoft .NET Framework. This is the newly established software development environment which helps developers to develop applications quickly and gives optimum, efficient, scalable, performance oriented applications in different langu
Database Configuration, the XML Alternative
(Michael Klaene) When creating software, it is a wise decision to separate business logic from information used to configure that software. Over the years, developers have used a number of techniques to externalize configuration. The goal is to make it possible to customize the functionality of a pr
Notes/Domino 7 promises tighter integration with DB2, IM
(Teresa Leung) IBM is set to bring its Notes/Domino version 7, which boasts tighter integration with other software, to the Asia-Pacific in the first half of 2005. A major new feature of Domino 7 is its integration with DB2.
XML representation of a relational database
A relational database consists of a set of tables, where each table is a set of records. A record in turn is a set of fields and each field is a pair field-name/field-value. All records in a particular table have the same number of fields with the same field-names. This article describes an appl
Revisiting Converting a Recordset to XML
(Carlos Baptiste) There have been several articles on 4Guys on retrieving XML from an ADO Recordset. Scott Mitchell’s article Creating a Function to Stream a Recordset to XML examined how to use the MSXML COM components to convert a Recordset into an XML string. David O’Neill extended Scott’s articl
Using XML Encryption With CipherReferences, Part 1 – Local Data
Most users of encrypted XML will encrypt their data and embed the resulting cipher value directly into the EncryptedData element, using a CipherValue tag. However, XML encryption also supports the use of CipherReferences, which allow you to place the encrypted XML outside of the EncryptedData elemen
Develop Perl applications with Apache Derby
(Moira Casey) In this article, discover how to use Perl, Open Database Connectivity (ODBC), and the Perl Database Interface (DBI) to access data in an Apache Derby database. The installation of Perl, the ODBC driver, the Perl DBI, and Perl DBD-ODBC modules on Windows is covered, along with a sam