Posted in Development, SQL Server 2017

SQL Server – TRANSLATE() function in SQL Server 2017

Hello Friends,

Wish you all a very Happy New Year 2018.

Please find the link of my first article of year 2018 at below link –

Posted in Azure VM, Development, Microsoft Azure, Windows Powershell

Microsoft Azure – How to check details about Azure VM sizes using PowerShell

In this blog we will discuss about how to check the details about Azure VM tiers and sizes.

Microsoft Azure has basically three tiers: Basic, Standard and Premium.

Difference between these two tiers are the features present in them for virtual machine like high availability, auto scale etc.

When we create the VM we need to select the size of VM from Basic or Standard tier as per the requirement of cores, memory, disk space etc… But when we create the VM using PowerShell we need to first check the options of sizes of virtual machine available.

To get the available sizes for Azure VM we need to write command –


It lists out all the sizes available to azure VM with detailed information like Cores, Memory etc. as shown in below image.


If we need to just check the name of instance sizes without need of detailed information we can write the command –

(Get-AzureRoleSize). InstanceSize


To check the detailed information about a specific VM size we just need to specify the name of instance size with command like –

Get-AzureRoleSize –InstanceSize Standard_G1


So, using these few cmdlets we can check the available VM sizes available before creating any virtual machine.

Posted in Development, Microsoft Azure, Windows Powershell

Microsoft Azure – How to get details about azure locations using PowerShell

Hello friends, when we create any virtual machine using management portal we need to select the location for cloud service and azure portal shows us list of available locations.


We just select the location we want and move further to next steps.

We can also do this same using PowerShell and we need to check the locations available to us using azure cmdlet.


It will return a lot of information about Azure location like –

What Virtual Machine different sizes are available for a particular location?

What type of storage account types are available?

So we will have detailed information for every location because not all locations/regions have all the features available and its helps to find out which location is best for our purpose based on the available features.


To display the names of available location we need to write cmdlet –

(Get – AzureLocation).DisplayName

It will display all the available location to your subscription and you can select the location of your choice based on the features available.


So friends, this is how we get detail information about the locations available in Azure.