Archive for the 'Tips, Tricks and Hacks' Category

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: 4% [?]

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% [?]

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: 39% [?]

Search Engine Optimization : A Must Know For Bloggers And Web Site Owners

If your goal is to promote your blog and/or sell your products effectively on the Internet, then Search Engine Optimization (SEO) is a must for you.

Search engines are the drivers of traffic and you need to rank well on them to get traffic to your blog as well as product centric web sites. It is not only that, people associate a certain amount of trust with your site if they see you high in the search results. This trust factor gives weight to your site/product and helps you achieve better conversion.

To achieve better conversion, you need good traffic, and to get good traffic you need to rank well on search engines. Ranking well on search engines can be done more effectively if you have SEO skills in your repository (or you can always employ Search Engine Optimizers).

For those who are still unsure, please read this article from CNN on How to scale Mt. Google - Getting your site on the first page can turn a hobby into a thriving business.

I have joined a new company and SEO is an integral part of the software offered. I decided it was high time for me to be at least SEO aware if not SEO Maniac.

The first thing I did, which was recommended by most SEO experts, is buy Aaron Wall’s SEO Book. The book is supposed to be the bible on SEO. It is available in the form of e-book and can be downloaded from the site for $79. The book is worth much more the price you pay for it. Aaron keeps updating the book and you get the update versions for free.

I started reading it - am on the 5th chapter - and find it a very easy read with lot of interesting concepts and techniques. I have decided to open the book for discussion by talking at a high level about the book (chapter by chapter basis).

You are welcome to share your experiences, insights and gains through this series of posts where I will talk about each chapter of the book (as I go along reading it).

So get cracking on your knowledge of SEO, you are bound to get returns.

Buy The SEO Book | SEO Book Blog - Free SEO Tips | SEO Book - Free SEO Tools 

Popularity: 3% [?]

Google Talk Custom Status Message: Show Current Music Track

Google talk allows you to change your status message to any thing you want. It has also provided a way for you to share the name of the music track your are listening to currently as your status message.

The way to do this is very simple:

  1. Login to Google Talk
  2. Click on the down arrow below your name on the top and choose “Show current music track”. You can set it with a busy icon or available icon.

image

It will automatically pickup the track name from Windows Media Player and display it as your status message. I tested it with Windows Media Player, RealPlayer and Music Match Jukebox but it only worked with Windows Media Player.

Popularity: 4% [?]

How to setup Fedora 7 as full fledged replacement of Windows

Fedora is Linux operating system. It came into being when RedHat went commercial with their Linux distribution. It is an open source software.

There is a very detailed article (spanning 8 pages with graphic illustrations) titled : The Perfect Desktop - Fedora 7 which shows how to setup a Linux machine and with what software so that it is a complete replacement for Windows. The best part is that all the software on Fedora (including Fedora) is free!

Download Fedora 7

Popularity: 2% [?]

Make More Money By Suggesting Google Adsense

I have been facing problems recently with Google Adsense. It is not showing contextual advertisement and so the click rate had gone down. I wished there was some way to suggest Google Adsense about what advertisements to show (assuming they do not understand by default).

Recently, I ran into this post about a plugin for Wordpress called Target Adsense. It provides you great control over how Google Adsense targets your blog posts. It provides section targeting, which allows you to suggest Google Adsense what portion of text you want to lay more stress on and what you don’t. This will allow you to display ads which are more suited for your post, which in turn is more likely to result in clicks, thus allowing you to make more money.

Read more »

Popularity: 4% [?]

« Previous PageNext Page »

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