(Gywneth Evans) This article is ideal for DB2 UDB users new to either DB2 external routines or programming DB2 database application logic in a .NET common language runtime (CLR) programming language. You will learn what a .NET CLR routine is, what is required to create one, how to create them, a
Other News
The Atom Link Model
(Mark Pilgrim) Atom is an emerging XML vocabulary and protocol for syndication and editing. Atom has a coherent linking model to express a number of different types of links. Atom borrows heavily from the LINK element in HTML, although they are not identical. This article explores several of the mos
Exposing EJB Components as Business Services: An Architect’s View
(Mark M. Davydov) As organizations build, deploy, and orchestrate business services using Web Services technology, it becomes apparent that a careful and comprehensive design of Java 2 Platform, Enterprise Edition (J2EE) applications is required. The most effective systematic help in this area i
FIX: The msmdarch command returns an exit code of 0 in SQL Server OLAP Services 7.0
When you run the msmdarch command to archive or to restore a database in Microsoft SQL Server OLAP Services, the msmdarch command returns an exit code of 0 even if the archive or the restore operation fails. An exit code of 0 indicates that the archive or the restore operation completed successfully
Striking Gold with LogMiner – Part 1: Getting Started
(Steve Callan) Oracle’s LogMiner utility has been around for several years now, and it originally appeared as a new feature (as opposed to being an improvement of something else). Each major release of Oracle typically ushers in a new set of features, some of which are actually useful and can make y
Oracle SQL and index internals (excerpt 2): New performance views to identify problem SQL
(Kimberly Floss) One short path to identifying performance problems in an Oracle database is the following: –Find the sessions responsible for hogging the most resources (I/O, CPU, etc.) –Identify the code these sessions are running. –Peel away the bad code these sessions have execute
Exploring the Auto Update Statistics Option
(Brian Moran) SQL Server 2000’s ability to automatically update statistics for my tables and indexes is enabled by default. How often does SQL Server perform this update, and does the action have a negative effect on performance? (R,$)
Moving Logins – A Gotcha!
(Andy Warren) I recently had to move several databases from one server to another and ran into a problem with transferring the SQL logins. If you take a look at SQL 7 Books Online for sp_addlogin, it explains how you can use it for transferring logins by setting the optional flag @encryptopt to
XML Comments for Managed C++ Applications
(Jay Nelson) Most of my application development these days is in C#. Over the past 2 years I have grown accustomed to the C# XML comments built into the C# editor. As we all know by now, you can edit the project properties of your C# application and define an XML documentation file. With that proces
DB2 Universal Database Security
(Roger Sanders) Once a user has been authenticated and an attachment to an instance or a connection to a database has been established, the DB2 Database Manger evaluates any authorities and privileges that have been assigned to the user (these can be assigned directly to a user, or they can be obtai