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, and holds a number of certifications, including those relating to SQL Server, Linux, SharePoint and network security. You can follow her on Twitter at @cl.

Tips on Speaking

I’ve been seeing quite a bit of posts about speaking mentorships and I wanted to share a few speaking tips I recently gave to my buddy Garry Bargsley who will be speaking about dbatools at SQL Saturday Phoenix 2018. The

Posted in General

SSH Tunneling for Windows: Protecting RDP using Windows 10 Fall Creators Update

NOTE: If you’re not yet using Windows 10 Fall Creators Update, please follow this article instead. The recent OS X High Sierra iamroot vulnerability reminded me just how many people don’t secure their remote desktop connections. While Windows Remote Desktop

Posted in Security, Windows

SSH Tunneling for Windows People: Protecting Remote Desktop

NOTE: If you’re using Windows 10 Fall Creators Update, please follow this article instead. The recent OS X High Sierra iamroot vulnerability reminded me just how many people don’t secure their remote desktop connections. While Windows Remote Desktop is more

Posted in Linux, Security, Windows

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

T-SQL Tuesday: The Cloud, Globalization and Automation

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