All posts in 'English posts'

Migrate OS X to a bigger hard disk

19-Nov-10

I wanted to upgrade my 2008 MacBook (the aluminium one without firewire) with a bigger and especially faster hdd. I chose a Hitachi Travelstar 7k500. So far, it was a good choice. This tip does only apply to an HFS+ formatted drive with a GUID partition table. I already had a (bootable) backup that i […]

Read the complete article »

#wjax 2010

16-Nov-10

Nachdem ich 2009 aus privaten Gründen weder auf der JAX noch auf der W-JAX war, zog es mich in diesem Herbst nach München, zur W-JAX. Neu für mich im Vergleich zu den letzten Jahren war, dass ich mir mal ein Zimmer im Tagungshotel genommen habe und bereits am Ende des ersten Tages war mir ziemlich […]

Read the complete article »

Optimizing the Oracle Query Optimizer

20-Oct-10

The Oracle Query Optimizer does a great job in rewriting Queries. For example the nested subquery in SELECT C.cust_last_name, C.country_id FROM customers C WHERE EXISTS (SELECT 1 FROM sales S WHERE S.quantity_sold > 1000 AND S.cust_id = C.cust_id);SELECT C.cust_last_name, C.country_id FROM customers C WHERE EXISTS (SELECT 1 FROM sales S WHERE S.quantity_sold > 1000 and […]

Read the complete article »

Unicode substrings in Ruby 1.8.x

15-Oct-10

Here is how to get correct unicode substrings in Ruby 1.8.x require ‘jcode’ $KCODE = ‘u’   "öäüÖÄÜß".split(//)[4,2].join # ÄÜrequire ‘jcode’ $KCODE = ‘u’ "öäüÖÄÜß".split(//)[4,2].join # ÄÜ Don’t know, if this performes well… In case you have better ideas, please drop me a comment.

Read the complete article »

Create reusable MySQL schema dumps

16-Sep-10

In case you need a MySQL schema transferred from one host to another and the schema names differ, you can ran into problems with a standard MySQL dump. Use the following statement to create a schema dump that contains all table and view definitions as well as all stored procedures without a reference to the […]

Read the complete article »