First an apology, this round up is late!
The reason for that is an error in the PowerShell testing module Pester (That’s not completely true as you shall see!!)
I spoke in Stuttgart at the PowerShell Saturday last weekend and had intended to write this blog post whilst travelling, unfortunately I found a major error in Pester (again not strictly true but it makes a good story!!)
I explained it with this slide in my presentation
Yep, I forgot to pack my NUC with my VMs on it and had to re-write all my demos!!
But anyway, on to the TSQL2sDay posts
Ah #tsql2sday – It seems you have gone a little bit posh! pic.twitter.com/bPqu4p1w7D
— Rob Sewell (@sqldbawithbeard) September 12, 2017
What a response. You wonderful people. I salute you with a Rimmer salute
There are 34 TSQL2sDay posts about dbatools, about starting with PowerShell, If you should learn PowerShell, SSAS, SSRS, Log Shipping, backups, restores, Pester, Default settings, best practices, migrations, Warnings in Agent Jobs, sqlpackage, VLFs, CMS, Disabling Named Pipes, Orphaned users, AG Status, AG Agent Jobs, logging, classes, auditing, copying files, ETL and more.
I am really pleased to see so many first timers to the TSQL2sDay blog monthly blog party. Please don’t let this be your only TSQL2sDay post. Come back next month and write a post on that topic.
Here they are below in the media of tweets, so that you can also go and follow these wonderful people who are so willing to share their knowledge. Say thank you to them, ask them questions, interact.
Learn, Share, Network
An utterly awesome intro post to PowerShell by the fantastic @rob_farley
Thank you Sir.
bookmark this & send it to your friends#Tsql2sday https://t.co/fwUnxZCauY— Rob Sewell (@sqldbawithbeard) September 12, 2017
It's @cl the awesome @psdbatools founder showing how the community module performs a migration and tests it WITH EVERY COMMIT!! #tsql2sday https://t.co/PUI4XijyoE
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Take a look at how Shane imports Death,The Police, The Witches and A monkey … err ape into SQL Server #tsql2sday https://t.co/ZnwDLv2mwW
— Rob Sewell (@sqldbawithbeard) September 12, 2017
another 1st time #tsql2sday blogger – Craig posts about using the SSRS module https://t.co/Sf8EJEnr7M
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Storm the castle! (you'll have to read the post)@SQLSoldier via @SQLBestPractice shows how to ease the pain of AG Agent Jobs #tsql2sday https://t.co/zciKnk6OH4
— Rob Sewell (@sqldbawithbeard) September 12, 2017
#Tsql2sday – Deleting SSAS Cube Partitions Using PowerShell and AMO – bzzzt! https://t.co/xfKbXYWBi7 via @bzzzt_io
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Do I Need to Master PowerShell? via @Kendra_Little for #tsql2sday https://t.co/BGjuV7IUnj
— Rob Sewell (@sqldbawithbeard) September 15, 2017
#tsql2sday Warning Handling in dbatools Automation Tasks https://t.co/6h7gRSIUlC via @nocentino
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Automate Migrations–T-SQL Tuesday #94 https://t.co/1GZm2AluHe
— way0utwest (@way0utwest) September 12, 2017
#TSQL2sDay – Starting Out with PowerShell https://t.co/cOhfMC129O pic.twitter.com/74fw40lmm6
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Another #tsql2sday 1sttimer @danblank000 shows how he solved an infuriating problem with PowerShell https://t.co/DUEU2PRZpp
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Kenneth shows how to turn on and off Azure VMs with PowerShell https://t.co/gzqHafoRJo
— Rob Sewell (@sqldbawithbeard) September 15, 2017
Setting up Logshipping ias a whole lot easier now #tsql2sday https://t.co/gc2ISCWTVK
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Martin writes about a script he wrote for backup testing for #tsql2sday – The comparison vs assignment is a very good point for beginners https://t.co/5JOxEaD3wF
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Yet another #tsql2sday 1sttimer – Claudio writes about best practices adn how to test them with dbatools and Pester https://t.co/kpL5zHnng7
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Daniel (another #tsql2sday 1sttimer) – blogs about installing dbatools in Visual Studio to exclude tables from Scaffold-DbContext https://t.co/5c69uy2TWN
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Chris shares some of the many things he has done with PowerShell #tsql2sday https://t.co/VpS5BBEzeL
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Garry shows how to find commands in dbatools
AND
How to get all the VLF information for an estate into a csv #tsql2sday https://t.co/6fdH9bQ9dI— Rob Sewell (@sqldbawithbeard) September 12, 2017
Mark shows how to use CMS with PowerShell #tsql2sday https://t.co/LYQWoE2flV
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Raul shares his scripts to automate the creation of VMs #tsql2sday https://t.co/duvH4SNPO0
— Rob Sewell (@sqldbawithbeard) September 12, 2017
CK shares one of my favorite dbatools commands Test-DbaLastBackup #tsql2sday https://t.co/ohP1sQzR5D
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Deborah shows how she creates dynamic parameters in PowerShell #tsql2sday https://t.co/kRZJfCfl5y
— Rob Sewell (@sqldbawithbeard) September 12, 2017
#tsql2sday post: a #sqlserver DBA uses #powershell @cl @sqldbawithbeard @psdbatools @LaerteSQLDBA @SQLvariant https://t.co/TYMSfDH9lf
— Klaas Vandenberghe (@PowerDBAKlaas) September 12, 2017
another 1st time #tsql2sday blogger – Craig posts about using the SSRS module https://t.co/Sf8EJEnr7M
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Taiob shows how to easily get information about your SQL Instances that are in CMS with dbatools #tsql2sday https://t.co/17Z7yPeNlW
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Brian shows how to disable named pipes across many instances with PowerShell – Simple easy security fix #tsql2sday https://t.co/wjC6nZnzn3
— Rob Sewell (@sqldbawithbeard) September 12, 2017
T-SQL Tuesday #94 – Embrace the Shell of Power! Get into Powershell with dbatoolshttps://t.co/UtUnmQeUI0#tsql2sday #SQLServer @psdbatools
— Jeff Mlakar (@jmlakar) September 12, 2017
Bjoern refreshes his dev environment adn fixes his orphaned logins with dbatools and SQL Agent #tsql2sday https://t.co/EVgLGOeMFT
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Tracy shows how to check the status of AGs with PowerShell and SQL after patching #tsql2sday https://t.co/AZ6nFMFSrD
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Storm the castle! (you'll have to read the post)@SQLSoldier via @SQLBestPractice shows how to ease the pain of AG Agent Jobs #tsql2sday https://t.co/zciKnk6OH4
— Rob Sewell (@sqldbawithbeard) September 12, 2017
Volker wrote about testing best practices with dbatools
TSQL2sday #94 – SQL Server Best Practices Test with PowerShell dbatools #tsql2sday https://t.co/Og9Ygxy2iu pic.twitter.com/ls5SLcFrHG
— Volker Bachmann (@VolkerBachmann) September 12, 2017
Dave explains why PowerShell is so useful to him in his ETL processes
[blog] using PowerShell to replace SSIS as an ETL tool https://t.co/kWFQrQpmcL #TSQL2sDay #sqlblog
— Dave Green (@d_a_green) September 12, 2017
Steve writes about the time he has saved using PowerShell to automate restores and audit SQL Server instances
TSQL2sday #94–SQL Server and PowerShell #tsql2sdayhttps://t.co/C0LfzsE7ui
— Steve Thompson (@Steve_TSQL) September 12, 2017
Nate talks about copying large files like SQL Server backups using BITS with PowerShell
My #tsql2sday entry, because we all know the UTC deadline is a myth =P https://t.co/9zGvfCOBpg #sqlblogs #sqlfamily @natethedba
— Nate Johnson (@NJohnson9402) September 13, 2017
Warren talks about his experience as a beginner, the amount of things he automates and his DBReboot module
new #sqlblog from yesterday's #tsql2sday #94 – lets get all posh. what i'm working on with powershell. https://t.co/7AlmuWoMev
— Warren Estes (@warren2600) September 13, 2017
THANK YOU every single one and apologies if I have missed anyone!