Category: PowerShell

Even faster PowerShell module loading

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 taken multiple approaches to reduce the import

Posted in PowerShell

your code doesn’t suck

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

Posted in PowerShell

a huge thanks

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.

Posted in PowerShell

T-SQL Tuesday #104: Code I Would Hate To Live Without

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

Posted in PowerShell, SQL Server

TSQL Tuesday #96: Folks Who Have Made a Difference

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

Posted in PowerShell, SQL Server

SQL PowerShell Pros: Submit Your Abstracts for PASS Summit!

Recently, PASS announced their first round of speakers for Summit 2017 speakers and I’m on the list! I’m particularly excited because Summit is the largest SQL Server event in the world and it’s looking like PowerShell will be getting some

Posted in PowerShell, SQL Server

PowerShell Gallery Metapackages

Recently, I was approached by supa-famous Joey Aiello of the PowerShell team at my favorite conference ever, PSConf.eu. So Joey comes up and says “Chrissy, Aaron Nelson has pretty much required me to talk to you. The SQL Community has

Posted in Linux, PowerShell, SQL Server

SSMS Complains of “Inconsistent Line Endings” with PowerShell Output

If you’ve used Out-File, Set-Content or Add-Content to create a SQL file, you may notice that SQL Server Management Studio complains about normalizing the line breaks. If you see this, simply using -Encoding UTF8 for your output instead of ASCII,

Posted in PowerShell, SQL Server