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 …

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 …

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 Twitter. A few scrolls down, and I came upon this

@Ms_Alaina My problem is I sometimes stumble upon a Connect item I filed in 2008, and have no idea when it was closed as fixed.

— Aaron Bertrand (@AaronBertrand) …

The other week, I was introduced to Trello for the first time by this tweet and I fell in love.

In case you missed it, here’s my Trello of upcoming “How Stack Overflow does X” blog posts, please vote or suggest! https://t.co/6E8JRb4RSu

— Nick Craver (@Nick_Craver) February 1, 2016

Basically, Nick uses Trello to …

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 …

In tonight's PowerScripting Podcast, I shared a few things about SQL Server on Linux, and talked a bit about SQLPS. All after a lengthy intro about my tech life and Cajun culture ;) You can watch the whole thing, skip to 28 minutes to the podcast intro, or skip to around 59 minutes for the SQL/Linux/SQLPS portion.

Or …

YES WE CAN! Microsoft responded and fixed these 3 major issues in SQL Server Management Studio March 2016 Refresh. Read more at "WE DID IT! Microsoft Fixed Those 3 SQLPS Issues in SQL Server 2016".

I'll be honest, I don't use the SQLPS module even though I'm the perfect candidate. I've been a SQL Server DBA …