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

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 is well on its way to becoming proper citizens in the PowerShell world, and we'll reach …

I am still so floored by the additions and enhancements made to the module formerly known as SQLPS, now known as SqlServer. Not only do the new additions bring the total number of cmdlets from 46 to 71, but they align what we voted for on the Trello board. That's a 54% increase in the number of cmdlets! We'll be up to …

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. sp_help_revlogin is now old enough to drive a car By now in your career, you may have needed to migrate a few databases and …

I always forget how to do this, and Aleksandar Nikolić posted a really beautiful answer on Powershell.com For a file: 1-split (Get-Content .\test.txt | Out-String) | 2Where-Object { $_ -eq "test" } | Measure-Object | 3Select-Object -exp count For a string: 1$html.content -split …

Earlier this week, I was trying to determine people's feelings about Microsoft Connect by looking through social media. A few scrolls down, I noticed that Aaron Bertrand mentioned how easy it is to stumble across a Connect item years later and not know when it was finally closed as fixed. That resonated with me. That …

The other week, I was introduced to Trello for the first time when Nick Craver shared a link to his public Trello board, and I fell in love. Basically, Nick uses Trello to gauge what people would like to hear about on the Stack Overflow blog. You can see his board here. Later on when trying to figure out how to best …

In my previous blog post "Can We Get These 3 SQLPS Issues Fixed before SQL Server 2016 RTMs?", Aaron Nelson and I asked the SQL and PowerShell community to help upvote 3 SQL Connect items. The items addressed three problems with SQL Server's PowerShell module, SQLPS. It took 3-5 seconds to load It changed the …