Dinakar Nethi Blog

Dinakar Nethi

SQL Azure CTP1 is out

For those that have not heard about the "Azure" platform, Windows Azure is a cloud based operating system that offers software as services - .NET Services, Live Services and SQL Azure. Read more →

Setting up Transactional Replication from a back up

Here's a step-by-step (almost) instructions to set up Transactional Replication in SQL Server 2000 from a restored copy.   Restore the publication database onto subscriber. Restore the last transaction log backup onto subscriber. Read more →

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. Legacy Comments revathi 2008-01-01 re: Getting Results of a Query into Excel without formatting issues sql queries Chad Micheal Harlow 2008-02-04 re: Getting Results of a Query into Excel without formatting issues FTP Kevin 2008-06-24 re: Getting Results of a Query into Excel without formatting issues Hello jouer au site de roulette 2010-02-18 re: Getting Results of a Query into Excel without formatting issues I recall there was a problem when copying a comma-separated float value into Excel - the comma was misinterpreted as field separator, so I guess we changed that intentioanally into the US layout with the dot. Read more →

MVP Renewed for 2007..

I got an email this weekend saying my MVP award has been renewed for 2007..Thats second year in a row...am 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. Read more →

New Yak around…

Allright..so after having stuggled with my blogs @Dotnetjunkies and sending numerous emails to the admin to fix the issues and not getting any response, I decided to pull the chord off from DNJ. Read more →

Exporting blank report to Excel does not render the headers - MS Reporting Services

Exporting blank report to Excel does not render the headers - MS Reporting Services I digged the RS books online and I found that there is a noRows property in the report which can be used to display some message when there is no data…  From Books Online : Empty Data Regions When the dataset for a data region returns no data, the data region is not rendered. Read more →