(Gene Cobb) If you have been following recent IT industry trends, you may have noticed that there has been a lot of activity in the area of Business Intelligence (BI). Mergers, major acquisitions, and announcements have dominated the headlines in the past year. IBM has been quite active in this area
Other News
Next Chat with the Lab – Easily Deploy Database Workloads on Private Clouds
(Susan Visser) Join the next complimentary webinar in the DB2 Chat with the Lab series:
Migrating Sybase ASE to SQL Server: Similarities and Differences to Help in Planning a Migration Project
(Bill Ramos) This blog post explores the similarities and differences between Sybase Adaptive Server Enterprise (ASE) database applications and administration with Microsoft SQL Server to help you in your planning effort for migrating to SQL Server.
Using Flashback Database
(Maria Mundrova) I have played again with Oracle Flashback on Oracle database 11.2, last time I used it on Oracle database 10g. It is good to double security your production database before huge database upgrades on application level. Though we use storage snapshots we can also use and Oracle flashb
Decoupling business process and business data in WebSphere Process Server: A new twist to the MVC pattern
(Walter M. Jenny) This article describes a development pattern separating the life cycle of a business process and its corresponding business data. This approach provides strong decoupling of the respective life cycles, increasing robustness to cope with inevitable changes.
SQL Injection is Still Around
SQL Injection – It’s Still Around Recently I received an email from a colleague consulting for a company that has exposure for SQL Injection. They use a parameterized stored procedure, and determined that they had resolved their exposure to SQL Injection . SQL Injection occurs when a user embeds SQL Statements in input fields of an application or web form. […]
APAR Friday on a Thursday: Patrick Bossman does a guest post on RUNSTATS HISTOGRAM
(Patrick Bossman) An APAR closed recently that corrects an issue that exists with how DB2 collects RUNSTATS HISTOGRAM statistics. This APAR is significant to achieving proper optimization within DB2 10 and DB2 9.
OWB 11gR2 – DML Error Logging
(David Allan) A common technique for set based error handling with the Oracle database is using DML Error Logging which has been in the database since 10gR2, I posted an entry back in 2007 illustrating how to use this with OWB 10gR2.
Validating SOAP Message against WSDL
(Ivan Krivyakov) While developing our web service client, I received a message from the server that did not deserialize properly. It was rather large, and just by looking at it, I could not figure out what was wrong. It was obvious it is not conforming to the schema the client expects, but where?
Truly Random and Complex Password Generator
(0v34c10ck) Its an important matter of security to enforce complex passwords that have a sufficient length. From personal experience, if you ask a normal user to create their own passwords, their passwords will be based on a character set consisting of 36 case-insensitive alphanumeric characters: a-