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:PSModulePath
for GitHub Runners, here's what I came up with after running a workflow.Knowing the
$Env:PSModulePath
of 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-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 …
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 MoreBack 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 …
Read More