PowerShell OS Support Matrix

This post comes as courtesy of Chrissy LeMaire and Carlos Perez. PowerShell is already shipped with Windows Operating System. Since it was released 10 years ago, different versions of PowerShell have been shipped through different versions of Windows. You could also upgrade to another version by installing Windows Management Framework. It would be quite useful to know what version of PowerShell is shipped with what version of Windows and up to what you can upgrade to get most out of it.

Carlos Perez was able to spend some of him time and put together a nice matrix about it, which you can see below: Continue reading “PowerShell OS Support Matrix”

SQL Error : Index was outside the bounds of the Array (Microsoft.SqlServer.smo)

If while working on Azure SQL PaaS or even on-premise SQL database, you are stuck with this error “Index was outside the bounds of the Array. (Microsoft.SqlServer.smo)”, the most likely reason is that the version of SQL server management studio on your local machine is on the lower version that the SQL server version on the server end.

In such a scenario, you would need to upgrade the SSMS version installed on your local machine. Apparently, the reason behind the error message is that SQL couldn’t show new features in your old SSMS version. Continue reading “SQL Error : Index was outside the bounds of the Array (Microsoft.SqlServer.smo)”

Oracle virtual box fails to work on machine where hyper-v is installed

Consider this scenario:

  1. You have hyper-v installed on a windows server/client OS and it’s working fine
  2. You install oracle virtual box or any 3rd party virtualization application on machine and it fails with below error:
VT-x/AMD-V hardware acceleration is not available on your system. Certain guests 
(e.g. OS/2 and QNX) require this feature and will fail to boot without it.

Or vice-versa. …Continue Reading

Install the Hyper-V role and create virtual machines using PowerShell

This blog post covers how to install Hyper-V on a windows machine using PowerShell and create virtual machines. To learn more about Hyper-V including system requirements, see Hyper-V overview. Also make sure that you have administrative rights on the machine for doing so.

Install Hyper-V Role

On a windows server:

Open Windows PowerShell session with elevated user rights and run the following command: …Continue Reading