Archive for the ‘databases’ Category
Saturday, March 22nd, 2008
Hidden below the "Show Advanced Settings" button on the datasource settings page for MS SQL Server lies the "String format" setting. According to the manual this setting is used to "Enable this option if your application uses Unicode data in DBMS-specific Unicode datatypes, such as National Character or nchar." In ...
Posted in ColdFusion, databases | No Comments »
Thursday, February 21st, 2008
Through the Planet PostgreQL site I found a nice paper that compares database internals. It provides an interesting read, even if you are not really into databases.
Architecture of a Database System
Joseph M. Hellerstein, Michael Stonebraker and James Hamilton
Posted in PostgreSQL, databases | No Comments »
Tuesday, February 12th, 2008
The common misconception that a serializable transaction will single thread access to an entire table or even an entire database is pretty hard to eradicate. And the sad thing is that everybody just keeps repeating other supposedly informed sources instead of doing a little experimentation. So I have gathered some ...
Posted in PostgreSQL, databases | 5 Comments »