(Nicholas Chase) Even before there was XML, there was the Document Object Model, or DOM. It allows a developer to refer to, retrieve, and change items within an XML structure, and is essential to working with XML. In this tutorial, you will learn about the structure of a DOM document. You will also
Other News
Test XML queries interactively in Oracle 10gR2 SQL*Plus
(Bob Watkins) XML has become a common standard for information interchange. XQuery 1.0 is a standard language for querying data expressed in XML form. It is often called the SQL of XML because it performs the same function for XML that the SQL language does for relational data.
Ordering Events in Oracle
(Steve Callan) One of Oracle’s most critical and important functions is how it keeps track of events. Even within a single processor, “simple” database system, keeping track of events is just as important as recording and maintaining the proper order of events in a distributed system. Recording the
.NET Hang Case Study: The GC-Loader Lock Deadlock (a story of mixed mode dlls)
(Tess Ferrandez) I’m sorry I haven’t had a chance to write much lately because of a lot of different reasons. I moved houses and at the same time I started writing some managed debugging scripts for debugdiag 1.1 to allow it to automatically catch a lot of the issues that I’ve been writing about be
SQL Server 2005, Part III: Magic of Structured Search
(Alex Weinstein) You were patient enough to read through my ramblings about why Yukon and InfoPath are a match made in heaven, and how to set up basic interop. But these two articles left you dreaming of more. Well, that was their purpose :-).
An XQuery Servlet for RESTful Data Services
(Jonathan Robie) Many web applications exchange data as XML, but that data is usually stored in and queried from relational databases, CRM, ERP, proprietary repositories, and a hodgepodge of other systems. Unfortunately, the languages most commonly used for creating or processing data on the web wer
Video: Creating Web Services with the .NET Framework
(Dan Wahlin) The video discusses how to create a Web Service from scratch but also discusses some of the pros and cons that you should know about. For example, many people will return a DataSet from a Web Service. While that works, it is not very interoperable with non-.NET clients since the generat
How to Cluster SQL Server 2005
(Brad M. McGehee) Believe it or not, the procedure to install a SQL Server 2005 instance onto a cluster is one of the easiest parts of getting your SQL Server 2005 cluster up and running. The SQL Server 2005 setup program is used for the install and does the hard work for you. All you have to do is
Figuring out what limits MySQL Replication
(Peter Zaitsev) Today I was cloning the master using LVM Snapshot and found it was taking quite a while to catch up, which highlighted replication could be the limiting factor for this system quite soon, so I decided to check what is limiting MySQL Replication speed.
Averages, ratios, division by zero and NON_EMPTY_BEHAVIOR
(Mosha Pasumansky) How to get averages and other ratio based MDX calculations demonstrate great performance ? I thought I covered this subject in great depth before, but I probably wasn’t concise enough. Last week I was asked to help with performance to very big and important customer (who shall rem