The New Google Analytics Available to Everyone

The New Google Analytics Available to EveryoneHey Google has recently launched the newer version of the Google Analytic to track the site or blog traffic. I am very happy after seeing the newer version of Google Analytics and Google has announced that it is in beta stage and available to every user...

List of All Built-In / System SQL Server Stored Procedures

Hey today I was searching for some system procedures to get system data and I found that on MSDN there is a list of all the native/system procedures with explanation. It took some time for me to get the exact stored procedure what I was searching for so I thought it will help others as well so...

Disable Back Button in Browser using JavaScript

 While we are developing any web application then some times it's necessary to disable the back button effect from the browser. This is common in banking websites and other sites where security is major concern. User may hit the back button from the browser and forget to log out from the site. There...

Concatenation in SQL, Using For XML PATH(), Concatenate more than one rows in one field

Some times it is required to concatenate more no of rows into one single filed separated by commas. There are some options for that like we can write our own UDF for that, in sql server built in COALESCE function is there with this function we can achieve it. But some time need is different or we...

List all the table in given database

Think that you have a database more than 1-2 hundred database tables and you want to get list of all the tables in particular database. I was working on a project with more than 356 table and required to get the list of all the table with column names, column types and length of data type so first...

How to use Rank( ), Dense_Rank( ) and Row_Number( ) function

Understanding Row Number Function Here we will see the Row_Number(), Rank() and Dense_Rank() function with details and example Look at the Figure 1  which has some data and in next figure 2 we are going to explain about the use of above mentioned function. Above figure has query and result...

Find All The Database Name in SQL SERVER

Get all the available database in SQL Server, using following command. Following all the command will list all the database on SQL Server. --In SQL Server 2008 --This is the Stored Procedure which will retrieve database name and size in kb and remark Exec sp_databases This stored procedure will...

A new way to communicate -- April fool by google 2011

The mouse and keyboard were invented before the Internet even existed. Since then, countless technological advancements have allowed for much more efficient human computer interaction. Why then do we continue to use outdated technology? Introducing Gmail Motion -- now you can control Gmail with your...