TSQL2sday #94 Lets get all Posh!

 

Welcome to T-SQL Tuesday for September 2017!

tsql2sdayT-SQL Tuesday is a chance for you to join in the SQL Server community and write a blog post on a suggested topic. It makes for a great way to find a bunch of blog posts showing the same subject from many different viewpoints. Please join in and write a blog post, maybe it’s your first ever, maybe you haven’t blogged for a while but even if you blog every day come and join the party and share your knowledge.

To participate:

  1. Write a post on the topic below
  2. Schedule the post to go live on Tuesday, September 12th (between zero am and midnight, UTC)
  3. Include the TSQL Tuesday logo in the top of your post
  4. Link the post back to this one (it’s easier if you comment on this post and link it)
  5. Optional: Tweet a link to your post using the #tsql2sday hash tag on Twitter

Extra credit: if you’d like to host your own TSQL Tuesday in the future, read the full rules for info on how to sign up. Just like I did but don’t forget its your month!!

This month’s topic: Let’s get all Posh – What are you going to automate today?

PowerShellIt is no surprise to those that know me that I will choose PowerShell as the topic for this month. I am passionate about PowerShell because it has enabled me to have the career I have today and to visit numerous countries all around the world, meet people and talk about PowerShell. By my reckoning searching the TSQL Tuesday website it has been over 3 years since we had a topic specific to PowerShell. So I would like you to blog about PowerShell and SQL Server (or other interesting data platform products)

If you don’t know or use PowerShell GREAT! That’s awesome.

Please spend an hour or so with it and tell us how you got on and what and how you learned. Just like Erik and Brent did. You could install one of the community modules like dbatools, dbareports , SQLDiagAPI  or the Microsoft ones sqlserver or SSRS and try them out and tell us what you learned.

If you want help whilst doing this please make use of the #powershellhelp channel in the SQL Server Community Slack

This will be of so much benefit to all people who don’t use PowerShell and want to start to learn about it.

If you do use PowerShell and SQL then either tell the tale of the best thing you have automated or a beginners post to show people how to start using PowerShell. I have heard many stories and am looking forward to tales of

  • testing backups
  • doing migrations
  • resetting log shipping
  • creating things in the cloud and on premises
  • SQL on Linux with PowerShell on Linux
  • using Pester for testing
  • automating manual tasks
  • automating incident knowledge gathering
  • continuous integration and delivery

and many more. I will read all of them and do a write up of them later next week.

 

keep calm and powershell.jpg

72 thoughts on “TSQL2sday #94 Lets get all Posh!

  1. Pingback: Let’s All Get PoSh – What are you going to automate today for T-SQL Tuesday #094 – T-SQL Tuesday

  2. Pingback: Warning Handing in dbatools Automation Tasks - Centino Systems Blog

  3. Pingback: #TSQL2sDay – How SQLPackage.exe can spoil your deployment – SQLPlayer

  4. Pingback: Lets get all Posh! Log Shipping - SQL Stad

  5. Pingback: #tsql2sday – NuGet, Visual Studio, PowerShell & dbatools | Daniel's Knowledgebase

  6. Pingback: Importing Excel into SQL Server using PowerShell – No Column Name

  7. Pingback: T-SQL Tuesday #94 – PoSH Goes Dynamic – Deb the DBA

  8. Pingback: T-SQL Tuesday #94 – Embrace the Shell of Power! Get into Powershell with dbatools – MlakarTechTalk

  9. Pingback: TSQL2sday #94 - daily database copy using Powershell - dbatools

  10. Pingback: performing a migration with every commit: testing with pester and appveyor – dbatools

  11. Pingback: Do I Need to Master PowerShell? - by Kendra Little

  12. Pingback: PowerShell and BITS – nate_the_dba

  13. Pingback: T-SQL Tuesday #94: Lets get all Posh! - warren.estes

  14. Pingback: Let’s All Get PoSh – What are you going to automate today for T-SQL Tuesday #094 – T-SQL Tuesday

Please feel free to comment on this post. All comments are moderated first before appearing on the site