(Gary Myers) When you need a subset of data for testing, it is very useful to be able to specify the filtering in the export or import. That’s a lot easier than copying a full dataset and waiting while it deletes most if it.
Other News
How to XQuery Non-JDBC Sources from JDBC
(Yuli Vasiliev) Learn to use XQuery from within JDBC code to access data in non-JDBC sources.
Linq to SqlXML
(Roger Alsing) I’m hacking along on my Document DB emulator ontop of Sql Server XML columns.
Challenges confronting the XBRL implementer
(Alan Earls) XBRLrepresents one of those instances where the use of an XML dialect is driven by an undeniable mandate. Initiated in the late ’90s to bring XML to accountancy issues, XBRL has now arrived in a rush for public companies as the Securities and Exchange Commission (SEC) mandates XBRL comp
Top 10 DB2 Support Issues
(Julian Stuhler) As one of Europe’s leading suppliers of DB2 services, my organization has been involved in a vast number of technical support calls and incidents with our customers. These situations range from the tragic to the downright bizarre, but each and every one can be avoided (or at least m
Creating a Distributed Management Framework Policy
(Mike Chapple) Policy objects specify the conditions you wish to enforce against database targets using the Distributed Management Framework (DMF). In this tutorial, we create a DMF policy that enforces the stored procedure naming convention condition we created together in the previous step.
What is innodb_support_xa?
(Baron Schwartz) A common misunderstanding about innodb_support_xa is that it enables user-initiated XA transactions, that is, transactions that are prepared and then committed on multiple systems, with an external transaction coordinator.
Oracle PL/SQL Subprograms
(W. Jason Gilmore and Bob Bryla) Throughout this book you’ve seen quite a few examples where the Oracle queries are embedded directly into the PHP script. Indeed, for smaller applications this is fine. However, as application complexity and size increase, continuing this practice could be the source
SQL Server Reporting with Analysis Services
(Kalyan Bandarupalli) SQL Server Analysis Services is used to present the aggregated data to support analysis, ad-hoc reporting and decision making process.
DB2 best practices: Data protection in the cloud
(Walid Rjaibi and Mark Wilding) Public cloud computing is an emerging computing technology that uses the Internet and central remote servers to host data and applications. It allows consumers and businesses to use applications without installing them locally and access information from any computer