5 minute read

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

This is an embedded Microsoft Office presentation, powered by Office Online.

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!

Comments