A demo about the power of powershell

Question

A demo about the power of powershell

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Daniel Calbimonte SSCertifiable Points: 6292 More actions · Answer 1

Yes, PS is a great tool to interact with Exchange, AD and other sources.

To create Databases automatically with PS, it may be better to run .sql scripts from powershell.

This demo show a visible example. In real life, it is not recommended to create the databases this way, but the for-each, the get-content and the invoke-sqlcmd are really useful commands that I wanted to share with the world because I am pretty sure all will love them.

carl_corpus SSC Rookie Points: 44 More actions · Answer 2

Thanks mohammed!

Connection to SQLPS was the issue:Whistling:.

Regards.

Leon . Orlov . Ten Centuries Points: 1212 More actions · Answer 3

Powershell rocks! Great tool for auditing and keeping eye on your server farm.

LearnModeOn SSC Enthusiast Points: 154 More actions · Answer 4

I'm learning here...

I ran the example and here is what I found. The article shows echo $li which I believe is supposed to be echo $list.

I kept getting this "the term 'Invoke-SqlCmd'"... error, and read from a another user to type in sqlps. Once I did that the example worked.

So I learned a few new commands in power shell!

Thank you and keep the examples coming please.

select this!!

A demo about the power of powershell

Cookies on SQLServerCentral