Using Fiddler for local requests

Although not documented here, an alternative way to use Fiddler to proxy local requests is to replace "localhost" in URLs by "127.0.0.1." (notice the extra dot!).

Don't forget to GO after ALTER TRIGGER

Today I found peculiar issue while doing SQL scripts...

A couple of months ago, I did an SQL script that, among other things had an ALTER TRIGGER statement followed by an UPDATE statement. This particular trigger was supposed to add data to a history table. For some strange reason though, I was having trouble doing a particular update statement, because it was being undone. After a couple of hours, I found the cultrip: there was an update statement inside the trigger. What happened? I didn't do a GO statement between the trigger and the update statement.
(Yeah, maybe this is obvious for all the SQL gurus out there, but it was not for me. Lesson learnt. :))

svn:ignore for Visual Studio

Similar to other source control systems, you can add an ignore list of files that should not be under source control. In subversion, this is the svn:ignore property. If you are using Visual Studio and the VisualSVN plugin, this can be achieved in the following way:

• Right-click the solution > VisualSVN > Properties...
• Click on New... > Advanced
• In the Property name drop-down select svn:ignore
• In the Property value text box put the list of expressions you want to ignore, separated by the space character.

Here is an example (work in progress, probably this will have the same content as my .gitignore):

*.suo

*.user

*.dbmdl

*.resharper

aspnet_client

thumbs.db

bin

Bin

obj

Obj

TestResults

debug

Debug

release

Release

You'll end up with something like this (TortoiseSVN):

Edit (2014-02-20)

Fixed an error in my example, each entry must be in a single line.

Update (2014-05-21)

Updated list.