Visual Studio 2015 Nuget.Config repositoryPath

So it looks like VS 2015 has changed (again) how they deal with Nuget management.  Now they no longer create the .nuget folder and the nuget.config file.

We still want to make use of the respositoryPath so to do this for new solutions create in VS 2015 we need to:

  1. Create a .nuget folder in the root of the solution (on the file system)
  2. Inside that folder, create a file NuGet.config. 
  3. In Visual Studio 2015, right click on the solution and add a new solution directory called “.nuget”
  4. Right click on that folder and select to add a new an existing file and select the NuGet.config file created in (2).
  5. Add content like this inside the NuGet.config file:

<?xml version=”1.0″ encoding=”utf-8″?>
    <add key=”disableSourceControlIntegration” value=”true” />
    <add key=”repositoryPath” value=”..\..\..\..\NugetPackages” />

Then reboot Visual Studio and it should work.

Fixing Hyper V “VMName failed to change state” error 32788

If you find yourself getting this error message:

The application encountered an error while attempting to change the state of ‘VMName’.  ‘VMName’ failed to change state.  The operation failed with error code ‘32788.’


Go to the settings of your VM:


And look for something in an error state:


In this case I had changed Virtual Switch since using the VM so it’s no longer valid.

Remoting (RDP) to Azure service: This User Has Expired

If you are trying to RDP into an Azure service and you get the message “This User Has Expired” that’s because when Cloud Services are deployed, the user is only enabled for a short period of time.  If you don’t want to fully redeploy your application you can modify the expiration.

To do this, go to the service’s Configuration section and click the Download button to download the configuration file.


In that configuration file you’ll need to change the value for:



Go back to the configuration page and upload this file using the Upload button.  Press Save and after a few moments it will change your user accounts expiration date.


Recently when trying to server up some images that were stored in an Azure storage container, we were noticing that the files presented this error message when using Chrome (but Fiddler traces showed success and it worked fine in other browsers).


It turns out this was not caused by duplicate header values being added to the response but instead it was because the image file name contained a comma that was not properly escaped by putting double quotes around the filename like this:

Response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + "\"");

Red Gate SQL Source Control–Solution for users not seeing Last Changed By user names

After installing the latest version of Red Gate SQL Source Control many of our non-sys-admin users were unable to see who had made changes to a database object.


After reading all the documentation and applying the suggested permission changes we found that we were still lacking some of the needed permissions to get this working.  After looking through exception details in the log files we were able to get all the right permissions setup.  Use the script below to grant your user/group the necessary rights.

USE master






GRANT SELECT ON sys.sql_expression_dependencies TO [UserHere]


USE tempdb


GRANT EXECUTE ON tempdb .dbo. RG_WhatsChanged_v4 TO [UserHere]




GRANT ALTER on SCHEMA::dbo TO [UserHere]


Working with SQL Reporting (rptproj) in VS 2015

After a bunch of searching and many incorrect suggestions I found the right SSDT package to get SQL Reporting projects to work in VS 2015:

Follow step 3 here:

Everything I did to get SSDT installed through Visual Studio as many suggested didn’t work for getting me access to SQL Reporting projects. Installing the SSDT package from step 3 in that link DID work.