(rrees) I have previously found XML Schema to completely invaluable in defining interface points between systems. Normally file interfaces between systems are done in formats that are deceptively simple: CSV, structured text files. However in nearly all cases the initial simplicity tends to lead to
Other News
SQL Server Database and Java
(Kent Milligan) Is there a way to access the SQL Server Database without using DB2 Integrator or WEBSPHERE Integrator? Can it be done using Java? (R)
What’s New in Visual Basic 9.0? Part 1
(Wei-Meng Lee) With the release of Visual Studio 2008, Microsoft has also updated the VB language to its latest version, 9.0. In VB 9.0, there are several key language enhancements that have been made to support the new Language Integrated Query (LINQ) feature announced earlier by Microsoft. This ar
Tip of the Day — innodb_force_recover
In preparation for disaster recovery and for training purposes I asked our Junior DBA to document the innodb_force_recovery options in our internal Wiki. I am modestly familiar with the command having used it a few times because of data corruption. However, somehow, I completely missed something t
Oracle Database 11g: SQL Plan Management, Part 2
(Jim Czuprynski) Oracle Database 11gR1’s new SQL Plan Management tool set gives any Oracle DBA the ability to capture and preserve the most efficient execution plans for any SQL statement. This article – the second in this series – explains how SQL Plan Management can be used during the upgrade of a
Automating Backups for SQL Server 2005 Analysis Services Databases
(Rob Fisch) SQL Server 2005 Analysis Services does not offer any straight forward way to automate backups for its databases. There are no objects in the Maintenance Wizard or Integration Services for this task. Even the Analysis Services built-in (right-click) backup option has no automation or job
Free IDS book!
(Susan Visser) Available now… an electronic version of the very popular flashbook by Carlton Doe: IBM Informix Dynamic Server: The Next Generation OLTP Data Server Technology.
XML serialization for complex object model
(brent.wjh) About 3 months ago, I was asked to work out a program running on Pocket PC with .Net Compact FrameWork. It is a program drawing rooms and calculating the geometrical parameters and exporting them to XML file. The program itself , should be able to save the rooms to files and load from th
How to sync tables in master-master MySQL replication
(Xaprb) Suppose you have a master-master replication setup, and you know one of the tables has the wrong data. How do you re-sync it with the other server?
The Basics of .NET Framework Interoperability
(Dave) This article gives an overview of the platform invoke service in order to show how managed code calls a native function contained in a DLL. Assume your application might need to take control of Microsoft Office Excel and perform a processing routine. Because the Excel library is not written i