Month: November 2007

..contributing to IT in London since 2002..

Some Turkish words with Persian or Arabic origin

Over the centuries, Turkish enriched with so many words taken from other languages, simply because of the ongoing relationships of nations. Almost every language has exchanged words. Like Latin affected most European languages, Persian affected Turkish, Indian, Arabic, Urdu, etc. Similarly Turkish had contributed to other languages as well. Below is a small list of …

Firebird SQL: The Power of Simplicity

Firebird SQL Server has always been a “proper” database system since it forked from Borland’s famous Interbase. I just love it! In some big database applications, I found that the developers preferred to duplicate a set of tables for probably performance reasons. For example, in most accounting databases, there is a notion of company so …

MS SQL Server: Using Remote Servers (Linked Servers)

Sometimes I need to have a quick way of transferring data from one database to another running on a separate machine, especially when the table structures are identical or similar, it saves time. M$ SQL Server 2005 has a feature called linked servers. Give a name to your server: SERVER123 Choose a provider depending on …

TomTom: How to setup Wireless Data Connection for Traffic

After having been stuck in traffic a few times and losing quite a lot of hours, I have decided to buy traffic addon for my TomTom One 2006 (they call it TT). For example, from Ilford to Bath it normally takes 2 hours. On one day, it took me 5 hours! If I’d known that …

Give me my simple Windows Explorer back!

Fancy vista makeup comes with some loss of simple old features: Select All (Ctrl + A) items in a folder simply does NOT work anymore!? But why?! I cannot understand why Microsoft is capable of producing very popular software applications, and is still incapable of keeping usefull features ..or breaking the working parts!? Apparently, this …

A PHP Framework of Your Own

With all the respect to the people out there devoting their time and designing frameworks, sometimes great frameworks; PHP’s creator commented on that something like this: “..so, you designed a new PHP framework, OK!” and walked away!! I am wary in using any library/framework for my PHP applications. PHP is already a scripting language, my …

MS SQL Server: Anomalies

Backup/restore databases: After the restore, you must revoke (sp_revokelogin) and grant access (sp_grantlogin) to users again, esp. if you are restoring the database on a different machine. Note: I use mixed mode authentication and prefer not to use Windows or domain users. VARCHAR or TEXT: Pro VARCHAR: They recommend to avoid using fields of type …