PowerShell | netnerds.net

Category: PowerShell

PowerShell Gallery Metapackages

Posted on May 9, 2017 by

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

Posted on April 13, 2017 by

Chrissy LeMaire — No Comments ↓

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

Posted on April 11, 2017 by

Chrissy LeMaire — No Comments ↓

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

Loading SMO in Your SQL Server-centric PowerShell Modules

Posted on December 23, 2016 by

Chrissy LeMaire — 5 Comments ↓

In a recent version of PowerShell, Publish-Module, which publishes modules to the Gallery began requiring fully qualified Assembly names such as “Microsoft.SqlServer.Smo, Version=$smoversion, Culture=neutral, PublicKeyToken=89845dcd8080cc91”. Previously, it was sufficient just to use short names such as Microsoft.SqlServer.Smo. This had similar…

Posted in PowerShell, SQL Server

Find Every Parameter for Every Command in a PowerShell Module

Posted on December 20, 2016 by

Chrissy LeMaire — No Comments ↓

We’re currently working on standardizing our documentation for dbatools and I needed a list of all of the parameters we use. Here’s how I did it (well, I did it an uglier way then Aaron made it prettier ;)) Get-Command…

Posted in PowerShell

dbatools to the backup/restore rescue

Posted on December 13, 2016 by

Chrissy LeMaire — 1 Comment ↓

Posted in PowerShell, SQL Server

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