Stephen Andert covers sessions on Oracle SQL tuning, I/O tuning, and 9i’s automatic database management capabilities in his latest dispatch from this year’s International Oracle Users Group conference in San Diego.
Author: SSWUG Research
Transform Legacy Data to XML Using JAXP
by Matt Liotta – By writing to the JAXP specification, Java developers can create extensible code routines to parse any type of data into XML. This tutorial shows you how to write your own JAXP-compliant parser to transform legacy data in a comma-separated value (CSV) format, output it to a DOM, and
Expand XSL with extensions
By Jared Jackson – The combined power of XML and XSL for representing, manipulating, and presenting data over the Web and sharing data across differing applications has been clearly demonstrated through the fast acceptance and broad usage of these technologies. Still, most developers familiar with t
XML group challenges GAO report
By Patricia Daukantas – The HR-XML Consortium Inc. of Raleigh, N.C., attacked the report after its April 5 release, claiming that GAO did not consider the group’s achievements. GAO warned that vendors are developing proprietary XML extensions that could eventually stop interoperability. It cited fou
Access, VB and SQL Server wildcard characters
by James Crowley – Visual Basic gives you several ways to provide pattern-matches in a search string. Typically, you use pattern-matching characters for two purposes: to search for strings in a VB application’s GUI or variable, or to look for items within a database, such as Access or SQL. When you
Using NEWID to Randomly Sort Records
From SQLTeam – We’ve got a quite a few articles on randomly selecting and ordering rows. I’m still amazed how popular that topic is. I recently stumbled across a post in the forums that led me to a better way to accomplish this. This has actually been posted a few times before. I’m just finally catc
Flaw Threatens SQL Server
By Dennis Fisher – Microsoft Corp. has issued a patch for a buffer overrun vulnerability in some versions of its SQL Server database software that could enable an attacker to execute code on a vulnerable machine.
MS SQL Server 7 and 2000 have unchecked buffers
By John McCormick – Database administrators using Microsoft’s SQL Server software need to know that their installation is vulnerable to an attack based on an unchecked buffer in the ad hoc query feature. This issue is covered in Microsoft Security Bulletin MS02-007.
Pink slips anyone? Top 20 mistakes an Oracle DBA can make, Part 1
By Ed Parry – Do one of the 20 things seasoned DBA and Oracle expert Rachel Carmichael of Dragonfly Consulting LLC listed in her presentation at the Oracle user event International Oracle Users Group (IOUG) Live!, and you could find yourself holding a pink slip faster than you can say “Victoria’s Se
Business-Savvy SQL
By Ganesh Variar – Business-Savvy SQL Develop and execute complex business-intelligence queries quickly and efficiently in SQL, using Oracle9i’s analytic SQL features.