Use SQL Server PowerShell Provider for Fun and Profit

Summary: Guest blogger, Mike Fal, talks about leveraging the SQL Server PowerShell provider. Microsoft Scripting Guy, Ed Wilson, is here. Welcome back guest blogger, Mike Fal. He blogged yesterday (see Getting Information from the SQL Server Provider with PowerShell), and he continues today… In my previous post, I covered how to gather and view data…


PowerTip: Use PowerShell to Find Versions of SQL Server

Summary: Use Windows PowerShell to find versions of SQL Server.  How can I use Windows PowerShell to see all the versions of SQL Server I have installed?  Use the provider and a list of instances to look them up as if they were files in a directory: $instances = @(‘KIRK’,’SPOCK’,’PICARD’,’RIKER’) $instances | ForEach-Object {Get-Item “SQLSERVER:\SQL\$_\DEFAULT”}…


Getting Information from the SQL Server Provider with PowerShell

Summary: Guest blogger, Mike Fal, talks about using the SQL Server provider with Windows PowerShell. Microsoft Scripting Guy, Ed Wilson, is here. We have a new guest blogger today. Please welcome Mike Fal. Mike Fal. Mike has over 15 years of experience as a database administrator. He has worked for many different industries, including healthcare,…


PowerTip: Use PowerShell to List all Azure Subscription Websites

Summary: Use Windows PowerShell to list all of your Azure subscription websites.  How can I use Windows PowerShell to list all the websites in my Azure subscription that are using the new preview module?  After you have authenticated (Add-AzureRmAccount), run: Get-AzureRmResource -ResourceType Microsoft.Web/sites


Use PowerShell to Scale Azure Websites

Summary: Anders Wahlqvist talks about using Windows PowerShell to scale Azure websites. Microsoft Scripting Guy, Ed Wilson, is here. Today we have a guest post from Anders Wahlqvist. Anders is really active on Twitter—as a matter of fact, that is where we met. I saw references to his blog, read it, and found that he…


PowerTip: Encode String and Execute with PowerShell

Summary: Learn how to encode a string into base64 and execute it with Windows PowerShell.  How can I encode a string into base64 and then run it via Windows PowerShell?  Use these commands: $string = {(Get-WindowsFeature).Where{$PSItem.Installed}}.ToString() $encodedcommand = [Convert]::ToBase64String([Text.Encoding]::Unicode.GetBytes($string)) powershell.exe -EncodedCommand $encodedcommand


Using WinRM on Linux

Summary: Microsoft MVP, David O’Brien, talks about using the pywinrm module to execute Windows PowerShell from Linux. Microsoft Scripting Guy, Ed Wilson, is here. Today Windows PowerShell MVP, David O’Brien, talks about executing Windows PowerShell on Linux. Hi. I’m David O’Brien, Microsoft MVP for Windows PowerShell, and I was asked by Ed if I wanted…


PowerTip: Use PowerShell Get-Command to Show Syntax

Summary: Use the Windows PowerShell Get-Command cmdlet to show syntax of cmdlets.  How can I use Windows PowerShell to explore the allowed syntax for a specific cmdlet?  Use the Get-Command cmdlet, and use the –syntax switch, for example: Get-Command Get-WinEvent -Syntax


Spelunking with Show-Object

Summary: Guest blogger, Tim Warner, talks about using the Show-Object cmdlet. Microsoft Scripting Guy, Ed Wilson, is here. Today I have another guest post by Tim Warner. By the way, you can meet Tim and other PowerShell enthusiasts at the Nashville PowerShell user group meeting on Wednesday, October 28. I will be there making the…


PowerTip: Group PowerShell Cmdlet Count by Version

Summary: Learn how to group Windows PowerShell cmdlet counts by version.  How can I see the version of the modules that contain various cmdlets in Windows PowerShell 5.0?  Use the Get-Command cmdlet to return all of the cmdlets, and then pipe the results to the Group-Object            cmdlet and group and sort by version. gcm |…