Gogula has written, good, properly explained article on SQL Server 2008, one of the newest data types, hierarchyid and has been published at http://sqlserveruniverse.com . It is a very useful article, worth to read it.

Click here to read the article.

I have been doing lot of development on SSIS for last two, three months and I made this note on what I faced during the project. It may useful for your future SSIS development, or brush up your SSIS knowledge. Read and see.

Click here to read the article.

Anyway, original name for the article was not this :), thanks for Gogula, naming it with nice title.

My latest article, Data Comparison with Data Dude has been published at www.sql-server-performance.com. This talks about the way of comparing the data between two data sources and scripting the changes.

Read and see, click here to visit the site.

Had to spend few minutes on this, to resolve the issue but found no solution. The problem was really weird. It was with variable window;

 

Look at the variable window. All buttons are disabled, disallowing creating or modifying variables created. I made a search to see whether anyone has experienced this before but could not find anything related to this. However, closing and reopening the packed resolved the problem :).

Here is a chance to show your colors and win very valuable prizes. All you have to do is, write some, creative, good code on SQL Server 2008 that will help to the community and send to CodePlex.

For more details, click on here.