(Howard Fosdick) IBM releases new versions of DB2 every couple of years, so I get a lot of questions about how new DB2 versions should influence a DBA’s certification plan. Does it make more sense to certify with version 7 or version 8? If you’ve already passed the exam DB2 UDB v.7.1 Family Fundamen
Author: SSWUG Research
How to Multiply Column Values in SQL Server
(Vinod Kumar) We had a recent discussion on the public newsgroups on how to get this requirement in a single statement without using T-SQL. I was indeed taken by surprise how this requirement was answered by fellow MVP’s. Infact there is a solution even though no so elegant, but works great having s
Automated Tree Drawing: XSLT and SVG
(Jirka Kosek) Trees are a very basic abstraction used in many computer science areas, including XML. If you’re writing a document about tree structures you’ll often want to show trees as graphics. This is not a problem for a few trees as they can be hand drawn in some graphics editor. But if you nee
Building VoiceXML Dialogs
(Jeff Kusnitz & Dr. Bruce Lucas) Until fairly recently, the web has primarily delivered information and services using visual interfaces, on computers equipped with displays, keyboards, and pointing devices. The web revolution had largely bypassed the huge market of customers of information and
Handling Package Security in DTS
To view, edit, protect, schedule, and run Data Transformation Services (DTS) packages on your network, you need to understand issues that affect package access, permissions, and connections.
Formatting Report Output in Oracle HTML DB Using Report Templates
(Raj Mattamal) In HTML DB, the layout of data displayed in report regions is ultimately controlled by report templates. In addition to facilitating basic formatting, however, report templates in HTML DB give application developers the opportunity to reference the data in a current row while determin
XML 2004 Conference and Exposition
The XML 2004 conference program provides the most comprehensive and customized education to maximize your time and further develop your XML techniques. Learn how to make the most of the industry’s popular tools and applications, hear about innovative solutions, and broaden your general knowledge. Yo
DBA Call to Action: Get up and GO
(James Koopmann) I am often questioned about how I became a DBA and the road I traveled. This can be a very valid question because there are many DBA-want-to-bees that just do not know where to start. In the early years, many positions just fell into my lap, as there was a boom in the industry. This
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
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.