(Ember Crooks) This post is focused on WebSphere Commerce, but may have some tidbits for those new to triggers too.
Other News
Replicating Non-Clustered Indexes Improves Subscriber Query Performance
(Jared Poché) One of the advantages of replication is that subscribing servers can be used for reporting thereby offloading RO query activity from the Publisher. Recently I worked on a performance case on such a replication subscriber, which would have been prevented with a simple change to the arti
More on Migration Planning
(Troy Coleman) Last week I mentioned IBM’s free DB2 10 migration planning workshops. IDUG has its own offering for those who will be attending the group’s upcoming conference.
JAXB and Unmapped Properties
(Blaise Doughan) JAXB (JSR-222) is configuration by exception, meaning that there is a default mapping applied to domain objects. This means that sometimes you need to explicitly exclude a field/property.
jQuery UI Autocomplete and Automatic Form Submit
(K. Scott Allen) It’s a common to automatically submit a form after a user selects an item from an autocomplete list. The keyword here is “select” – it will lead you to handling the select event of the jQuery UI autocomplete widget.
Evaluating REST Frameworks Part 1: A Maturity Model
(William Martinez) REST has been a very important topic of discussion for a while. This series attempts to provide a comparison of some current frameworks that support the development of systems that should be REST-compliant, regardless of the underlying protocol (typically HTTP).
Creating Map Drill Down Reports in SSRS – SQL Server 2008 R2
(Arshad Ali) SQL Server 2008 R2 introduced several new features in the SSRS (SQL Server Reporting Services) arena. In the data visualization category, we now have three additional ways to display and visualize/analyze data in the reports.
Tracking Script Changes Locally in Oracle SQL Developer
(Jeff Smith) Source control systems are a vital component to any serious software development environment. Tracking and merging changes, branching new versions, or reverting back to a previous incarnation of the code is so much easier when you have your source code versioned in a system like Subvers
I thought the new AUTO_SAMPLE_SIZE in Oracle Database 11g looked at all the rows in a table so why do I see a very small sample size on some tables?
(Maria Colgan) I recently got asked this question and thought it was worth a quick blog post to explain in a little more detail what is going on with the new AUTO_SAMPLE_SIZE in Oracle Database 11g and what you should expect to see in the dictionary views.
More on DST and Oracle Scheduled Jobs
(Gary Sadler) Ian Jones wrote on March 11 about the often-overlooked issue of Daylight Saving Time (DST) and its impact on scheduled jobs. We had another client with a related glitch but this time with the beloved DBMS_SCHEDULER facility.