Category Archives: Learn_Powershell

Most common challenges and solution with Availability group listener and multisubnetfailover

Industry started using SQL availability groups on most of their environments, DBA is coming across multiple issues related to AGListener connectivity. This blog explains 2 major challenges and solutions in detail: https://blogs.msdn.microsoft.com/alwaysonpro/2014/06/03/connection-timeouts-in-multi-subnet-availability-group/ I recommend option-1 to enable client to use … Continue reading

Posted in Learn_Powershell, SQL, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment

Powershell commands – my quick reference

Posted in Learn_Powershell, Powershell, Productivity, Uncategorized | Tagged | Leave a comment

PowerShell06- PowerShell result display options

PowerShell developers needs to analyze the commands and results many a time, it is good to know how the results can be formatted for better visibility. I will share few examples which can be used for reference… • Get-Process | … Continue reading

Posted in Learn_Powershell, Powershell | Tagged , , | Leave a comment

PowerShell05 – PowerShell Prompt

Many a time I work on different files in different folders and change the prompt to different location. The challenge is the available space to write commands on single line. For simplicity, I will share simple function to move the … Continue reading

Posted in Learn_Powershell, Powershell | Tagged , , , | Leave a comment

PowerShell04 – Pipeline, Filtering, Grouping and Sorting examples

Pipeline: PowerShell pipeline takes the output from one command and sends it as input to another command. Simple Example: Sorting CmdLet results: Sort-Object -Property XXX can be used to sort the results in output Example to sort process information based … Continue reading

Posted in Learn_Powershell, Powershell | Tagged , , , , | Leave a comment

PowerShell03 – PowerShell script basics

Windows PowerShell script is a collection of Windows PowerShell Cmdlets/Commands. PowerShell scripts can be executed like batch files and it can also be configured to run as scheduled task! I will share few basics to start with PowerShell Scripting… • … Continue reading

Posted in Learn_Powershell, Powershell | Tagged , , , | Leave a comment

Powershell02 – CmdLet Parameters, Variables

Cmdlets can accept parameters which can be used while processing cmdlets. I would like to talk about 2 types of parameters, Default parameters and named parameters • Default parameter: If the parameter is default parameter, you do not have to … Continue reading

Posted in Learn_Powershell, Powershell | Tagged , , , | Leave a comment