Printed 2015/10/09 12:51AM

T-SQL Tuesday #39 – Wrapup

By Wayne Sheffield, 2013/02/19

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) 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) 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) 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) blogged on using PowerShell with the Amazon Web Services (AWS) SDK to push database backups into the cloud.

Jeffrey Verheul (@DevJef) posted seeing various objects in your database, creating databases, and starting PowerShell from SSMS.

Kendal Van Dyke (@SQLDBA) 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) shows us how to use PowerShell to deploy SSRS artifacts.

Rob Farley (@rob_farley) 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 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 provides us with a PowerShell script to reach out to all SQL Servers and get the members of roles.

Jim McLeod provides a neat PowerShell script for sorting clipboard data… such as sql server names.

Patrick Keisler 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) 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 compares multiple ways of performing the same TSQL task from PowerShell.

Mike Fal shows off a PowerShell script to automate multi-node cluster installations – all with increased tea time in mind!

Mike Donnelly utilizes the new Backup-SqlDatabase cmdlet in SQL 2012 to perform simple backups of SQL databases.

Allen White (@SqlRunr) 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 – 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 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) shares a PowerShell script that will script out all SQL Server Agent Jobs.

Ben Miller (@DBADuck) shows us how using Server.SetDefaultInitFields can help SMO be more efficient with getting data with PowerShell.

Steve Jones (@way0utwest) shows us how to work with FileStream files with PowerShell.

Copyright © 2002-2015 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.