vaibhav's blog

I used to create temporary tables and subqueries to add a row number to every row in the result set. But somedays ago, I came across to the Row_Number() function provided in Sql Server, which simply constructs the row number column on the fly as part of the query. But a question might have arosed in your mind, What is the use of adding a Row_Number, when we have serial number associated with every row. There are several situation, where we need to query against the row number.(we can't query against a serial number)

We have been using Linux for more then 18 years, without paying a single penny, Thanks to Open Source. There are more than 137000 registered machines, which are using Linux as their Operating System. Linux is the work of thousand of developers working as a Community. But have you ever wondered, what would be the development cost of Linux.

When I launched this blog in Drupal, I knew, I would be modifying its "Recent Comments" Block someday. I did'nt like Drupals default "Recent Comments" Block. It only display, subject of the comment with its posted time.

But I wanted a lot more. I wanted to display the "'comment author'(linking to author's homepage) added a 'comment' (linking to comment) to 'Title of the post' (linking to the post) (Time ago). I also wanted to separate Comments according to the node types. Comments on the blog entry and Forums should be shown in a differnt blocks. 

When I was developing this site, I knew I would be publishing a lot of Source Code. After some googling I foung GeSHi Filter for Source Code Syntax Highlighting. This module integrates the third party PHP library GeSHi (Generic Syntax Highlighter) into Drupal. GeSHi Filter, syntax highlight your source code between <blockcode>tag.

Its have been quite a time when Orkut launched Promote feature. In a recent announcement Orkut release its Bookmarklet feature. Now you can share any link with your friends on orkut by just clicking a Button. Visit this link to add a new button to your bookmark toolbar. Link shared will appear on your updates section as well as promote section in orkut.

Google now offers URL Shortening Service name Google URL Shortner for Google Toolbar and FeedBurner. Google Toolbar now use Goo.gl for link sharing. In an announcement today Google Launch this service. Google put three points to use Google URL Shortner over Other URL Shortening Services.

If you are running a ADSL or ADSL2 Modem and your internet connection is not working, here are some basic steps which you can follow before calling any techsupport guy.

These Steps worked for MTNL, BSNL, Verizon, AOL and other telecom companies which provide internet connection through a phone line.

I needed to connect to sql server from a remote computer which is on my home lan.
But got this error message.

Its very easy to take Backup and Restore your Database using T-SQL even if you are not a DBA. In one of the client application, I wanted to take periodic Backup without logging in to SQL Server Management Studio. Here in this small tutorial I will try to elaborate the procedure of taking database backup using T-SQL.

1. Create a Database

CREATE DATABASE PracticeDB

2. Take Backup of the Database

BACKUP DATABASE PracticeDB
TO DISK='C:\PracticeD.bak'
WITH DESCRIPTION='Database Backup',
INIT,
PASSWORD='TryAgain'