-
Recent Posts
Archives
Categories
Monthly Archives: September 2015
My book on Database Fundamentals is now available!
Finally, I’ve finished my book on the Microsoft Technology Associate 98-364 exam: Database Fundamentals. It’s available in the iTunes book store: https://itunes.apple.com/us/book/id1043228558 I decided to make it an iBook, since this format provides a combination of text, screenshots, screencasts and interactive test … Continue reading
Posted in MTA 98-364
7 Comments
How to create a list of installed SQL Server instances on a cluster
On a normal server, there are several Powershell ways to get a list of all installed SQL instances. Probably the most straightforward way is to query the registry:
1 2 |
Get-Itemproperty -path 'HKLM:\software\microsoft\Microsoft SQL Server' ` | Select-Object -expandproperty installedinstances |
You can subsequently use the output to query all instances on … Continue reading
Posted in Powershell
Leave a comment