by Joe Lax – Oracle’s SQL*Plus is no SQL Server Query Analyzer, but with a little practice you’ll get the hang of it.
Other News
Managing Processes for External Procedures in Oracle 8i/9i
In his first article, Ajay Gurshahani details the use of External Routines in Oracle 8i/9i, which are helpful in eliminating the need for using CGIs and also make it possible to create dynamic libraries and call them from PL/SQL.
When a data file autogrows, does autogrowth block updates to the file?
No, but autogrowth of data files blocks allocations of new extents because SQL Server blocks changes to the allocation pages, which keep track of which extents in the file are in use, during autogrowth.
Troubleshooting SQL Server Backup/Restore Problems
Alexander Chigrik’s new backup/restore troubleshooting checklist is the first resource you should consult when attempting to diagnose and solve SQL Server backup/restore-related issues.
Tablespace Free Space Report
This tip comes from Rajesh Puneyani, Oracle DBA in Parsippany, NJ.
Calculate the Current Day
Need to calculate the current day, without the time? Michel Ulens, presenting a session on “Working Better With Linked Servers,” has a simple and efficient piece of code you can use:
Hacking XUL and WXS-based Transformations
by John E. Simpson – I am designing a new Mozilla browser for a university project, with the intention of making it more accessible for older people to browse the web. Could you give me a hand in the design of Mozilla skins?A: On the face of it, this seems a bit far afield for a column dedic
Tripwire Upgrades Network Security Tool
By Dennis Fisher – Tripwire Inc. unveiled a new version of its Tripwire for Network Devices security software, which now includes a Web-based management interface and the ability to output reports with XML data.
Father of Java Sounds Off
By Darryl K. Taft – James Gosling, the father of Java and a fellow at Sun Microsystems Inc., graced the Software Development Conference and Expo East 2002 with his presence this week, addressing a wide range of issues from Sun’s software strategy to Web services to embedded Java to open-source softw
Mixed Message for Oracle Users
When Oracle CEO Larry Ellison delivered his OracleWorld keynote this month via satellite while sailing off New Zealand, it suggested a desire on his part to be the center of customers’ attention without going out of his way to be in touch with them. We hope some of the other developments we noted du