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. …

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 - …

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 …

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. Runspaces took me from about 90,000 rows per second to 230,000 rows per …

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 everyone my name is Cláudio Silva, I'm a MS SQL Server DBA, and have worked with SQL …