As more and more content moves to the XML format, and as XML files get more and more complex, you’ll sometimes need to analyze these files and generate statistical information about them. This requirement is, admittedly, not common. But if you ever do find yourself facing it you’ll be happy to know
Other News
Oradebug – Undocumented Oracle Utility
(Miladin Modrakovic) This document describes Oracle utility called oradebug. This tool is primarily used by Oracle worldwide customer support. With oradebug utility you can literally see the database engine. The oradebug is especially useful when things go very bad – e.g. the database just stops,
Beta Exam Opportunity – Sign Up Today
Get started, by registering today for the Oracle Database 10g New Features for Administrators beta exam and get recognized for your competency with the newest advancements in Oracle Database technology. By earning this credential, professionals demonstrate proficiency in the new features of Oracle D
Ranking Functions
(Itzik Ben-Gan) In my May article “Calculating Row Numbers in SQL Server 2005,” I discussed how to calculate row numbers in deterministic scenarios by using the ROW_NUMBER() function, one of four new analytical functions in SQL Server 2005. Here, I’ll complete the discussion about row numbers in
MS Access for the Business Environment: Stored Procedures from the MS Access Client
(William Pearson) This article focuses on a topic that in many ways is akin to our last, Extend Access with Pass-Through Queries, in that it is based upon the use of “SQL specific” or “direct SQL” within MS Access. While we have also treated the use of SQL specific queries in other articles, our wor
You receive an error message in the Reporting Services trace log when you restart the Report Server service after you change the user account that is used to run the Report Server service
On a computer that is running Microsoft SQL Server 2000 Reporting Services, if you change the user account that you use to run the Report Server service, and then you restart the Report Server service, you may notice a behavior that is similar to the following.
Entity and Character References
(Bob DuCharme) XSLT stylesheet developers often ask how they can leave entity references in the source document unchanged as the stylesheet passes them to the result document. For example, they want an entity reference in the source document to still be in the result document. The usual answ
Oracle Fixes SQL Vulnerabilities
Oracle has posted patches for its E-Business Suite and Applications 11.0 software to fix multiple, critical SQL vulnerabilities.
Migrate DB2 V7 databases to DB2 UDB Version 8.1
(Clara Liu) Learn the benefits of the latest version of DB2 and how easy it is to migrate to. This article summarizes the new features and enhancements of the V8.1.4 update. It then discusses the complete migration process including the preparation, the actual migration, and the post-migration tasks
Tablespace Growth Report
(Vishnu Bhavaraju) In Oracle8i, DBAs want to know how fast the tablespaces in their databases are growing so that they can plan for additional disk space. At the time of database/tablespace creation, DBAs use their best estimates to allocate optimal size to the tablespaces, but often need to resize