Subscribe web feeds using Pageflakes in Firefox 2.0

New version of the popular browser firefox 2.0 made feed subscription easier than before by including a cool web feed reader feature .




This feature lets you subscribe to feeds from a list of reader option that comes with the default installation, but sadly there is no entry for Pageflakes at the moment. Now, to have Pageflakes in your list of options , there is a way that I've found from Mozilla Links , which describes a way for adding your own custom feed reader to the list.

From that article, i have created the following link for you , that will do the work for you right away and let you subscribe feeds using Pageflakes from right this moment.

Make Pageflakes your Default Feed Reader.

This will also mark Pageflakes as the default selection in the dropdown list, just check the "Always use Pageflakes to subscribe to feeds" option and that's it.







Note:You need to visit Pageflakes and setup your page first before applying the above mentioned procedure.

Case sensitive query in Sql Server

Often it is needed that you need to search by tag directly from sql server or let's say you want to verify password against db(though i do it with hash matching). The most coolest way of doing is to add an "COLLATE SQL_Latin1_General_CP1_CS_AS" clause in your where statement.

For example,

SELECT *
FROM Eco_Tags
where [Title] = N'Fun' COLLATE SQL_Latin1_General_CP1_CS_AS

This will make sure that if there 'Fun' and 'fun' tags, it will only get the 'Fun' ones'.

Plenty of browser options!!!

Suddenly, the browser war has come up with its new look. Now a days, it is really hard to do CSS designing which works in all browsers. All browser ? These days , Firefox has browser series 1.0.*, 1.5 and 2.0 . IE has 6 and 7. There are other browsers that i am not considering like Safari along with the older versions of Firefox and IE. None of them has compatibility with each other 100%. They all claim to follow W3C standard strictly, but in reality you pull your hair out , understanding why the same CSS works in one browser but fails in other.

I want to say , If you have released a new browser with all new features , why we are considering old ones and why there so many versions with so much deviation out there, which making our lives difficult everyday.

A Reader's Toolbox

To buy domain you need not to worry about browsers compatibility because all browsers are supporting. The browsers issues must be kept in mind when you start website design. Many companies are using modern practices like search engine optimization for their websites. For websites promotion and marketing seo advertising is getting popular day to day. Latest backup software can help you to save your data and information. You can save your money when buying business web hosting because you can buy in bulk. Most of webhosting domain provides cheap rates in bulk buying.

Sql Server 2005 - Powerful paging using WITH statement

Sql server 2005 formerly named "Yukon" , is bundled with loads of features that can rock a database developer's mind.Among many of features, one thing that is truly mind blowing is the mighty WITH statement. Previously , it is a real tedious task to do paging from database. Some of the option were creating temp table, using cursors,etc. But, now is the time to forget those tricky methodologies.

Lets consider a simple table called employee( emp_id, name, salary). Now, suppose that we need to create a gridview with paging. One option is to bring all the data from database and do the paging in client-side and another one is to do selective fetch. In both cases we can use a stored procedure that takes some parameter and returns a resultset.

Let's see the following...

CREATE PROCEDURE GetEmployees
@Status int,
@StartIndex int,
@PageSize int
AS

WITH FilteredList( [emp_id],[name], [salary], [RowNumber])
AS
(
SELECT
[emp_id],
[name],
[salary],
ROW_NUMBER() OVER ( ORDER BY [ID] DESC) AS [RowNumber]

FROM
Employee
)

SELECT
*
FROM
FilteredList
WHERE
RowNumber BETWEEN (@StartIndex + 1) AND (@StartIndex + @PageSize)

Actually , the WITH creates a in-memory data structure based on ROWNUMBER or any other identifier that we might give. Finally, we separate the result based on that identifier. But anyway in the end it makes our life more simple at the end of the day.

Here in Pageflakes, i use it almost everywhere possible, which surely saves my time and nothing else.

New and Improved Pageflakes

The new and improved Pageflakes site has been launched with a great look and with its own community site. Community site offers “use before you add” feature, by which before adding a flake/feed/podcast , you can have a live preview that will help you build customized start page in no time. The Pageflakes community has its own Blog/Forum section , beside that you can now rate a module, view public pages of other users.Finally, it has a new template gallery concept which give the option to add custom pages by other users as your own.

New community homepage http://www.pageflakes.com/community. Dont forget to visit http://www.pageflakes.com

Asp.net Repeater over Datatlist

If you are doing a div based css design using datalist , then to tell you the truth , the design will be altered anyhow , cause data list always enters a span or table right into your html code, for that reason i use repeater simple but yet powerful in this type of task.

Using a repeater is same as datalist , just you wont get any template time desing view. But that will give you a full control over your html , which is required in lot of cases.

Moving to Blogspot

I had a blog site of my own (http://www.mehfuz.com) , which is a php based solution. Sometimes, it used to happen that the server went down and all my blogs get lost, I had to start from the beginning every time the blog server refreshes. I realized that for blogging any personal service is no good solution.

Still, i was too lazy to sign up any free blogger account , till i found that google users can log in to blogger with their existing account and decided to switch to Blogspot and say good-bye to my hosting service forever. :-)