(Matthias Nicola) First, what is TPoX? I have two answers to that question.
Other News
Efficient Backup and Recovery with DB2 Advanced Recovery Solution
(Thuan Bui) Watch how database administrators at a fictitious company improves their backup and recovery strategies with an IBM DB2 advanced recovery solution. See how the team uses various Optim and DB2 tools to make their backup and recovery process faster, simpler, and more efficient.
Storing Data in Unicode
(Troy Coleman) I recently heard a podcast on codepage, unicode and internationalization. Dan Luksetich and Susan Lawson interviewed IBM distinguished engineer and DB2 developer genius Chris Crone.
Star Transformation And Cardinality Estimates
(Randolf Geist) If you want to make use of Oracle’s cunning Star Transformation feature then you need to be aware of the fact that the star transformation logic – as the name implies – assumes that you are using a proper star schema.
SharePoint workflow, yes or no?
(Scott Robinson) SharePoint 2010 ratchets functionality up a notch across the board. But if Workflow’s your thing, you need to do a sanity check before pulling the trigger. Here’s a template for that sanity check.
IOT Part 6(B) – OLTP Inserts into an IOT
(Martin Widlake) IOT 6 part A covered the sort of insert work used to create an IOT or push a large number of rows into it via an “insert into…select from” type format. ie Bulk Load.
Advanced InnoDB Deadlock Troubleshooting – What SHOW INNODB STATUS Doesn’t Tell You, and What Diagnostics You Should be Looking At
(Chris Calender) One common cause for deadlocks when using InnoDB tables is from the existence of foreign key constraints and the shared locks (S-lock) they acquire on referenced rows.
Understanding Iterators: Concepts, Benefits and Functionality
(Joe Kunk) Iterators in both C# and Visual Basic provide a simple mechanism to asynchronously consume the elements of a collection as they become available, rather than wait for the collection to be fully formed and then processed. Iterators provide a very easy-to-code method to improve application
Using the Simplest Type Name in a Snippet
Code snippets are used to insert commonly-used fragments into source code files. When those snippets include type names the inserted name must be fully qualified or relative to a using directive. This can be automated with the SimpleTypeName function.
Represent Behavior with Classes not Flags
(Steven Smith) When designing your software systems, favor the use of classes to model behavior within the system over the overuse of flags in your data model. The resulting design will be more flexible, less tightly coupled, and easier to maintain.