Chrissy LeMaire

Author: Chrissy LeMaire

Chrissy is a PowerShell MVP who has worked in IT for nearly 20 years, and currently serves as a Sr. Database Engineer in Belgium. Always an avid scripter, she attended the Monad session at Microsoft’s Professional Developers Conference in Los Angeles back in 2005 and has worked and played with PowerShell ever since. Chrissy is currently pursuing an MS in Systems Engineering at Regis University and helps maintain RealCajunRecipes.com in her spare time. She holds a number of certifications, including those relating to SQL Server, SuSE Linux, SharePoint and network security. She recently became co-lead of the SQL PASS PowerShell Virtual Chapter. You can follow her on Twitter at @cl.

This is How I Work

Posted on December 8, 2016 by

Chrissy LeMaire — No Comments ↓

Inspired by Adam Bertram being inspired by Lifehacker’s How I Work series, I’m also doing a post about how I work ;) I really liked Adam’s balanced assessment so I decided to follow in his footsteps there, too. Where are…

Posted in General

PowerShell: Too Many If Elses? Use Switch.

Posted on December 7, 2016 by

Chrissy LeMaire — 1 Comment ↓

One of my favorite things in PowerShell (and other languages) is the switch statement. It’s clean and a much better alternative to a ton of if elses. Ever had this happen?

if ($state -eq -1)
{
    $diskstate = "Unknown"
}
elseif ($state -eq 0)
{
    $diskstate = "Inherited"
}
elseif ($state -eq 1)
{
    $diskstate = "Initializing"
}
elseif ($state -eq 2)
{
    $diskstate = "Online"
}

if ($state -eq -1)

{

$diskstate = "Unknown"

}

elseif ($state -eq 0)

{

$diskstate = "Inherited"

}

elseif ($state -eq 1)

{

$diskstate = "Initializing"

}

elseif ($state -eq 2)

{

$diskstate = "Online"

}

The better way to do it is by…

Posted in PowerShell

Immediately Output Runspace Results to the Pipeline

Posted on December 3, 2016 by

Chrissy LeMaire — No Comments ↓

In my previous post, I presented the template I use anytime I need to add multithreading to my scripts. Recently, I had a request to add multi-threading to Read-DbaBackupHeader. This was the first runspace in which I had to output…

Posted in PowerShell, SQL Server

Runspaces Simplified (as much as possible)

Posted on December 3, 2016 by

Chrissy LeMaire — No Comments ↓

Last year, I was looking into multi-threading in PowerShell and, with the help of Dr. Tobias Weltner, Boe Prox and Martin Pugh ultimately decided on runspaces. Then, I presented at psconf.eu about using runspaces to speed up SQL Server/CSV imports.…

Posted in PowerShell

Contributing to dbatools & dbareports using GitHub Desktop

Posted on December 3, 2016 by

Chrissy LeMaire — No Comments ↓

Repost from dbatools.io: Recently, I presented to the Philadelphia PowerShell User Group about Contributing to Open Source PowerShell projects using GitHub Desktop. I chose this topic because a number of people have asked for step-by-step instructions on how to work…

Posted in PowerShell, SQL Server

Share VPN with OS X Sierra Internet Sharing

Posted on November 24, 2016 by

Chrissy LeMaire — 1 Comment ↓

Here’s how I shared my Mac’s Freedome encrypted Shared Internet with my Roku, which is mostly based on this StackExchange post with some mods.

Posted in Networking, OS X & iPhone

Guest blogger Cláudio Silva: Why Expand-SqlTLogResponsibly?

Posted on July 20, 2016 by

Chrissy LeMaire — No Comments ↓

Hey yall! I invited one of the most active dbatools developers, Cláudio Silva, to do a guest post about his motivation for joining the team and why he built this particular command. So without further ado… here’s Cláudio :D Hi…

Posted in PowerShell, SQL Server

New PowerShell Commands from the SQL Server Team!

Posted on July 5, 2016 by

Chrissy LeMaire — No Comments ↓

Have you seen the SQL Server Tools team’s post about the PowerShell module for SQL Server? There are TWENTY FIVE new cmdlets! TWENTY FIVE! That’s a 53% increase over the previous 46 cmdlets. It looks like the SQL Server community…

Posted in PowerShell, SQL Server