Recently, I had a couple colleagues tell me that their PowerShell code sucks. One of them is a beginner who manages a large SharePoint farm and the other is more advanced and wrote a few commands that saves me hours of work each week. See the disconnect there? Their PowerShell code, which helps manage Enterprise …
Read MoreYesterday, I presented at PSPowerHour and during my intro, my iPad's volume turned up so I got distracted when talking about something that really meant a lot to me. And I'm a bit bummed that I wasn't able to properly convey how much it meant that I was awarded as a PowerShell Community Hero earlier this year. I was …
Read MoreToday'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 my buddy and YouTube star Bert Wagner (blog | twitter), is all about the SQL Server …
Read MoreToday'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 Ewald Cress (blog | twitter), is all about people who have made a difference in our …
Read MoreRecently, PASS announced their first round of speakers for Summit 2017 speakers and I'm on the list! I'm particularly excited because Summit is the largest SQL Server event in the world and it's looking like PowerShell will be getting some great exposure this year. In addition to announcing that I'll be speaking, PASS …
Read MoreRecently, 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 the #1 PowerShell UserVoice request. We see that - we've heard you, The People …
Read MoreIf 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, the default, will solve the problem.
Read MoreToday'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 Koen Verbeeck (blog | twitter), is all about how technology has changed a lot in the …
Read MoreIn 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 …
Read MoreWe'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 …
Read More