Stay in touch …

FreeDB2

Archives

The Article every DBA should forward to SQL developers

I think that every Database Administrator needs to read the article “Opinion: No more excuses for SQL injection attacks” and send it out to every application developer they know. I hate SPAM as much as the next guy but I think it is justified in this case. I am dead serious. We, the database people of all walks of life (DB2, Oracle, SQL Server …), have been talking about the benefits of using parameters in the queries instead of literal values for years. The main message has been “performance”. Most DBMS will perform much better and will use [...]

Read …

New cool stuff in DB2 Express-C 9.7: new concurrency model

It is not often that we get great things for free; there is often a catch. In the case of the new “Read Currently Committed” semantics, there is no catch. It is a great feature that is not to be missed by anyone who needs to develop and support high volume transactional applications. The best part is there is nothing to pay for, no code to change, nothing to tune or administer. It is on by default and it just works. [...]

Read …