Fiddler & Local host

Fiddle will not detect local host traffic.  There are different tricks to make it work.  The most known are

1. http://localhost.:30408/Page.asmx – Not the dot after localhost
2. http://127.0.0.1.:30408/Page.asmx – Fixed IP followed by dot then : port number

Are you slicing CSV row data

When you slice the CSV row data with embedded commas, double quotes and line breaks.  it becomes complex to handle.  An well defined RegEx will help you here.  Here is handy RegEx “,(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))” which works great.  Read more detail here.

Color code your SSMS Status bar for diff server

If you are working on multiple database at the same time and by mistake executing queries on different server (TRUNCATE on PROD!!).  Here is a cool tips for you.

When you are connecting to a server go to Connection Property tab and provide Customer Color. (may be RED for PROD).  The color will be visible in the Status bar.

You can notice the selected color in status bar.