By MICHAEL DINH – The script will enable DBAs to backup the database controlfile in binary and ASCII format. When a DBA issues the command “alter database backup controlfile to trace;”, the result is a trace file written to the location defined by USER_DUMP_DEST, similar to mdl1_ora_25524.trc (which
Other News
Create and Modify SQL Server Indexes Properly
by Drew Georgopulos – Learn how to determine the state of your indexes and understand whether that state should be changed. See how evaluating the construction and location of your system’s indexes and deciding whether to adjust their fill factors and padding can improve the system’s performance.
XML Spy Tops as XML Editor
By Timothy Dyck – Altova GMBH’s XML Spy has long been a strong player in the XML space, and Version 5 of the XML editor raises the bar even higher. Of all the XML editors eWEEK Labs has seen—and we’ve seen a lot—the $990 XML Spy 5.0 Enterprise Edition provides the best overall combination of editing
Vendors update XML for Analysis
By Joris Evers – Version 1.1 of the XMLA specification is the first version of the specification created in conjunction with the members of the XMLA Advisory Council, a group of business intelligence software vendors that back XMLA, according to a statement from Microsoft, Hyperion, and SAS.
Build Your Own Lightweight XML DOM Parser
Microsoft’s MSXML parser is rich in functionality, but in some cases a full-featured parser is too large for resource-limited environments. Don’t count XML out yet though; you can write your own lightweight VB XML parser in fewer than 400 lines of code!
Use a query to document your database
By Parthasarathy Mandayam – Did you know that you can use a query to document your SQL Server database? This simple query on the system tables will do just that. You can easily cut and paste the results into a Word document and improve the look and feel. Imagine the amount of typing you will save! I
How to Select Indexes for Your SQL Server Tables
by Manish Rawat – Learn the basics of when to add indexes to SQL Server tables. Includes an introduction to how to read graphical execution plans.
Speed Up SQL Server Tables
by Kimberly Tripp-Simonnet – In SQL Server 7.0 and later, the best way to improve performance is to create the right data structures for how you use data. How you use the data always dictates the data structures, indexes, procedures, and so on, for your database.
Getting Started with XOM
by Michael Fitzgerald – Elliotte Rusty Harold’s new XML Object Model ( XOM) is a simple, tree-based API for XML, written in Java. XOM attempts to build on good ideas from other Java XML APIs — SAX, DOM, and JDOM — and to leave behind some of their frustrations. The result is a high-level open-sour
XML document generator
By Shailesh Yagnik – Output in XML format is very useful for data tranformation in internet-based applications. In general, if you have XML formatted data then it is easier to convert it to any other format. Using a new package in Oracle 9i allows you to create a XML document from a SQL query. The f