Write-Output "What are you going to automate today?"
Welcome to T-SQL Tuesday for September 2017!
To participate:
- Write a post on the topic below
- Schedule the post to go live on Tuesday, September 12th (between zero am and midnight, UTC)
- Include the TSQL Tuesday logo in the top of your post
- Link the post back to this one (it’s easier if you comment on this post and link it)
- 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?
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.
Invoke-Coffee Start-BlogWriting -Title 'Cool PowerShell Post' Get-BlogProofRead Post-Blog -Date ‘September 12th 2017’ -Title 'Cool PowerShell Post' Write-Tweet -Hashtag ‘TSQL2sday’ -Message 'This is my cool blogpost'