(Giovanni Guardalben and Shaku Atre) The XML markup language should be the lingua franca of data interchange, but its rate of acceptance has been limited by an underlying mismatch between XML and legacy relational databases. This, in turn, has created a need for mapping tools that can make it relat
Other News
Transforming XML with XSLT and ASP.NET (Sample Chapter)
(Dan Wahlin) During the development of the XML specification, the W3C working group realized that for XML to reach its full potential, a method of transforming XML documents into different formats needed to exist. At some time or another, an application that has the capability to work with XML doc
The Microsoft .NET Managed Provider for Oracle depends on the Oramts.dll file to enlist the Oracle connections
The Oramts.dll file is used when you try to use Microsoft Transaction Server (MTS) in a distributed environment. The .NET Framework Data Provider for Oracle (System.Data.OracleClient) calls the Application Programming Interfaces (APIs) that are publicly exposed by the Oramts.dll file. The Oramts.dll
Solving the Mysteries of SQLCLR and System.Transactions
(Sahil Malik) My previous three articles covered the nitty gritty of CLR integration in SQL Server 2005 (SQLCLR). In addition to discussing the correct usage, they also explored various SQLCLR features (such as context connections) and their uses and restrictions.
Exporting a schema to a new tablespace
(Brian Peasland) I took the export of one schema and I want to import it into another schema. The user is created on a different tablespace, but when I import the dumpfile it is going to the old tablespace (the tablespace on which my exported schema resides) only. Because of this I need to increase
XML Serialization
(Dan Mabbutt) Now, let’s look at the XML version of the same thing. One nice thing about this is that it’s possible to convert to XML instead of the .NET binary serialization with very few changes. XML isn’t quite as fast and can’t capture some object information, but it is far more flexible and can
Siebel pitches customers on Oracle
(Martin LaMonica) Siebel Systems executives recently detailed the company’s future product plans and pitched the benefits of the proposed merger with Oracle.
An interview with Linchi Shea
(Douglas Reilly) Linchi Shea is a database expert specializing in enterprise management for SQL Server. He has written a series of articles for SQL Server Professional and what is arguably the book on SQL Server administration, Real World SQL Server Administration with Perl. I have seen Linchi on a
A Toad without Warts: Quest’s Toad Product for DB2 Hits the Streets – Part 1
(Paul C. Zikopoulos) The Toad product from Quest Software is a well-known database tool that helps to improve the productivity of application developers and database administrators (DBAs) working with some of the world’s most popular relational databases. In September 2005, Quest Software made some
Open Source Database Feature Comparison Matrix
(Uday Parmar) This handy comparison matrix and glossary let you compare and contrast the supported features of several popular open source databases: Cloudscape 5.1, Daffodil DB 4.0, MySQL 5.0, PostgreSQL 8.0, and PointBase 4.5.