| $AvailableContexts = Get-AzContext -ListAvailable | |
| $AllSQLServers = foreach ($Context in $AvailableContexts) | |
| { | |
| $SqlServer = Get-AzSqlServer -DefaultProfile $Context | |
| if ($SqlServer) | |
| { | |
| $SqlServer | ForEach-Object { Add-Member -InputObject $_ -MemberType NoteProperty -Name Context -Value $Context } | |
| } | |
| $SqlServer |
| // This file was initially generated by Windows Terminal 1.2.2381.0 | |
| // It should still be usable in newer versions, but newer versions might have additional | |
| // settings, help text, or changes that you will not see unless you clear this file | |
| // and let us generate a new one for you. | |
| // To view the default settings, hold "alt" while clicking on the "Settings" button. | |
| // For documentation on these settings, see: https://aka.ms/terminal-documentation | |
| { | |
| "$schema": "https://aka.ms/terminal-profiles-schema", |
| ## Function to generate a random word of a fixed or random length | |
| function Get-RandomWord | |
| { | |
| [CmdLetBinding()] | |
| param | |
| ( | |
| # Include diacritical letters | |
| [Parameter(Mandatory = $false)] | |
| [switch] $IncludeDiacriticalLetters, |
People
 :bowtie: |
😄 :smile: |
😆 :laughing: |
|---|---|---|
😊 :blush: |
😃 :smiley: |
:relaxed: |
😏 :smirk: |
😍 :heart_eyes: |
😘 :kissing_heart: |
😚 :kissing_closed_eyes: |
😳 :flushed: |
😌 :relieved: |
😆 :satisfied: |
😁 :grin: |
😉 :wink: |
😜 :stuck_out_tongue_winking_eye: |
😝 :stuck_out_tongue_closed_eyes: |
😀 :grinning: |
😗 :kissing: |
😙 :kissing_smiling_eyes: |
😛 :stuck_out_tongue: |
| using namespace System.Management.Automation.Host | |
| function Switch-AzContext | |
| { | |
| [CmdLetBinding(DefaultParameterSetName = 'By Context')] | |
| param ( | |
| [Parameter(ParameterSetName = 'By Name')] | |
| [Alias('Context', 'ContextName')] | |
| [ValidateNotNullOrEmpty()] | |
| [ArgumentCompleter( { |
| <# | |
| .SYNOPSIS | |
| Gets row count difference. | |
| .DESCRIPTION | |
| Gets row count difference between two identical databases from two different servers. | |
| .PARAMETER Server1Name | |
| Specify Server1 name, this is a mandatory parameter. |
| $web = New-Object System.Net.WebClient | |
| $web.UseDefaultCredentials = $true | |
| $web.Proxy.Credentials = $web.Credentials | |
| $web.DownloadString("https://pomber.github.io/covid19/timeseries.json") | ConvertFrom-Json | ForEach-Object India | Select -Last 1 |
| $web = New-Object System.Net.WebClient | |
| $web.UseDefaultCredentials = $true | |
| $web.Proxy.Credentials = $web.Credentials | |
| $web.DownloadString("https://pomber.github.io/covid19/timeseries.json") | ConvertFrom-Json | ForEach-Object India | Select -Last 1 |
| Function Copy-AzNSGRules | |
| { | |
| <# | |
| .SYNOPSIS | |
| Copies Azure NSG security rules from one NSG to another | |
| .DESCRIPTION | |
| Copies all the Azure Network Security Group security rules |
