..contributing to IT in London since 2002..
murat We had a database in MS SQL 2000 server. The server/database was configured NOT to use recursive triggers. We backed up and restored the database on another machine with MS SQL 2005. Again the database is NOT using recursive triggers. However, our application started to behave strangely. On one of the tables, we had 2 … Read moreMS SQL Server: Anomalies 2
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 … Read moreSome Turkish words with Persian or Arabic origin
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 … Read moreFirebird SQL: The Power of Simplicity
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 … Read moreMS SQL Server: Using Remote Servers (Linked Servers)
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 … Read moreTomTom: How to setup Wireless Data Connection for Traffic
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 … Read moreGive me my simple Windows Explorer back!
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 … Read moreA PHP Framework of Your Own
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 … Read moreMS SQL Server: Anomalies
I must admit, it was the first PHP conference I’ve ever been and really enjoyed it. Though meeting new people is always difficult, but my colleague Kalpana and I were able to chat with less than 10 PHP fans 🙂 Listening to Rasmus Lerdorf, the creator of PHP, was cool! He tried to connect his … Read moreUK PHP Conference: Output
We will be there! After the success of 2006 the PHP London user group are staging the UK’s second dedicated PHP conference on Friday, 23 February 2007. The conference will be a low-cost event, costing £50 for the day. Speakers include: Rasmus Lerdorf, Kevlin Henney, Simon Laws and Cal Evans. There is a 230 person … Read moreUK PHP Conference: Input