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.

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 reboot. It's basically a built-in service start retry. You can read more …

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 for the advertisement (?!) to be easily removed, it looks like the only solution is …

When performing file migrations, PowerShell's Copy-Item is not ideal. I've since forgotten the original reasons I concluded this with the rest of the Internet, but this quote from reddit covers it pretty well. The Copy-Item and Move-Item cmdlets are general purpose commands. They have the ability to handle many …

Back in January, I wrote an introduction to livestreaming titled My First Twitch Livestream Setup. In it, I created the how-to guide for getting started that I wish I had the day I found Twitch. It's now been a couple weeks and I'm becoming more acclimated to Twitch, though I still don't get emotes and would prefer if …

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 into streaming (I'm potatoqualitee on Twitch) as soon as I found the PowerShell Live Twitch …

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 speed of our import process. As outlined in the blog post decreasing module import times, we've …

Recently, I had a couple colleagues tell me that their PowerShell code sucks. One of them is a beginner who manages a large SharePoint farm and the other is more advanced and wrote a few commands that saves me hours of work each week. See the disconnect there? Their PowerShell code, which helps manage Enterprise …

Yesterday, I presented at PSPowerHour and during my intro, my iPad's volume turned up so I got distracted when talking about something that really meant a lot to me. And I'm a bit bummed that I wasn't able to properly convey how much it meant that I was awarded as a PowerShell Community Hero earlier this year. I was …

Today's blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. This month’s T-SQL Tuesday, hosted by my buddy and YouTube star Bert Wagner (blog | twitter), is all about the SQL Server …