Setting up Transactional Replication from a back up copy

Recently I was trying to set up Transactional Replication in SQL Server 2000 from a back-up copy. After a few hacks and work arounds and lot of trouble-shooting I was able to get it up and running. I documented the steps I followed.  Check out the article here.

Getting Results of a Query into Excel without formatting issues

Recently I had to ship out chunks of data into an excel sheet for some queries. I wrote an article on it. Feel free to check it out here.

MVP Renewed for 2007..

I got an email this weekend saying my MVP award has been renewed for 2007..Thats second year in a thrilled...not to mention the $150 . Last time I was at the summit I almost bought some stuff but I gave up frustrated with the line going a few hundred yards out of the building when it was freezing outside..  I will probably get the Laser KeyBoard/Mouse