By Lisa Vaas – The XDB (XML Database) in Oracle Corp.’s Oracle9i Database Release 2 has a set of potential buffer overflows that a smart attacker could exploit to cause a denial-of-service (DoS) attack or to capture an active user session on Oracle9i, the company’s OTN (Oracle Technology Network) in
Author: SSWUG Research
Promoting the Penguin
By Robert Hall – Robert Clevenger is principal product manager for Oracle9i JDeveloper at Oracle. During the first few months of this year, he traveled across the United States, visiting Java and Linux user groups and presenting and discussing options and strategies for application development on th
Making Data Mining Work
By Keith Hermiz – Data mining’s ability to wrest value from data is hotter than ever. So why aren’t more people doing it right?
Migrating to DB2 UDB Express: A Roadmap
By David Carew – This roadmap is specifically designed for developers who are new to IBM technologies, are interested in porting applications to DB2 UDB (or developing applications for DB2 UDB), and want help navigating to the most useful online information from IBM.
Change Date Format within DB2 Tables
By ITtoolbox FAQ Team – I have just installed DB2 on AIX. By using SQL (select), I found that all date type is shown as 04/24/2003 I’d like to change it to this format: 2003-04-24. How do I display all tables in the database in that format?
Is the MCDBA Worth It?
By Brian Moran – When you look at how few changes have been made to the MCDBA program, you have to assume that Microsoft prefers a certification program that boasts a large number of minimally trained individuals rather than a lower number of highly skilled professionals.
BUG: SQL Server Virtual Server Setup Fails and You Receive an Error Message
Setup for a Microsoft SQL Server 2000 virtual server may fail and you receive the following error message: Only one usage of each socket address (protocol/network address/port) is normally permitted.
Worms and Viruses, Oh My
Two new computer attacks are wreaking havoc with PC users this week, clogging email systems and overwhelming corporate networks. The first, which oddly enough seeks to undo the damage from the infamous MSBlaster worm, is a worm called W32.Welchia or W32/Nachi; it aggressively looks for new hosts tha
DBAs strive for code of ethics
By Robert Westervelt – A session at The Data Warehouse Institute (TDWI) 2003 conference was dedicated to establishing a code of ethics for database administrators, a sign that DBAs are more likely than ever to be held accountable by outside regulators.
Use Triggers to Set Limits
Learn how to limit the number of detail rows for an order to a maximum of four.