Cannot build a SSRS project in TFS build due to expired license

If you want to get your TFS build process to product SSRS RDL files you need to call the vsDevEnv custom activity to run Visual Studio (just like for SSIS packages). On our new TFS2013.3 based build agents this step started to fail, turns out the issue was not incorrect versions of DLLs or a some badly applied update, but that the license for Visual Studio on the build agent had expire....

October 15, 2014 · 1 min · Richard Fennell

‘Unable to reconnect to database: Timeout expired’ error when using SQLPackage.exe to deploy to Azure SQL

I have trying to update a Azure hosted SQL DB using Release Management and the SSDT SQLPackage tools. All worked fine on my test Azure instance, but then I wanted to deploy to production I got the following error \*\*\* An error occurred during deployment plan generation. Deployment cannot continue. Failed to import target model \[dbname\]. Detailed message Unable to reconnect to database: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding....

October 15, 2014 · 2 min · Richard Fennell

Microsoft ALM event to Black Marble offices on the 26th of November

Black Marble is hosting a free Microsoft ALM event at our offices on the 26th of November. For once I will not be speaker, Giles and Colin from the Microsoft UK Visual Studio Team are coming up to deliver the session. For more details and registration see http://bit.ly/ALMLeeds

October 15, 2014 · 1 min · Richard Fennell

Experiences using a DD-WRT router with Hyper-V

I have been playing around with the idea of using a DD-WRT-V router on a Hyper-V VM to connect my local virtual machines to the Internet as discussed by Martin Hinshlewood in his blog post. I learned a few things that might be of use to others trying the same setup. What I used to do Prior to using the router I had been using three virtual switches on my Windows 8 Hyper-V setup with multiple network adaptors to connect both my VMs and host machine to the switches and networks...

October 7, 2014 · 6 min · Richard Fennell

Version stamping Windows 8 Store App manifests in TFS build

We have for a long time used the TFSVersion custom build activity to stamp all our TFS builds with a unique version number that matches out build number. However, this only edits the AssemblyInfo.cs file. As we are now building more and more Windows 8 Store Apps we also need to edit the XML in the Package.appxmanifest files used to build the packages too. Just like a Wix MSI project it is a good idea the package version matches some aspect of the assemblies it contains....

October 7, 2014 · 2 min · Richard Fennell