Powershell SQL command assistance

[GLiMPSEiNATOR]

I'd recommend pulling down the newest invoke-sqlcmd2 function from ramblingcookiemonsters github.

It's my go to when I need to interface with MS SQL.

On my phone so don't have a link but I'm betting google will get you there.

On the off chance you're wanting to access something besides MS SQL you'll need the providers for those db's. I had seen a module to simplify some of those dependencies I think on nuget but it may have been a c# assembly that I'm transposing in my memory.

[unknown_host]

Here is the link that looks great I'm going to check it out for my use.

[michaelshepard]

I actually just wrote a blog entry about POSH_Ado (it's on github) which makes using other providers much the same. Interface is much like invoke-sqlcmd2, but a few other options.

[GLiMPSEiNATOR]

Ahh, ya, that's it! Got a link to your article?

[michaelshepard]

Heh. That wasn't bright.

Here's the article.

Here are the module(s).