By Tim DiChiara – Learn how to combine VB.NET & SQL Server 2000 to create slick database solutions & XML web services. Join us for a free webcast on Tuesday, April 30, 2002 at 01:00 PM EDT (17:00 GMT), with author Rick Dobson!
Other News
Don’t Shut Down That Database! Use Oracle 9i Online Object Redefinition Instead
By Chris Lawson and Roger Schrag – In this paper, two experienced Oracle DBAs will introduce you to this exciting new feature. Since neither of us works for Oracle Corporation, we’d like to think this paper is balanced and objective. First we will introduce the DBMS_REDEFINITION package. Then we wil
Get EXPLAIN PLAN without running the query
(Anant Verma) There are times when one needs to see the path that Oracle will choose for a particular query WITHOUT actually running it. It may be a very long-running query and trying to iteratively tune the query can take a lot of time. There is a command (SET AUTOTRACE TRACEONLY EXPLAIN), which wh
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
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
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
IOUG-A Live! 2002 – Day 5
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.
Microsoft Announces Notification Services
By Brian Moran – Microsoft announced SQL Server 2000 Notification Services and the product’s upcoming beta program at TechEd in New Orleans. Notification Services is a set of technologies that lets you easily develop and deploy applications that generate and send personalized notifications to wired
SQL Extended Procedure Functions Contain Unchecked Buffers
Microsoft released a security bulletin about unchecked buffers in Extended Stored Procedures.
Database startup/shutdown UNIX script
By D Busfield – Our development environment has over 10 databases active at one time. This script will start or shut down a particular database.