This document lists considerations when using XA in a RAC environment, the recommended solutions for both Oracle9i and Oracle Database 10g. (pdf)
Other News
XML and the SQL 2000 Server, Part 1
(Jayaram Krishnaswamy) This tutorial explores the IIS XML support for SQL 2000 Server. By configuring a virtual root on Microsoft Internet Information Services, data from a SQL 2000 server can be accessed using XML over HTTP, the details of which will be examined in another article. This is possible
Frequently asked Queries
(Arnay Joshi) This article contains query for nth highest numbers, creating random numbers in SQL SERVER, viewing sequentially numbered records etc. They are frequently asked sql server interview questions.
It Ain’t Easy to be Simple
(Mike Champion) There’s a lot of talk recently about the complexity of the XML and web services specs and tools, and advocacy for various alternatives that are supposed to be more "simple." One recent example is Sun CEO Jonathan Schwartz’s weblog, in which he wondered whether "web services may
Create and Drop Stored Procedures as a Group
(Jaya Nehru Kumar) Ever created a bunch of stored procedures for testing purposes and went to drop them but couldn’t remember all the names you created? A way to avoid this is to group multiple stored procedures under a single name.
FIX: You may experience the System.StackOverflowException error when you open an XML document that contains a deeply nested XML document in the .NET Framework 1.1 and in the .NET Framework 1.0
You may experience the System.StackOverflowException error when you open an XML document that contains a deeply nested XML document. Additionally, your application may fail. This problem may occur in the Microsoft .NET Framework 1.1 and in the .NET Framework 1.0.
Good Migrations
(Jeanne Kays and Roger Miller) DB2 Universal Database Version 8 (DB2 UDB V8) for z/OS offers significant opportunities for improvement in six key areas without a lot of added effort. They are: –High availability –Scalability and benefits for very large databases –Increased productivity of Ja
Oracle Remains Top Database Seller in 2004
(Clint Boulton) Oracle defended its title as the top database software maker in 2004, a year that saw the market grow 11.6 percent to $14.9 billion as businesses filled out unmet database management needs.
Open Source Databases: A brief look at the Berkeley DB, Derby, Firebird, Ingres, MySQL and PostgreSQL DBMS’
(Ian Gilfillan) This month I take a brief look at Open Source Database Management Systems. I do not aim to find the ‘best’ one, or perform an in-depth feature-by-feature analysis, but rather a introduce you to the variety of solutions out there. I am presuming readers of my columns by now already ha
Dashboard Development and Deployment – A Methodology for Success
(Daryl Orts) A dashboard is a vital tool for monitoring the daily health of your organization. From a single interface, decision makers have access to key performance indicators (KPIs)—actionable information that can be used to effectively guide and track business performance. Successful implementat