by Will Provost – Even with the clear advantages it offers over the fast-receding DTD grammar, W3C XML Schema (WXS) cannot be praised for its concision. Indeed, in discussions of XML vocabulary design, the DTD notation is often thrown up on a whiteboard solely for its ability to quickly and complete
Community
Descan Your Network
A SMALL COMPANY is about to go live with a big idea that you can greatly benefit from. The company is Descan.net, and the idea is to identify and halt the “script kiddies” who are infiltrating and subsequently attacking our computer networks.An example of the kind of attack I’m talkin
Get a random sample of rows
By Carl Federl – There are occasions when a random sample of a query’s rows are needed. A simple but non-functioning solution is to include the system random number generator function within the query. Unfortunately, a single random number is generated for the query when what is desired is a random
Dynamically Bind Your Data Layer to Stored Procedures and SQL Commands Using .NET Metadata and Reflection
Use the System.Reflection namespace with SQL stored procedures to query rich metadata that describe data types.
Options For Approaching Oracle Certification
Exempt yourself from the new requirement by taking one 9i OCP exam before Sept. 1, 2002. Read more for the description and other options.
Metadata API in Oracle 9i
By Srinivas Chittimalla – It is quite difficult to get metadata out of Oracle 8i and earlier versions.<br><br>However, in Oracle 9i, a new package was introduced: DBMS_METADATA. It allows users to get metadata information about any object (tables, indexes, procedures, etc) from a data dictionary wit
Certification Watch: Microsoft To Retire 10 Exams Next June
By Anne Martinez – Microsoft recently announced plans to discontinue 10 of its certification exams on June 30, 2003. The retired exams cover Site Server 3.0; Exchange Server 5.5; SNA Server 4.0; Proxy Server 2.0; Windows 98; Designing and Implementing Solutions with Microsoft Office 2000; Microsoft
Bmc Introduces Oracle Database Storage and Recovery Software
By Kevin Reichard – BMC Software has announced the release of Patrol Recovery for Oracle, a network-storage application that centralizes management of Oracle-database backup and recovery functions across the network. It’s designed for Oracle database administrators (DBAs) who want to manage multiple
The Guru’s Guide to Transact-SQL
Book by Ken Henderson – Information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. Covers Microsoft Transact-SQL. Softcover. CD-ROM included. Check it out and see some sample pages.
Oracle Goes XML
By Timothy Dyck – Oracle Corp. is the first among the big relational database vendors to make major changes to its database in response to XML, shaking up the generally overpriced and underperforming native XML database market something fierce but having a lesser effect on current Oracle database si