Probably the most interesting change is the addition of CQLinq – a LINQ language for querying the code base that supersedes the old “CQL” query language (that was more SQL-like).
It also includes support for Visual Studio 11 and a new API to make creating your own static analyzer(s). There’s a full list of new features in the Release Notes.
Upgrades from v2/3 are half the cost of a v4 license.
If you haven’t upgraded from v3 to v4, you can still download the latest v3 from the downloads page (it will say that your v3 license key isn’t valid for v4 but give you a link to the v3 download)
The standard way of editing a project file in Visual Studio is to first unload the project, and then right-click on the unloaded project in the Solution Explorer and choose 'Edit Project'.
Wouldn't it be nice if this was just one step instead of two?
Well one option is to install the Visual Studio PowerCommands or VSCommands extensions, both which add an 'Edit Project' option to the context menu for loaded projects. But if that's the only feature you want then installing one of those extensions might be more than you need.
Another option is to create a Visual Studio Macro and then add that to the context menu manually. Here's how:
- First, go to the Tools menu and choose Macros | Macros IDE.
- A "Microsoft Visual Studio Macros" IDE window appears.
- In the project explorer, right-click on 'MyMacros' and choose Add | Add Module
- Name the module "Projects"
- Within the new module, add the following code:
Public Sub EditProject() ' Ensure only projects are selected For Each item As SelectedItem In DTE.SelectedItems If Not (TypeOf item.Project Is Project) Then MsgBox("Can't open project(s) for editing as non-project items are selected", MsgBoxStyle.Exclamation) Exit Sub End If Next ' ensure solution is active DTE.Windows.Item(Constants.vsWindowKindSolutionExplorer).Activate() For Each item As SelectedItem In DTE.SelectedItems DTE.ExecuteCommand("Project.UnloadProject") DTE.ExecuteCommand("OtherContextMenus.StubProject.EditProjectFile") Next End Sub
- Save and close the Microsoft Visual Studio Macros IDE
- Now you can associate a keyboard shortcut with this new macro, and you can optionally add it to the project context menu.
- To add it to the context menu, go to Tools | Customize
- Select the 'Commands' tab and choose 'Project and Solution Context Menu | Project' in the Context Menu dropdown list.
- Scroll down the list of controls for this menu to find the location where you'd like this macro to appear.
- Select an existing control, and click on 'Add Command'
- Select the 'Macros' category
- Select the new macro from the Commands list and click on 'OK'
- Click on 'Modify Selection' to rename the menu item for the macro to 'Edit Project'
Now, when ever you use the keyboard shortcut or the new 'Edit Project' from the Solution Explorer's context menu, the selected project(s) will now be opened in the text editor.
Asthma First Aid is a free app I've developed in conjunction with Asthma Australia. It informs you of the recommended first aid steps for someone experiencing an asthma attack.
It features a one-click phone dialler to call '112' – the international standard mobile emergency number.
Everyone should know Asthma first aid, so if you have a Windows Phone, install it today
I think continuous learning is an integral part of being a professional. On the 24th April 2012, there's an opportunity for everyone with an interest in SQL Server to further their knowledge at the first SQLSaturday event to be held in Adelaide – SQLSaturday #139 (even though it's on a Tuesday!)
As the number suggests, these events have been running around the world for a while, but this is the first (hopefully of many) to be held here.
The schedule is now finalised and includes two tracks. Speakers include Paul White from New Zealand, Paul te Braak and Peter Ward from Brisbane, Raja N from Sydney, and local luminaries such as Rob Farley, Roger Noble, Andrew Butenko and even me!
So what would you expect to pay for a conference featuring this kind of expertise and experience? $200? $500? $1,000? Well you could pay that if you wanted to, but actually the whole day is free, thanks to the generosity of the event sponsors and speakers.
So run (don't walk) to the registration page and sign up today. Then go and let your manager/boss/social secretary know where you'll be on the 24th!
See you there