Tag Archives: Tips’n’Tricks

Tips and Tricks

Enable Hyper-V in the Virtualized Windows Server 2016

Hyper-V and Hyper-V management tools are not enabled by default when you install the Windows Server 2016. Just in case if you have same problem with Window Server 2012 you can check this blog post for the details how to enable it!

However, we will dicsuss here how to enable Hyper-V and Hyper-V Management Tools in Virtualized Windows Server 2016, for example in most cases if you have Azure account where you can run Windows Server 2016 just in few seconds and for sure this is just a VM inside the Azure platform and here are some steps how to enable Hyper-V in that VM:

For sure the Hyper-V is part of the Windows Server Roles, so when you go to add the Hyper-V role:


Adding Hyper-V Role in your Windows Server 2016 VM.


After you click the next button you will have pop-up msg with Error like this:


Now you need to use our friend PowerShell, starting with a session as Administrator and type this command:

Enable-WindowsOptionalFeature -Online -FeatureName Microsoft-Hyper-V -All


Will start something to install and will looks like this:


After the finish of the install process you will be asked to restart your VM, so just do it.

Again go to add Roles & Features for your VM after restart and you will see that you have enabled the Hyper-V role in your Windows Server 2016.


Now go to the Server Features with Next button and in the section:

Remote Server Administration Tools >  Role Administration Tools > Hyper-V Management Tools  – click to install them.



After the successful installation , you will be able to see the Hyper-V Manager in your start menu like:


Happy virtualization with Hyper-V and Windows Server 2016 with lot of the new features including Hyper-V Management improvements, Nested virtualization, Shielded VMs, Windows Containers, Linux Secure Boot & more

Stay Tuned …





Ctrl+R in SSMS 2012

After the successful installation of the SQL Server 2012, some shortcut keys can be possible to not work properly like in early versions, and one of the most shortcut key that I had problem after my installation of the SQL Server 2012 in the SSMS has been well known shortcut Ctrl+R to remove the last results pane from the SSMS! Ok lets take a look few steps how to activate it in the new SSMS of the SQL Server 2012:

Select > Tools > Customize … click “Keyboard”

In the list window scroll down and find to select “Window.ShowResultsPane”
Go to “Use new shortcut in:” – select “SQL Query Editor”
Go to “Press shortcut keys” text box and press Ctrl+R
Click “Assign” and finally OK!

Now, when you execute a select statement in SSMS and you have results set, you can remove them, pressing Ctrl+R, that is very often used from the Developers and DBA to clear the results pane!

This is very little help and enjoy it!

Stay Tuned…!