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 →
Peter Kellner is conducting a code camp in the bay area on Oct 27,28. Check here for more info. Speakers include Juval Lowy, Beth Massi, Deborah Kurata among many others.
Read more →
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 →
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.
Read more →
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 →
I am sure every SQL Developer/DBA must have had to do this more than once. In SQL Server 2000, there is no way to copy the heading from the result set if the output is a grid.
Read more →
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 →
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 →
Sometimes we need to pass an array to the Stored Procrdure and split the array inside the stored proc. For example, lets say there is a datagrid displaying sales orders, each sales order associated with an orderid (PK in the Sales table).
Read more →
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.
Read more →
I worked on RS reports for a while and had been confonted with this issue. When the report does not receive any resultset from the datasource it shows up only the header columns in the report manager which is all ok.
Read more →