(Calvin Luttrell) If you’ve ever found yourself scratching your head, wondering how to queue a message from MS SQL Server, then you might find yourself writing your own plumbing. (Microsoft will most certainly be dealing with this boggle in future version). And I don’t know how your boss operates, b
Other News
Functionality from the DB2 UDB SQL Reference for Cross-Platform Development not supported by Derby
(Mark Chiang and Daniel Debrunner) Some of the functionality described in the IBM DB2 Universal Database (DB2 UDB) SQL Reference for Cross-Platform Development Version 1.1 is not supported by Derby. This article lists these differences. This comparison was developed by reviewing the DB2 UDB SQL
Which edition of DB2 Connect is right for you?
(Paul Zikopoulos, Roman Melnyk and Leon Katsnelson) DB2 Connect is IBM middleware for connectivity from distributed systems to host- and mainframe-based DB2 systems. This article introduces DB2 Connect and discusses the different editions and pricing models to help you decide which implementation is
DataPump truncates delimited fields to 255 characters
(Darren Green) There is a known issue where DTS truncates delimited columns at 255 characters when exporting to a text file. The problem is not with the DataPump itself, it is due to the default properties of text file connection provider as used within the DTS designer and the Import/Export wizard.
Build a .NET Application on the Oracle Database
(John Paul Cook) In this article, I’ll explain the basic yet essential processes involved in building a .NET application that uses an Oracle database, including: –How to add project references to support Oracle class libraries in your .NET project –How to create Oracle Database connection
Controlling Mythological Code
(Steven Feuerstein) Don’t use the XYZ feature; there was a problem back in version n.n.” “Always use explicit cursors; doing so is the most efficient way to fetch a single row of data.” “Avoid packages; they use too much memory.” I bet you’ve heard one variation or another of such statements
Sending Query Analyzer Results to Excel
(Brian Moran) I often send query results to users through email or copy the results to Microsoft Word documents. Query Analyzer in text mode provides headings for the query results, but the headings don’t copy and display well in Microsoft Excel or email. I can use Query Analyzer’s output-file optio
Speed Up SQL Server Apps
(Roman Rehak) Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here’s a collection of such nuggets for developing SQL Server applications.
IBM Automates DB2
(David Worthington) After a nearly two-year hiatus, IBM has updated its DB2 database software with capabilities borrowed from its autonomic computing portfolio. DB2 Universal Database (DB2 8.2), formerly code-named Stinger, automatically self manages and self tunes data without human intervention.
Linux Kernel Exploitation
(Noel Davis) Welcome to Security Alerts, an overview of recent Unix and open source security advisories. In this column, we look at problems in the Linux kernel, Oracle Database Server, Oracle Application Server, DB2 Universal Database, vpopmail, MIT Kerberos 5, cfengine, CDE libDtHelp, Anonymous CV