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:

Good Guy Google

Surprise Google Doodle

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.

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:

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...  

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.

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...