Last week, I hosted the T-SQL Tuesday blogging party event, and the topic was on how do you use PowerShell with SQL. We had a pretty good turnout with 22 blog posts, and here is the recap of our party (if I missed you, please post a comment and I’ll add it to here):
Rick Krueger (@DataOgre) http://www.dataogre.com/2013/02/12/powershell-just-bring-it-tsql2sday/ shows us how to use PowerShell to establish connections between multiple SQL Servers and loop through tables on each connection – and he manages to tie The Rock in to all of this!
Jason Strate (@StrateSQL) http://www.jasonstrate.com/2013/02/t-sql-tuesday-powershell-and-perfmon-results-tsql2sday/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+StrateSql+%28Strate+SQL%29 uses PowerShell to process PerfMon-generated counter files and exports them as name-value pairs for processing in Excel or SQL Server.
Hamanth.D (@SqlChow) http://sqlchow.wordpress.com/2013/02/13/t-sql-tuesday-39-getting-installed-instances-querying-logs/ posted not one, not two, but three scripts to 1. Get the installed SQL Instances on a computer, 2. Read the SQL Server error logs using SMO, and 3. Querying the Windows event log for errors.
Matt Velic (@mvelic) http://mattvelic.com/tsql-tuesday-39/ blogged on using PowerShell with the Amazon Web Services (AWS) SDK to push database backups into the cloud.
Jeffrey Verheul (@DevJef) http://devjef.wordpress.com/2013/02/12/t-sql-tuesday-39-can-you-shell-what-the-posh-is-cooking/ posted seeing various objects in your database, creating databases, and starting PowerShell from SSMS.
Kendal Van Dyke (@SQLDBA) http://www.kendalvandyke.com/2013/02/t-sql-tuesday-39-use-powershell-to-copy.html uses PowerShell to copy a database to a different instance.
Gabriel Villa (@extofer) has a link on twitter, but I couldn’t read it…
Dave Ballantype (@davebally) http://sqlblogcasts.com/blogs/sqlandthelike/archive/2013/02/12/deploying-ssrs-artefacts-using-powershell-simply.aspx shows us how to use PowerShell to deploy SSRS artifacts.
Rob Farley (@rob_farley) http://sqlblog.com/blogs/rob_farley/archive/2013/02/12/behind-the-scenes-of-powershell-and-sql.aspx investigates whether PowerShell has access to the SQL Server deep magic and finds out it’s all T-SQL behind the scenes – and sometimes it seems pretty inefficient.
Andy Levy http://therestisjustcode.wordpress.com/2013/02/11/t-sql-tuesday-39-heres-what-my-posh-is-cooking/ writes his “first official” T-SQL Tuesday blog post with a few PowerShell things that he uses to save time when working with SQL Server – things like disk space usage analysis, data dumps, migrating XML config files, and more!
Thomas Stringer http://sqlsalt.com/t-sql-tuesday-39-get-role-members-with-powershell/ provides us with a PowerShell script to reach out to all SQL Servers and get the members of roles.
Jim McLeod http://www.jimmcleod.net/blog/index.php/2013/02/12/t-sql-tuesday-39-powershell-sorts/ provides a neat PowerShell script for sorting clipboard data… such as sql server names.
Patrick Keisler http://www.patrickkeisler.com/2013/02/t-sql-tuesday-use-powershell-to-restore.html shares a PowerShell script to copy the most recent backup to another server and install it on a different server, along with the existing user permissions.
Alan Dykes (@dykesa) http://alandykes.com/2013/02/12/t-sql-tuesday-39-powershell-how-do-i-use-it/ provides a script to wrap stored procedure calls in PowerShell to bypass the JDBC connections and thus preventing The Shining from happening – as a bonus, he can parameterize the calls to allow for easier testing in different environments.
Chris Fraden http://www.fradensql.com/2013/02/t-sql-tuesday-multiple-ways-to-skin-a-cat/ compares multiple ways of performing the same TSQL task from PowerShell.
Mike Fal http://www.mikefal.net/2013/02/12/t-sql-tuesday-39-a-posh-post-tsql2sday/ shows off a PowerShell script to automate multi-node cluster installations – all with increased tea time in mind!
Mike Donnelly http://sqlmd.wordpress.com/2013/02/12/powershell-basic-sql-backup-t-sql-tuesday-39/ utilizes the new Backup-SqlDatabase cmdlet in SQL 2012 to perform simple backups of SQL databases.
Allen White (@SqlRunr) http://sqlblog.com/blogs/allen_white/archive/2013/02/12/t-sql-tuesday-39-managing-your-sql-server-services-with-powershell.aspx shares a set of PowerShell scripts to manage your SQL Server services. As you start working with Windows Core, this will become essential!
Jason Fay http://www.the-fays.net/blog/?p=274 – in his second TSQL2sday post, Jason shares a PowerShell script to change the SQL Server Service Account and/or Password on multiple servers in a flash.
Ana Mihalj http://amihalj.wordpress.com/2013/02/12/t-sql-tuesday-39-set-file-permission-with-powershell/ ran into an issue where the user account could not access the default trace files generated by SQL Server, and provides a PowerShell script to reset those file permissions.
John Samsom (@JohnSamsom) http://www.johnsansom.com/script-sql-server-agent-jobs-using-powershell/ shares a PowerShell script that will script out all SQL Server Agent Jobs.
Ben Miller (@DBADuck) http://dbaduck.com/2013/02/12/t-sql-tuesday-39-more-efficient-smo-with-server-setdefaultinitfields/ shows us how using Server.SetDefaultInitFields can help SMO be more efficient with getting data with PowerShell.
Steve Jones (@way0utwest) https://voiceofthedba.wordpress.com/2013/02/12/t-sql-tuesday-39-powershell/ shows us how to work with FileStream files with PowerShell.