Troubleshooting network/cert connections

 Check your Chrome/Firefox params:

https://1.1.1.1/help

https://dnsviz.net/d/indysoft.com/dnssec/

https://dnssec-debugger.verisignlabs.com/

install oh-my-posh

 choco install oh-my-posh -y

choco install microsoft-windows-terminal -y

choco install nerd-fonts-3270 -y

choco install nerd-fonts-meslo -y

Add-MpPreference -ExclusionProcess oh-my-posh.exe

Set-Content -Path $profile -Value 'oh-my-posh init pwsh | Invoke-Expression'

Get-Content $profile

Start-BitsTransfer "https://github.com/ryanoasis/nerd-fonts/releases/download/v2.1.0/Meslo.zip" -Destination c:\temp\meslo.zip

Start-BitsTransfer "https://github.com/microsoft/cascadia-code/releases/download/v2111.01/CascadiaCode-2111.01.zip" -Destination c:\temp\CascadiaCode-2111.01.zip

Expand-Archive C:\temp\meslo.zip -DestinationPath C:\temp\Fonts

Expand-Archive C:\temp\CascadiaCode-2111.01.zip -DestinationPath c:\temp\cascadia\

Check what permissions are assigned to Azure SQL database

 

SELECT DP1.name AS DatabaseRoleName,   

    isnull (DP2.name, 'No members') AS DatabaseUserName   

FROM sys.database_role_members AS DRM  

RIGHT OUTER JOIN sys.database_principals AS DP1  

    ON DRM.role_principal_id = DP1.principal_id  

LEFT OUTER JOIN sys.database_principals AS DP2  

    ON DRM.member_principal_id = DP2.principal_id  

WHERE DP1.type = 'R'

ORDER BY DP1.name;

Find what process is listeninig on specific port using Powershell

 get-nettcpconnection | where {($_.State -eq "Listen")} | select LocalAddress,LocalPort,RemoteAddress,RemotePort,State,@{Name="Process";Expression={(Get-Process -Id $_.OwningProcess).ProcessName}} | ft 

get-nettcpconnection | where {($_.State -eq "Listen") -and ($_.LocalPort -eq "80")}  | select LocalAddress,LocalPort,RemoteAddress,RemotePort,State,@{Name="Process";Expression={(Get-Process -Id $_.OwningProcess).ProcessName}} | ft