The Google Song

We’ve all said this before when someone ask you a question, “Just google it”. Now this is a song about Google to go with that.

SQL to get minimum value based on a filtering option

Here is a great articles that I came across that explains in detail on how to select a minimum value from a column based on a particular filtering option.
The example listed here was how to select the cheapest price for the different categories of fruits.
http://www.xaprb.com/blog/2006/12/07/how-to-select-the-firstleastmax-row-per-group-in-sql/

Google Webinar for Analytics, Webmaster Tools and Website Optimiser

Google have put their webinar on analytics, webmaster and website optimaser on Youtube. It’s a really good webinar that explains the 3 tools, and really good if you are just starting to use these Google web tools.

SQL Script to search inside stored procedure

A little useful script for searching in stored procedures.
SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE ‘%searchtext%’
AND OBJECTPROPERTY(id, ‘IsProcedure’) = 1
GROUP BY OBJECT_NAME(id)

SQL Server Generate Change Script From Table Design View

This is something that I just found out existed today, probabily due to my lacking of actually going through the tool bar.
In SQL Server 2005, in the design view of table, usually you can perform a number of changes here like adding a new column, changing the column size etc, if you were performing these [...]

Javascript Functions

Lately I’ve been doing some reading on javascript and JQuery. This article here is  really good in explaining how the function in javascript works, and how you can use it as an object, override functions and other other really helpful information.
http://www.permadi.com/tutorial/jsFunc/