Development · Microsoft Azure · Windows Powershell

Microsoft Azure – How to Check the availability of cloud services using PowerShell

Hello friends, in this blog we will learn how to check whether a cloud service is available to use with virtual machine or not. Cloud service is basically how to access virtual machine using virtual IP address (VIP). Cloud services can contain multiple virtual machine by creating cloud service first and then associate that public… Continue reading Microsoft Azure – How to Check the availability of cloud services using PowerShell

Development · Microsoft Azure · Windows Powershell

Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)

In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate the virtual machine (VM). So, to overcome this we can assign a reserved IP so that whenever we restart the virtual machine we would get the same IP. Microsoft Azure allows default 20 reserved IP… Continue reading Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)

Development · Microsoft Azure · Windows Powershell

Limitation of Virtual IP address (VIP) in Microsoft Azure – Part 1

Virtual IP (VIP) is a public IP address and created when a cloud service is created. A VIP is a public IP address that can be used to access Virtual machine in Azure. All VM in same domain name share a single VIP. By using a reserved IP address, you can ensure that the virtual… Continue reading Limitation of Virtual IP address (VIP) in Microsoft Azure – Part 1

Development · Microsoft Azure · Windows Powershell

Connect to Microsoft Azure Subscription using Windows PowerShell – Part 1

Hello friends, in this blog we will learn how we can connect to Azure Subscription using PowerShell. As you know we can also perform the operations from PowerShell window which we can do using management portal. We can connect to the Azure subscription from windows PowerShell in 2 ways: Importing license setting file Adding Azure… Continue reading Connect to Microsoft Azure Subscription using Windows PowerShell – Part 1

Development

How to backup local SQL database and restore to Azure SQL database

Hi friends, recently I was finding a way on taking backup of local database and restore that database to Azure SQL database. I found that there is new option available to generate the scripts for Microsoft SQL Azure database using Generate Scripts option. Let me walkthrough step by step on how we can take the… Continue reading How to backup local SQL database and restore to Azure SQL database

Development · Performance Tuning

How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool

Hi friends, We need to collect inventory for database migration as well as platform to set up environment for migration, development and testing. Is there any tool from Microsoft to achieve this scenario? Yes, we have Microsoft Assessment and Planning Tool (MAP) for it. From BOL: The Microsoft Assessment and Planning (MAP) Toolkit is an… Continue reading How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool

Development · Performance Tuning · Uncategorized

SQL Server Execution Plan formats

Execution plan helps in knowing how a query gets executed and troubleshooting a query which is performing poor. In SQL Server execution plan can be of 2 types: Estimated Execution plan Actual Execution plan Execution plan can be viewed in 3 different formats: Text format XML format Graphical format We can choose the format on… Continue reading SQL Server Execution Plan formats