Locate File in Solution Explorer - Visual Studio Macro

Created 15 January 2010 08:57
A colleague found this blog post by Brian Schmitt, which is one of the most useful little tips I've seen in ages.

I'm currently working on a solution with 30+ projects in it: and the Visual Studio items tracking REALLY annoys me when trying to navigate to files between projects that are far apart in the solution explorer tree. I've been wanting to turn this off for ages, but I also do like being able to locate the current file quickly in the solution explorer, so I just haven't got around to doing it. This Macro solves my problem perfectly.

To get this working:
  1. Switch of auto tracking: Tools, Options, Projects and Solutions, turn off Track Active Items
  2. Open the Macro Explorer: Tools, Macros, Macro Explorer
  3. Under MyMacros, right-click Module1 (you can rename this if you like) and click New Macro
  4. Replace the code of the Macro with the following:
        Public Sub LocateFileInSolutionExplorer()
        End Sub
  5. Save and close the Macro Explorer
  6. Go to Tools, Options, Environment Keyboard, and in the "Show commands containing" type in the macro name until it appears in the list below
  7. Select the file in the list, focus on the "Press shortcut keys" input field and enter the key strokes you want to assign to the Macro. Like Brain, I used Alt+L,Alt+L. Assign it, and that's it.
  8. Watch productivity soar.

SQL Server: Updating varbinary fields

Created 29 January 2010 15:52
I'm working on a development database with a lot of varbinary fields - these are great once you have your admin screens but they're a pain in the initial development phase when there is no GUI for loading data. This little T-SQL snippet can be used to update varbinary fields - or adapt it to insert new data into varbinary fields.
update [schema].[table] set Column = (
        FROM OPENROWSET(BULK N'E:\Share\Temp\myfile.jpg', SINGLE_BLOB) AS BinaryFile