Category Archives: Learn_Powershell

Most common challenges and solution with Availability group listener and multisubnetfailover

Posted on June 19, 2017 by vijred

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 on April 20, 2017 by vijred
Posted in Learn_Powershell, Powershell, Productivity, Uncategorized | Tagged | Leave a comment

PowerShell06- PowerShell result display options

Posted on March 16, 2015 by vijred

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

Posted on March 9, 2015 by vijred

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

Posted on March 2, 2015 by vijred

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

Posted on February 23, 2015 by vijred

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

Posted on February 16, 2015 by vijred

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

LearnPowerShell 01 – Basics for first time PowerShell users

Posted on February 9, 2015 by vijred

Installation: PowerShell is expected to be installed on your Windows-7/ Windows-8 machine by default. If not already installed, use instructions at https://technet.microsoft.com/en-us/library/hh847837.aspx to install PowerShell. How to Open (Powershell/ Powershell ISE): Run Powershell / Powershell_ISE commands to start using PowerShell … Continue reading →

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

Learn PowerShell in 2015

Posted on February 2, 2015 by vijred

Scripting and Automation is one of my personnel interest and PowerShell is the right match! I have been using PowerShell for years but I always go back and refer the documentation when I have to implement something. I made a … Continue reading →

Posted in Learn_Powershell, Powershell | Tagged | Leave a comment