(Dave Warner) Document storage is hot, hot, hot! There has been an explosion of methodologies and tool sets — both open source and proprietary — to fulfill the demand for quickly locating and searching documents. Enabling technologies like Alfresco, Sharepoint, or my favorite, TWiki, are powerful,
Other News
SQLServer: Dynamic Cross-Tab
(Muthusamy Anantha Kumar) Producing a cross-tab report with static number of columns is a straightforward process. When comes to the dynamic number of columns, it gets tricky. This article illustrates how to generate a cross-tab query on the fly, using the EXEC statement and simple string concatenat
Error message when you use XML functionalities against an instance of SQL Server 2000 after you upgrade an instance of SQL Server 2000 to SQL Server 2005: ‘Failed to load msxmlsql.dll’
Consider the following scenario. A computer is running multiple instances of Microsoft SQL Server 2000. You update one of the instances to Microsoft SQL Server 2005. You use XML functionalities against one of the instances of SQL Server 2000. In this scenario, you receive an error message that resem
Understanding the Falcon Transaction Storage Engine – Part 1
(Robin Schumacher) If you’ve been using MySQL for any time at all, you know that a unique advantage afforded MySQL users is the ability to use multiple storage engines to manage the underlying data stored on the server. This efficient and modular architecture provides large performance and manageabi
On importing data from Oracle into Excel with CopyFromRecordset
(René Nyffenegger) In my last blog entry, I have written a little Excel macro. This macro opens a connection to an Oracle database, issues a select statement and then iterates over each record within the result set. For each record, it also iterates over each attribute within this record.
Sun to Spend $200M Moving to Oracle 11i
(Peter Galli) Sun Microsystems will spend more than $200 million consolidating all of its internal business applications onto Oracle 11i and, while the move is expected to generate minimal savings in fiscal year 2008, it should yield major savings in fiscal year 2009 and beyond.
Concurrent model in ADO.NET, ways that allow to negotiate disconnected model restrictions for Oracle databases
(Michael Milonov) The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet, and DataAdapter. DataReader is only able to read data and can’t work as data so
TechTip: Panoply of Free Database Servers
(Michael Sansoterra) Last October, I wrote about learning how to write Microsoft .NET code using one of the free Visual Studio Express Editions. In this tip, I continue with the “free” motif by describing a few of the free database engines that are available.
Chasing Cars… and XML
“I DON’T KNOW why my dog chases cars,” goes the old joke. “After all, what would he do with it if he ever actually caught one?”
V8 Manual’s have been updated
(Willie Favero) Have you been out on the DB2 for z/OS Version 8 Books website lately? You should. As I am always suggesting, you need to visit this page frequently to make sure that you are always working from the most up-to-date information.