Archive for June, 2007

Google News: Watch News in Images

Google news has launched an image version of their news site which can be accessed here.

Here is a snapshot of the new interface:

image

When you hover over any image, the animated slider on the right updates to show you the text of the news. you can also click on “related images” (circled in red on the image above) to see news related to the current news in images.

Source: GoogleSystem

Technorati tags: , ,

Popularity: 3% [?]

How To Copy Cells From Excel Which Meet Search Criteria

You have a huge excel file and you want to copy all the cells in one column which match your search criteria and place it may be in another excel sheet.

Here is how you can do it:

Select the entire column on which you want to search:

image

Search using Control + F:

image

Read more »

Popularity: 6% [?]

Web Data Administrator for Microsoft SQL Server

People who have to manage databases have often felt the need for 24/7 availability of some means to access the database server as they cannot always remotely login. SQL Server Web Data Administrator for SQL Server takes care of that problem. phpMyAdmin, a similar tool has existed for MySQL but I was very happy when a colleague of mine pointed out that a similar tool existed for SQL Server.

This is a tool which is provided by Microsoft but is officially unsupported. There are two versions of the SQL Server Web Data Administrator Tool. One runs under IIS and the other runs under a Microsoft .NET shared source web server named Cassini.

Read more »

Popularity: 5% [?]

Monitor Blogosphere For Search Terms Using RSS Feeds

Google Blogsearch, a search engine dedicated to searching blogs, provides the ability for you to monitor latest and top posts for keywords of your choice by subscribing to RSS feed of the search results.

Let us say you wanted to search for “Search Engine Optimization Tools” and want to keep a watch on search results through your regular RSS reader.

What you do is  the following:

  • Search for the keyword at Google Blogsearch
  • On the left hand side you will get the option to subscribe using various method
    • Email Alerts
    • RSS | Atom
  • You can subscribe to the search results using RSS or Atom

The good thing is you can customize your blog search results for the dates of your choice and then subscribe. The options are:

  • Last hour
  • Last 12 hours
  • Last day
  • Past week
  • Past month
  • Anytime
  • Choose Dates

This allows you to customize your subscription to monitor only blog posts in last day/12 hours etc.

 Google also provides the ability to add this RSS feed into your Google Reader in one click (can be found at the bottom of the page)

Popularity: 5% [?]

SEO Friendly Site Using AJAX

It is always recommended with AJAX solutions that you put href attribute of the link tag to the server side version of the same functionality and put the JavaScript in the onclick event for that link tag. That way users using your site will get the AJAX experience and the search engines will execute the server side version of the code (making your side SEO friendly)

Orca is an AJAX forum without AJAX problems. The “Back” button does work, bookmarks do work, permalinks do work and yes, it is search engine friendly. A dream solution for current web 2.0 applications.

A very nice explanation on how they have achieved this can be found at: Creating An SEO Friendly Site Using AJAX.

What  I liked the most was their solution for the back button problem!

Popularity: 5% [?]

Moving To Bangalore : How to decide on Schools in Bangalore?

Updated: 20th November, 2007

We have started Bangalore Schools site dedicated to providing quality information about International schools in Bangalore, CBSE Schools in Bangalore, IGCSE Schools in Bangalore and ICSE Schools in Bangalore. The site allows users to share their experience on schools and also to rate the schools on a scale of 1-5 (star system)

Bangalore is famous for Engineering colleges but I must say it has plenty of schools too (kindergarten to XII). That means more choice and more confusion as to which one to go with.

We wanted to live in a place which is close to a good school which we decide on. Our residence was dependent on the school we chose.

First we made sure we got the following things with us before we left US:

  1. A letter from the school stating which grade he was in and till what grade level was in on various subjects
  2. A letter from Kumon (Maths Class he used to take) stating his level of proficiency in Mathematics)
  3. His latest grade sheet from his school

My wife’s brother was a great help as he was already in Bangalore and had done school hunting in past for his son. Based on his list and talks with other people we created a list of possible schools and we started calling them. Some of the prominent ones are:

Read more »

Popularity: 28% [?]

Excel 2007 : How To Save Excel Chart As Image

This post demonstrates an easy way to save a chart in Excel 2007 as an image (png, jpg, gif, bmp etc.).

Create the chart based on the data in Excel.

Right click anywhere on the chart border and say “Copy”.

image

Now open paint (Start-> Programs -> Accessories -> Paint) and say Paste.

image 

The chart will be pasted into paint and you can save it in any image format (supported by paint).

image

 

Popularity: 17% [?]

Search War: Delhi, Bangalore, Mumbai, Chennai and Calcutta

bangalore delhi calcutta mumbai chennai

image

Above is the snapshot of Google Trends for Bangalore, Delhi, Calcutta, Mumbai and Chennai

As you can see, Delhi dominates the search volumes with Mumbai and Bangalore fighting it out for the second place. Chennai is fourth and Calcutta finishes last.

In news reference volume, Delhi is a clear winner, followed by Mumbai and then rest of the cities. Delhi being the political center is it understandable that it will have high news references.

You can use Google Trends page to discover hottest search terms for any day and do interesting comparisons like the one above.

Popularity: 3% [?]

Next Page »

Technology Blogs - Blog Top Sites Blogarama - The Blog Directory Technology blogs Technology blogs blog search directory