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.

<img
  loading="lazy"
  decoding="async"
  alt="" …</picture></figure></a></p>

About a month ago, my beloved Thunderbolt display began buzzing. After some research, it seemed that there could be all sorts of solutions. The one that seemed to almost always work was sending off the monitor to get the power supply fixed.

Apparently, there's an issue with the power supply that can be confirmed if you …

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 …

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 ;))

1Get-Command -Module dbatools -CommandType Function | 
2ForEach-Object { $_.Parameters.Values.Name } |
3Sort - …

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 you located?

Belgium, land of the free, home of the beer. Also home of the Belgian PowerShell User …

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?

 1if ($state -eq -1)
 2{
 3    $diskstate = "Unknown"
 4}
 5elseif ($state -eq 0)
 6{
 7    $diskstate = "Inherited"
 8}
 9elseif …

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 with GitHub.

I love the command line, but with Git? I …

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 the results from the runspace to the host -- usually I just needed commands to run in the …