I had to come across a situation where I had to cut a large single .csv file containing 2.2 Million records into smaller files. Initially I thought of using already available split tool to do it, but then decided to write my own File Splitter tool in C#.  Thats how I came up with this tool. The File Splitter Tool takes an input file and splits it into multiple files each containing the number of records you specify. Here is the source code for the tool.

If you have  been working in Visual Studio 2005 or later, you sure would come across a file  with the extension .vshost.exe.  You should find this file under the bin folder or the debug folder of your application.

If you open a very large file in Excel it might not open up fully. For instance, I tried opening up a .csv file of 480MB and which had 2.2M records it would not open up completely. The reason is Excel has a limit of 1,048.576 rows and 16, 384 columns it can have in a file.  

I am trying to run Queries in MS SQL Server  and it comes up with errors if I specify table names or column names in a different case. The query is case-sensitive….!!!!

We find both bool and Boolean types in C#. It just made me wonder if there is any difference between the two types. It appears there is no difference between the two as both Represent the Boolean Type. So bool is just an alias to the System.Boolean type.

If you are using the SQLCMD utility and want to avoid or suppress the column header in the output of SQL Script.

As you use StreamReader to manipulate Text files and read one line at a time using Readline() Method you might come across a situation where you are somewhere in the middle of the Stream say on the 5^th line and want to go back to the begin of the Stream. You can do that using the Seek Method on the BaseStream of the StreamReader as in this example.

 Use a Scatter-Gather that broadcasts a message to multiple recipients and re-aggregates the responses back into a single message.

The Scatter-Gather routes a request message to the a number of recipients. It then uses an Aggregator to collect the responses and distill them into a single response message.

Read More..

Using SQL Reports is Fun. I have been having fun using it recently. It’s pretty cool. 
Wanted to figure out how to disable the Export Options in the SQL Reports when it is displayed to the user in Report Viewer. To be more specific I wanted to disable exporting in .pdf format. After looking around for it found  out it can be done in the rsreportserver.config file.