Windows Workflow Foundation or WF is the latest cool thing from Microsoft.  It’s the Workflow way of developing applications. Its meant to make software development easier for developers. Using Windows Workflow in your Visual Studio makes the program flow very visual.

There are basically two types of Workflows

1.       Sequence

2.       Flowchart

And here is a list of Base Activity Library provided by Windows Workflow.

Working with the DataTime datatype in SQL Server can be very frustrating at times Especially, when you use them in your where clause. For example If you want to list all records within a certain date range, you might end up retrieving incorrect rows.

If you come across some strange differences in your SQL Server or SQL Management Studio in comparisons to what others are using, you are sure to be tempted to want to check you version number to make sure if you have the latest version with all the latest Service Packs Installed.

I have been using Service Broker recently and found it exciting and useful. It seems like a cool feather in SQL Server. I use the SQL Dependency class in my .Net Windows Service to listen for the Service Broker Notification. When there is an Insert to the tables in my database the Service Broker sends me a Notification which alerts my Windows Service Application to Query data from the table and do the processing. It works very well.

Here is the SQL Script to find the duplicate rows in a table in SQL Server

Now that Visual Studio 2010 has been officially released and that you have installed the VS 2010 TFS, you are sure excited about using TFS 2010. You might have installed the TFS 2010 client and might be using it very well.

I have installed Visual Studio 2010 and also the VS 2010 TFS client and am connected to my TFS server. Everything looks neat and exciting. Now when I try to Map my local folder to my Projects in TFS it comes up with a message stating “The Path … is already mapped in workspace ….” It looks like my local folder is mapped to the previous workspace I had in VS 2008, so it would not let me map to my VS 2010 Projects. What can I do to resolve this?

How to check if Broker Service is enabled in SQL Server?

To Verify if the Broker Service is enabled on SQL Database, run the following Query:

Flavors of Agile

Agile forms of development are increasing in popularity as the need for projects characterized by changing requirements become the norm. For many project leaders, waterfall development connotes a single image of a development method characterized by clear steps for developing software in successive stages. Everybody gets waterfall – the method has been around for years and is ingrained in business practices.

The Dangers of Poor Quality Data

Many statistics demonstrate the high cost of poor quality data. The Data Warehousing Institute (TDWI) estimates that poor quality data costs US companies $611 billion per year due to revenue losses and productivity problems. Some examples of the issues that create this negative impact in enterprises include: