(Marcin Policht) In articles of this series, we have been so far providing recommendations regarding security-related configuration settings of SQL Server 2000 from the point of view of a database administrator. We have presented a set of guidelines that apply to any generic installation of SQL Serv
Author: SSWUG Research
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
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
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
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
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.
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
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
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
DB Change Management – An Automated Approach – Part 2
(Darren Fuller) Part 1 of this series discussed the need for database change management and problems with current approaches e.g. the manual creation of upgrade scripts, which is inefficient and error prone. This second article of a 4 part series examines an automated approach to database change ma