So you shouldn't need to do this but in my case for some reason I needed to activate windows after performing and upgrade from Windows 8.1.

In my case I tried activating Windows by clicking on Activate Online and that didn't work for me. I managed to activate Windows 10 by entering the product key for enterprise.


Windows 10 Pro Key: NKJFK-GPHP7-G8C3J-P6JXR-HQRJR

Windows 10 Enterprise Key: PBHCJ-Q2NYD-2PX34-T2TD6-233PK

You can download bat files that set the key from my GitHub gists using the links below

Activate Pro Gist: http://31og.com/gist/fc85f772fbc35c470f7d

Activate Enterprise Gisthttp://31og.com/gist/b49470b9ba1cf861d56c 

You should be able to find these on the preview site as well. Hopefully this is useful for someone else as well Smile


In windows 10 when you go to Change the background and colors on Start


it loads up the Color and Appearance window


which does let you change the accent and background color for windows. So you stuck with that weird purple looking theme or I managed to get blue type color on one of my machines. After a quick Bing I found that you can just set 2 registry entries restart your pc and you now have theme color that you want Smile.

Basically you need a registry file with the contents below (save that into a .reg file), set the hex values for your color and then run it.

   1: Windows Registry Editor Version 5.00
   3: [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\Personalization]
   4: "PersonalColors_Accent"="#00b8ff"
   5: "PersonalColors_Background"="#000000"

You can also download this reg file from GutHub using https://github.com/Gordon-Beeming/ChangeWindowsTheme/blob/master/Downloads/set-theme-colors.reg and you can download an app that takes in the 2 hex values and then set it, you will need to run the app as administrator otherwise it will crash. https://github.com/Gordon-Beeming/ChangeWindowsTheme/blob/master/Downloads/ChangeWindowsTheme.exe


The app lets you preview the theme before setting it because you will need to restart after editing the registry to see the changes


I need a VSO account for Demos which needs to be separate from my personal and business VSO accounts. The problem is though if you go to the Visual Studio Online page and click Get started for free


and then sign in with your existing account details you are directed to your VSO profile page that shows all your VSO accounts.


So what do you do?

The first thing you are going to need to do is create another Microsoft Account (Live ID). At this point I'd recommend starting a new In-Private browsing session so that you aren't automatically logged into services. Head over to https://account.live.com/ and create a new Microsoft Account or you can head directly to http://www.visualstudio.com/ and create a Microsoft Account as part of your VSO Account creation.

I created my Microsoft Account before continuing to create my VSO account.

Creating a new VSO Account

Go to http://www.visualstudio.com/ and click on the Get started for free button. Enter an account name and click Create Account.


You now have a new VSO account Smile.

Adding a new User to your VSO Account

From the new accounts landing page which should look like below


Click on the Users tab in the main navigation


Enter your primary VSO account Sign-in address (that you want to link this account to) and choose the License that this user must get and then click Send Invitation.


At this point you will be able to log into the new VSO account with your primary VSO account.

Switching your VSO account Ownership

The last thing we need to do is switch the ownership of our new VSO account. Ideally for most Demos you would want to be the owner of the VSO account. To change the owner of a VSO account click on the Settings icon in the top right


Then click on the Settings tab


Choose the owner account (your primary VSO account for this example) and click Save.


Deleting a user from VSO

At this point you'd be able to delete the user from the demo account that you used to create the account with. You might want to do this if you for one need to use your 5 basic users free accounts for other demo users or if you want to repeat the steps in this post and don't want to create another Microsoft Account to do it with. To delete the user your create simply select them in the users screen and then click Delete.


You'll be asked if you are sure, click Delete User.


You now have a new VSO account linked to your primary Microsoft Account so you don't have to use different sign-in accounts for demos and your other VSO accounts that you may be apart of Smile


My internet connection is slow or down quite a lot. One of the things Robert MacLean pointed out today in a presentation at a Microsoft Dev Day event today is that is that you can make use of the local cache from previous downloaded packages. Below is how to do this Smile

You can simple hit ctrl + Q type NuGet and then choose Package Manager Settings.


When the window opens click Browse.


This will open a Windows Explorer window with a path like below


Copy that path into your clipboard and go back to the Package Manager Settings window. Click on the Package Sources tab and then click on the new button


Give this new package source a name and paste the path into the Source textbox


Click OK and you sorted. Your pc will now use your local cache for packages as well Smile


Recently SQL Prompt 6.4 was released. Below are some of my favorite features from this release Smile.

Execute current statement

I used to highlight a bunch of text (a couple of statements) then press F5 to execute that statement. With this new release you are able to easily execute the current statement by pressing Shift + F5.


You are also able to execute the current batch with Alt + Shift + F5 which is pretty cool.


Insert semicolons

Another neat feature is the Insert semicolons which quickly inserts semi colons at the end of each statement with a simply shortcut key of Ctrl + B, Ctrl + C


Rename variables and aliases

The last of the features I'm going to show is Rename variables and aliases. This feature makes me feel like I'm in Visual Studio with an easy way to rename variables without using Find and Replace. By pressing F2 on a variable it will change into a view like below where you can easily rename your variable


Release Notes

There is a bunch of really cool features that have been released in this version including 41 requests (more details) from the Red Gate User Voice site. You can view the official release notes for 6.4 from http://br0wse.net/-SQL-Prompt-6-4-release-notes, other version release notes from http://br0wse.net/-sql-prompt-release-notes and finally if you want to download the new version you can go to http://br0wse.net/-sql-prompt.