- Code signing your scripts, modules and applications can help increase enterprise adoption, as large organizations often prohibit running unsigned tools on Windows. Signed code allows machines to verify that what they're running hasn't been altered or compromised by a third party, which ultimately increases their …
Read More Years ago before I learned PowerShell, I was using T-SQL to do things it just wasn't meant to do, namely SQL Server estate management. T-SQL is incredibly efficient when managing data, but it's not very efficient when managing SQL Server instances.
For example, say you need to perform a task against each database. The …
Read MoreThis post is about Import-DbaCsv, a command within the dbatools PowerShell module for SQL Server.
I've been writing about CSV imports using PowerShell for a pretty long time and in VBScript for even longer. Initially, my primary concerns were ease-of-use and speed. Over time, I realized that what mattered most was: …
Read MoreIf you're curious about the
$Env:PSModulePathfor GitHub Runners, here's what I came up with after running a workflow.Knowing the
$Env:PSModulePathof each runner can be useful for making specific types of GitHub Actions. I used it within my own GitHub Action, psmodulecache which makes caching PowerShell modules from …
Read MoreAfter 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 was disappointed when I found out I'd have to run a specific version of Windows …
Read More- 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.
Read More - 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 …
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.
<img loading="lazy" decoding="async" alt="" class="image_figure image_internal …</picture></figure></p>
Read MoreWhen performing file migrations, PowerShell's
Copy-Itemis 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 …
Read MoreBack 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 …
Read More