Category Archives: Powershell
-
Learning Powershell with Show-Command
4July 11, 2019 by Kenneth Fisher
Years ago I blogged about how I like to use the SSMS scripting feature to learn how to do things. …
Continue reading -
Making music with Powershell
5December 20, 2017 by Kenneth Fisher
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing …
Continue reading -
Turn on/off Azure VMs with Powershell
1September 12, 2017 by Kenneth Fisher
T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked …
Continue reading -
Running multiple queries at the same time.
8May 24, 2017 by Kenneth Fisher
I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at …
Continue reading -
A detailed view into your Azure resources
Leave a commentJanuary 5, 2017 by Kenneth Fisher
I’ve been studying Azure recently and came across a really interesting Azure site. resources.azure.com To give you an idea why …
Continue reading -
A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup
Leave a commentDecember 26, 2016 by Kenneth Fisher
I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery …
Continue reading -
Powershell script to create multiple SQL Server Connections
1February 24, 2016 by Kenneth Fisher
As with most of these types of things, I had a need. I want to show how using sys.dm_exec_[requests/sessions/connections] is …
Continue reading -
Running Powershell scripts remotely.
2April 29, 2015 by Kenneth Fisher
I’ve only recently started to play with Powershell (PoSH) but even I’ve begun to discover what a huge number of …
Continue reading -
SQL Judo’s Monthly Challenge – March 2014 – Powershell something
4March 2, 2015 by Kenneth Fisher
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
Continue reading
