(Mark Brunelli) The latest version of Oracle’s flagship database — Oracle Database 11g — includes a slew of new XML-related features and enhancements, an Oracle executive said. (R)
Other News
On parametrizing views with contexts
(René Nyffenegger) Suppose I’m the owner of a shop where you can order daily deliveries of certain items.
SQL Developer, Migrations and Third Party Databases
(Sue Harper) A week or so ago, I popped over to Ireland to see some of the developers who are based there. I have mentioned before that the team based in Dublin are the Migration Technology Group. They are a busy team; building the Migration Workbench as an extension to SQL Developer, are also worki
Combining Web Services and SQL Server Data Utilizing Business Objects Business View Manager – Part 1
(Eric Landes) Many times your customers may want reports that combine data from different sources. For instance, maybe you need to get your customer data from ERP data and that data comes from a web service. That customer data needs to be combined with the data from your Project Management Softwar
Solving SQL Server 2005 installation woes
(Arthur Fuller) Are you familiar with the saying, “Whenever nothing can go wrong, something will?” Case in point: I have installed Visual Studio .NET (VS.NET) and SQL Server 2005 at least a dozen times on various boxes in my development studio. Recently, a hard disk on one of my boxes went to a bett
SQL Server Data Validation Workbench
(Robyn Page) The purpose of this workbench is to introduce some interesting techniques to check on the integrity and correctness of the data being inserted or updated in your SQL Server database tables.
MySQL stored routines and the command line client: No comment…Or Maybe..?!
(Roland Bouman) A popular myth holds that the MySQL Database Server strips the comments from stored procedures, functions, triggers, views and events. This is not true. Or at least, it is only somewhat true.
IBM DB2 9 Data Server Expands XML Presence
IBM has introduced a series of quick start software bundles for the DB2 9 data server to meet new standards for handling Extensible Markup Language (XML) data. It will enable clients to adapt to their information management environments.
SEC Says XBRL Presents Business Boon, Not Burden
(Doug Henschen) Don’t look at Extensible Business Reporting Language (XBRL) as an onerous financial reporting requirement waiting in the wings; look at it as an opportunity for better insight into competitors and financial markets. That was the upshot of the message delivered on December 5th in Phil
New Features in ADO.NET 2.0
(Joydip Kanjilal) Microsoft’s ADO.NET heralded the introduction of a disconnected mode of data access, enabling data exchange even across process boundaries efficiently. This is in sharp contrast to the earlier data access technologies with only connected data access mode of operation. It should be