Wednesday, September 19, 2012

SQL Query To Get Nth Row From A Table

Today a friend of mine asked me how to select the nth row in a SQL database table. I didn't know the answer, so I googled it. Of course, there were many solutions to this problem but I picked one and tried it on my local SQL Server. I want to share it with you now. Here is the template:

Thursday, September 6, 2012

Good Guy Google

Surprise Google Doodle

Wednesday, August 22, 2012

Reset Google Account Password

Yesterday, I had a problem with my Google account and I had to change my account password. Then I solved the problem and wanted to use my old password again. But surprisingly Google didn't let me use my old password even after 5 or 10 attempts and kept saying "Choose a password you haven't previously used with this account". After a bit of searching, I found out that you can't simply use your old passwords because Google "remembers" all of your old passwords.

Tuesday, August 14, 2012

Hosting Multiple Web Sites on the Same Server

So, today I will try to give you a hint about how to host two or more .NET applications on the same IIS. In order to do that, you need to configure a unique ID for each of the application. There are 3 different approaches:

Sunday, July 22, 2012

My Little Home Studio

The 17-piece Drum Kit

Finally, I finished off my drum kit assembly and now it is ready for playing. I'm not going to bother you with the details of how I achieved this but at least I can say that although it took me some time to finish it, it is totally worth. Now, above you can see the kit I am using at home. The drums and cymbals are explained below...  

Wednesday, June 6, 2012

Life's Good To Me...

That's a good way to call it a day!

 Laying before sunset... This is one of the coolest things that you can do right after you leave your office if you are living in West Coast of Anatolia.

Wednesday, May 16, 2012

There and Back Again...

Mount Ararat

Farewell to arms... I was a walking distance away from Iran, and now I am a swimming distance away from Greece. Hopefully...