Author: Chrissy LeMaire
Chrissy is a Cloud and Datacenter Management & Data Platform MVP who has worked in IT for over 20 years. She is the creator of the popular SQL PowerShell module dbatools, holds a master's degree in Systems Engineering and is coauthor of Learn dbatools in a Month of Lunches. Chrissy is certified in SQL Server, Linux, SharePoint and network security. You can follow her on Twitter at @cl.

URL Shortening/Redirects using GitHub Pages and Jekyll

Recently, I moved many of my blogs/shortlink domains to GitHub Pages. With that, the security of my sites increased dramatically, but I lost some functionality including search and 301 (Moved Permanently) Redirects using .htaccess, which I use extensively for shortlinks.

Posted in GitHub

Migrating my WordPress sites to GitHub Pages

After getting hacked one too many times, I’ve decided to move all of my blogs and URL-shortening sites from a Virtual Private Server to GitHub Pages. GitHub Pages are pretty awesome and I’m not using them to their fullest ability,

Posted in GitHub

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

My setup after a year of livestreaming

Back in January and February of 2019, I wrote couple posts that highlighted my journey into livestreaming on Twitch, from understanding the different services/platforms to the lighting I used. I then followed up in June with a post about what

Posted in Livestreaming

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