SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Shawn Melton / PowerShell Basics / Latest Posts

RE: PowerShell Basics

cdonlan 18448 — Mon, 25 Feb 2013 09:03:34 GMT

Nice article, I'm a recent fan of PowerShell. I didn't know about the ISE. I found a use for it beyond metrics and administration that other DBA's might find useful: data traffic. I route a large chunk of our EDI traffic (text files mostly) into filetables with it. The script opens the file, reads what it needs, makes the necessary db calls, logs it, and moves it to point B. In the past I would have considered a CLR routine, but now I find myself asking myself if I can do it in PowerShell first.

RE: PowerShell Basics

michael sorens — Fri, 22 Feb 2013 06:36:07 GMT

Nice introduction to PowerShell! For a bit more geared toward those interested in SQL Server and PowerShell, I wrote a two-part introduction entitled [b]Practical PowerShell for SQL Server Developers and DBAs[/b] that shows, among other cool features, how to navigate in "SQL space" just like you can navigate in a file system. See [url]https://www.simple-talk.com/sql/database-administration/practical-powershell-for-sql-server-developers-and-dbas-%E2%80%93-part-1/[/url]

RE: PowerShell Basics

Abi Chapagai — Mon, 24 Jan 2011 12:44:55 GMT

Shawn:Thanks for the great article.

RE: PowerShell Basics

Shawn Melton — Mon, 24 Jan 2011 09:40:32 GMT

[quote][b]Adam Sottosanti (1/24/2011)[/b][hr]Thanks for the article Shawn. This is really helpful, I appreciate all the links you've provided as well.[/quote]You are welcome...here is one I left out cause I did not know if the link would stay active or not:[url=http://www.bing.com/browse?g=powershell_cmdlets&ve=dataset-%280011%29&qpvt=PowerShell&FORM=Z7FD#toc=0]Bing Visual Search - PowerShell[/url]If the link does not work, just go to http://www.bing.com search for just "PowerShell". You should see a tab show up under the search box called "Visual Search". It is a cool little graphical tool Bing created to browse the major commands and show some syntax.

RE: PowerShell Basics

Shawn Melton — Mon, 24 Jan 2011 09:37:40 GMT

[quote][b]parcival (1/24/2011)[/b][hr]Thanks Shawn. I have yet to use Powershell but this article has been a timely prompt.[/quote]Thanks, I wish my current job required me to use it more than I do. :hehe:

RE: PowerShell Basics

Adam Sottosanti — Mon, 24 Jan 2011 09:19:25 GMT

Thanks for the article Shawn. This is really helpful, I appreciate all the links you've provided as well.

RE: PowerShell Basics

parcival — Mon, 24 Jan 2011 07:39:11 GMT

Thanks Shawn. I have yet to use Powershell but this article has been a timely prompt.

PowerShell Basics

Shawn Melton — Sat, 22 Jan 2011 11:59:46 GMT

Comments posted to this topic are about the item [B]PowerShell Basics[/B]