Oracle is billing its upcoming Database 10g as the “self-managing” database. Its new built-in features will enable the product to assume many administrative tasks that DBAs currently have to perform themselves. DevX looks under the hood to show you how 10g works.
Author: SSWUG Research
The W3C Workshop on Binary Interchange of XML Information Item Sets
Workshop to take place on 24th, 25th and 26th September, 2003. Participants include Sun, Nokia, France Telecom, Software AG, Canon, IBM, BEA, Microsoft, Oracle, Adobe and Web3D.
Sometimes Syntax Is Significant
by A. Russell Jones – If you’re using Microsoft XMP Parser (MSXML) version 3, you may be able to improve your XSLT style sheet execution times dramatically by changing nothing more than syntax. Recently I used an XSLT style sheet that set the value of a variable using a standard, supported XSLT synt
How can I retrieve the results of a FOR XML query using ASP?
Here is some sample code that you can use to write the results of a for xml query to an ASP page.
New DB2 Flaws Could Prove Troublesome
(Dennis Fisher) Security experts have discovered two new vulnerabilities in IBM’s DB2 database software, both of which allow an attacker to gain root privileges on vulnerable servers. The weaknesses are potentially quite dangerous, considering that DB2 is one of the most popular enterprise da
IBM patching DB2 vulnerability
By Paul Roberts – IBM released a software patch for a serious security vulnerability in some versions of its DB2 Database, according to the security company that discovered the problems.
How to Identify Real Versus Automatically-Created Indexes
I’ve noticed a lot of entries in the sysindexes table for indexes that I didn’t create. I heard that they’re not real indexes but statistics that the SQL Server query optimizer has automatically created. How can I tell if an index is “real” or one automatically created by SQL Server?
Track and Make SQL Server Database Schema Changes with AdeptSQL DIFF
by Brad M. McGehee – You are one of a team of developers working on a new internal application that uses SQL Server as its backend. Two of the team members, including yourself, have been assigned the task of database design and maintenance, while four others have been assigned the task of writing th
A Conversation with Jim Gray
Gray, head of Microsoft’s Bay Area Research Center, sits down with Queue and tells us what type of a voracious appetite for data could require such extreme measures. A recent winner of the ACM Turing Award, Gray is a giant in the world of database and transaction-processing computer systems. Before
Industrial-Strength Feedback
By David Baum – Many enhancements in Oracle Database 10g were developed with specific industries in mind. Here’s how requests from government, retail, life sciences, financial services, and other domains became new database capabilities.