Write-Output "What are you going to automate today?"
Welcome to T-SQL Tuesday for September 2017!
T-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:
- 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?
It 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.
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'
Keep calm and power on, would be a good one for major incidents 😁
Pingback: Let’s All Get PoSh – What are you going to automate today for T-SQL Tuesday #094 – T-SQL Tuesday
https://bzzzt.io/2017/09/11/t-sql-tuesday-deleting-ssas-cube-partitions-using-powershell-and-amo/
PowerShell and SSAS are also a winning combination!
Thanks Richie
I posted early because I thought yesterday was Tuesday… I blame lack of sleep from the newborn!
Thanks for hosting this month Rob, Rob. https://sqlperformance.com/2017/09/sql-performance/need-to-know-powershell
Thank you Sir. That’s an awesome post, just the sort I was hoping to get 🙂
Pingback: Warning Handing in dbatools Automation Tasks - Centino Systems Blog
Hey Rob – here’s my post – http://www.centinosystems.com/blog/sql/warning-handing-in-dbatools-automation-tasks/
Thank you Anthony 🙂
And here’s my piece for the action:
https://allthingspowershell.blogspot.com/2017/09/t-sql-tuesday-taking-pain-out-of.html
Or how dbatools accepts anything that can make a legal case for being input pointing at an instance.
Here is my post (which didn’t auto-link!!)
https://sqldbawithabeard.com/2017/09/12/tsql2sday-starting-out-with-powershell/
Hi Rob,
here’s my contribution to TSQL Tuesday:
http://www.martinguth.de/uncategorized/what-i-like-about-powershell/
Thank you Martin
Powershell and Log shipping, a winning combinations
https://www.sqlstad.nl/powershell/lets-get-all-posh-log-shipping/
Pingback: #TSQL2sDay – How SQLPackage.exe can spoil your deployment – SQLPlayer
Thank you Kamil
Hey Rob, thanks for hosting this month! Here is my contribution:
https://claudioessilva.eu/2017/09/12/someone-is-not-following-the-best-practices-dbatools-and-pester-dont-lie/
Thank you Claudio – dbatools and Pester – 2 of my favourite modules
Pingback: Lets get all Posh! Log Shipping - SQL Stad
Thank you Sander
Pingback: #tsql2sday – NuGet, Visual Studio, PowerShell & dbatools | Daniel's Knowledgebase
Awesome post Daniel – Thank you
Hey there Rob! Here’s my contribution 🙂
https://danielsknowledgebase.wordpress.com/2017/09/12/tsql2sday-nuget-visual-studio-powershell-dbatools/
Awesome post Daniel – thank you
https://www.powerdba.eu/blog/getpowershelled
Does a PowerDBA think you should use PowerShell as a DBA?
You get one guess 🙂
Thank you Klaas
Pingback: Importing Excel into SQL Server using PowerShell – No Column Name
Thank you Shane, for the puns and the Terry Pratchett. I appreciated that muchly
Thank you for hosting Rob. My favorite topic by far!
http://www.cjsommer.com/2017-09-11-tsql2sday-94-do-you-wanna-get-posh/
Thank you for your Post Chris – I’m so pleased there are so many fabulous posts
Here we go – http://blog.garrybargsley.com/dont-be-scared-of-powershell-just-get-dbatools/
Thank you Garry
My entry, somewhat generic with a lack of time, but here you go: https://voiceofthedba.com/2017/09/12/automate-migrations-t-sql-tuesday-94/
BTW, was sad to not see you in Cambridge this past weekend.
Thank you Sir.
Yes, Cambridge is a pain to get to from my place. I was sad to miss it
Pingback: T-SQL Tuesday #94 – PoSH Goes Dynamic – Deb the DBA
Thanks for the post Deb
Thanks for hosting! Here’s my post: https://wordpress.com/post/debthedba.wordpress.com/3980
Here’s my post Rob – https://craigporteous.com/2017/09/administering-ssrs-with-powershell/
Thank you Craig
Pingback: T-SQL Tuesday #94 – Embrace the Shell of Power! Get into Powershell with dbatools – MlakarTechTalk
Thanks Jeff
Here’s mine: http://www.mlakartechtalk.com/t-sql-tuesday-94-embrace-powershell-dbatools/
Thanks for hosting!
Thanks Jeff
Thank you for hosting and you support in slack channel. My post: http://sqlworldwide.com/tsql2sday-94-get-dbaregisteredservername-power-of-dbatools/
Thank you Taiob
Pingback: TSQL2sday #94 - daily database copy using Powershell - dbatools
Thanks Bjoern 🙂
Pingback: performing a migration with every commit: testing with pester and appveyor – dbatools
Oh yes – thank you so much dbatools (and Chrissy)
Thanks for hosts here is my contribution http://tracyboggiano.com/archive/2017/09/t-sql-tuesday-94/.
Thank you Tracy
T-SQLTuesday #94: Using Invoke-SQLCmd to run SQL Jobs Remotely https://sqlbp.com/sqlserver/tsqltuesday94usinginvokesqlcmdtorunsqljobsremotely/
Hello Rob, thanks for hosting. Here is my post: http://blog.volkerbachmann.de/2017/09/12/tsql2sday-94-sql-server-best-practices-test-with-powershell-dbatools/ 🙂
Thank you Volker
Pingback: Do I Need to Master PowerShell? - by Kendra Little
Here is my post! Thanks, Rob
https://littlekendra.com/2017/09/12/do-i-need-to-master-powershell/
Thank you Kendra
Here’s my post – Thanks for hosting, Rob. http://blog.dgta.co.uk/2017/09/using-powershell-to-drive-etl.html
Thank you Dave 🙂
My humble contribution: https://stevethompsonmvp.wordpress.com/2017/09/12/tsql2sday-94-sql-server-and-powershell/
Thank you Steve
I almost forgot to post my comment! Thanks for hosting, it’s been really good.
http://www.sqldoubleg.com/2017/09/12/t-sql-tuesday-94-lets-get-all-posh-creating-virtual-machines-with-ps/
Thank you Raul
Pingback: PowerShell and BITS – nate_the_dba
My humble entry… natethedba.wordpress.com/2017/09/12/powershell-and-bits/ Thank you for hosting! =)
or, properly, https://natethedba.wordpress.com/2017/09/12/powershell-and-bits/ !
Thank you Nate
Pingback: T-SQL Tuesday #94: Lets get all Posh! - warren.estes
late and understand if not applicable. forgot to publish last night 🙁
thanks for hosting and the posh idea!
https://www.warrenestes.com/t-sql-tuesday-94-lets-get-posh/
No worries Warren, thanks for your post
Pingback: Let’s All Get PoSh – What are you going to automate today for T-SQL Tuesday #094 – T-SQL Tuesday
Pingback: TSQL Tuesday #94 Get-DbaRegisteredServerName | Power of dbatools | SqlWorldWide