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.
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.
For this purpose, we can use PowerShell cmdlet Add-Computer. For example, below command:
Add-Computer -DomainName mydomain -Restart
will add the local computer to mydomain and restart the computer. It can also be used to switch the domain of the computer or join back to the workgroup. For example, below command can be used to join the …Continue Reading
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