Stay in touch …

FreeDB2

Archives

POWER7: What’s in it for the free DB2 Express-C?

On Monday February 8th, without much pomp or ceremony IBM announced the new POWER7 microprocessor architecture and the 4 new SYSTEM p servers that  utilize the new architecture. POWER7 is the next step in the IBM POWER roadmap and as far as next steps go it is a very significant one. I don’t intend to do a blow by blow account of everything that is new in POWER7 and what it really means. For those that are interested, I recommend attending one of the POWER 7 launch events/webcasts.

If you are interested in databases (why else would you read this blog), [...]

Read …

DB2 on Rails is now faster and more secure with parametrized query support

Not too long ago, I blogged about importance of getting developers to code parametrized queries  instead of using literal values in SQL queries. In this post I urged every DBA to forward an article that talked about SQL injection attacks to their developers. Well, it would not have helped any to send this article to a Ruby on Rails developer because Ruby on Rails does not support parametrized queries.  I should say “did not support till today”. Today IBM delivered version 2.0 of the Rails adapter for DB2 and the key future of this new version is support for parametrized [...]

Read …

DB2 Express-C helps Russian ISV improve performance 5-10 times

If you spend any time in the fast growing Russian IT market there is one name you will no doubt be familiar with. I am not talking about Microsoft, Oracle, HP or even IBM. A company with a very short name “1C” is an icon of the Russian IT economy. Founded in 1991, 1C helped the newly formed Russian companies to get proper accounting and other financial management footing to be able to compete on the local markets and to enter and, in many cases, lead in the global economy. 1C is a major software distributor and an award winning game developer. If you like combat [...]

Read …

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 less server resources [...]

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.