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

Read …

New and improved DB2 support for Ruby on Rails

Our development team just released version 1.1.1 of the IBM_DB gem which provides support for using Ruby on Rails with DB2 and IDS. The new gem provides support for Activerecord 2.3.3 and a fix for a defect that will let us implement support for a popular Ruby on Rails application.

Fiserv moves to DB2 and .NET

66 Credit Unions are now running on Fiserv’s new platform built on DB2 and .NET.

Everything you ever wanted to know about a DB2 table but did not know where to look

Just like any other DBMS, DB2 keeps all of your data in tables. The tables are organized in a usual i.e. data is stored in rows with each row having one or more columns. This is true even in the case when the data that is stored as XML. Hopefully it is not a surprise that DB2 Express-C has a “hybrid” storage engine that stores both relational data and XML data in their native formats. We call DB2’s ability to deal with XML data “pureXML”. For XML, this means that XML documents are stored in DB2 as pre-parsed trees. These [...]

Read …