Welcome to My Site
This is my personal site. In it you will find information about my life and about my experience in software development. Please take your time and visit my gallery where you will find some interesting shots.
What's New
The very existence of this website is the most exiting news. It took me some time to put it together, but I think it came up nicely.
As off today you can leave you email address and personal details in my database. I promise that I’ll use them the way I want. You might have noticed that there’s no privacy section here.
What's Up Lately
Another news is that I added a Contact page to this site. Now you have the option to vent your spleen. Can't wait to hear from you.
I had several complaints recently about the complexity of the password that you have to enter to create an account here. I did not do it by purpose, this is the default behaviour of the membership class. Now I relaxed the format and you can enter whatever you want.
Well, I couldn’t help myself yesterday when a couple of guys were chatting about a “mysterious” problem with one of the client’s databases. All of a sudden the database became slow and they were theorizing that the application has to be profiled and checked for bad queries. I got a few spare minutes, took them to the café downstairs and explain to them how it works. All databases are based on physical files, they tend to get fragmented with time. This is the main reason for degradation in performance. The second most frequent cause is when table pages get spread all over the database file. It is sort of internal fragmentation. And the last thing to look at are missing indexes, badly design queries and so on. There are few basic rules to follow when dealing with databases. Monitor the fragmentation of your hard drives, when particular table gives signs of fragmentation, simple unload-reload will fix it. The best practice is to have a scheduled maintenance tasks to rebuild the indexes on daily or weekly bases.
A couple of days ago I tried to convert a VS project to SharpDevelop IDE.
The thing was that my simple c# code couldn’t get a reference to a control on the web page. It has been done so many times before, it is considered to be trivial. Yes, but no. Not if you are using master pages. You can find a good explanation and a solution here.
Sometimes I got the impression that the problems never end and are coming by the dozens. In most cases it’s due to the lack of testing, as far as I can tell. But even after spending a couple of days solving stupid oversights, I still consider that the open source software was the best thing that had ever happened to this industry. C’mon guys, keep the good work. Long live GPL!.