November 9, 2016 at 10:05 pm
Comments posted to this topic are about the item SQL Server Powershell - Browsing the Instance
I used this article in MSDN: https://msdn.microsoft.com/en-us/library/hh213536.aspx
Interesting question and very good explanation, thanks Steve.
Interesting question and I guessed because I don't really use Powershell. Thanks, Steve.
Ed Wagner (11/11/2016)
Interesting question and I guessed because I don't really use Powershell. Thanks, Steve.
Yes, let's have more PS with SQL questions. I don't really use it either, but it would be good to understand it. But this one was easy to get right.
It seems to me that PS ISE can't use shared store or named pipes, only tcp/ip (and maybe also http/https connections to SQL Server) but I may have that completely wrong - so I have to specify the server name even when it's the server PS ISE is running on. That strikes me as a nuisance, although I might have had a different view if it had been around in the years (2002 to 2005) when I was developing the initial Neos strategy for managing lots of remote servers running SQL. (and it also seems to me that PS as opposed to PS ISE is not very interesting - because I can't see anyway of doing anything much without ISE - including I can't see how this question works unless it assumes ISE).
Tom
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy