How to use Picasa Web Album with Google Data API – Part 3?

As we all know that Meta tag has very important roles in Search engine optimization and if we want to have out site listed with good ranking on search engines then we have to put meta tags. Before some time I have blogged about dynamically creating meta tags in asp.net 2.0/3.5 sites, in this blog po...

In post shows how easy it is to combine FileTables and FullText Search.

Writing where clause has been easiest thing. Most of the time we learn this as a first thing in SQL. I have often seen that many times a simple question with where one has to write about where clause they often fail or get confused

What is an IDENTITY Value? What are the different ways to get IDENTITY values and properties of IDENTITY Values? If you are going to answer that identity value is ever increasing, is it possible to have identity value ever decreasing value?

ANSI ISOLATIONS levels are very important part of any database. There are two database servers both have different isolations levels. Due to the same different results are returned to the users. Let us help them by educating regarding various isolations levels and their various behaviors with example. What are the different ANSI ISOLATION Levels? What is the additional ISOLATION Level with SQL Server and explain its behavior?

This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week. http://beyondrelational.com/puzzles/challenges/106/calculate-the-payroll-hours-of-employees.aspx...

Many of you must have played the 'mangled words' game in the school. Here is a challenge that gives you an opportunity to play it once again using TSQL.

This challenge invites you to identify the longest sequence of alphabets from a string. This challenge is Version 2 of the TSQL Challenge 67. The difference is that in this version, you should apply circling while finding the longest sequence.

A website wants to display most relevant ads on each of its web pages based on the keywords associated with each page. Your job is to write a TSQL query that returns the advertisements most relevant to each web page given in the source table.