Category: PowerShell

My Windows Terminal Retro Theme

After reading a number of Windows Terminal posts by Thomas Maurer and seeing Windows Terminal Preview available in my Windows App Store, I finally decided to dive in again. I was sooo excited when Microsoft first made the announcement but

Posted in PowerShell, Windows

SQL Server Agent with CmdExec job runs PowerShell infinitely

Just ran into this issue and solved it by using powershell -ExecutionPolicy bypass C:\path\to\script.ps1. Seems there was an issue with the signed module so I just set it to not check the sign.

Posted in PowerShell

Windows Services Recovery for SQL Server

Recently, I ran into an issue after applying a few security updates and subsequent reboots: a number of the SQL services did not start successfully. After running the following script, I’ve had success with SQL services starting as expected after

Posted in PowerShell, SQL Server, Windows

Remove the new ad in PowerShell 5.1 on Windows 10

I really abhor the new ad in the PowerShell 5.1 console and it seems there’s no hope of Microsoft making it go away. After a long, involved Twitter conversation with the community and the PowerShell team that confirmed it’s impossible

Posted in PowerShell

Using robocopy to move SQL Server files

When performing file migrations, PowerShell’s `Copy-Item` is not ideal. Use robocopy with these parameters instead.

Posted in PowerShell, SQL Server

My Second Twitch Livestream Setup

It’s been about a month and I’m becoming more acclimated to livestreaming on Twitch. Here’s what I’ve learned.

Posted in Livestreaming, PowerShell

My First Twitch Livestream Setup

Back in December, I found Twitch and fell in love with livestreaming. It was amazing watching people code in PowerShell with blinged out profiles and cool cut screens. Whaaat, this is a thing? I love it! Getting started I jumped

Posted in Livestreaming, PowerShell

Even faster PowerShell module loading

Update: This method is faster but some anti-virus software hate it. I’ve since reverted our method of import to an all-in-one ps1 πŸ‘Ž Considering dbatools now has over 500 commands, we are always eager to keep an eye on the

Posted in PowerShell