Import Database schema in Azure SQL DB from .SQL files programmatically with SQLCMD

Introduction – This blog post illustrates the method through which you can import your database schema and tables into empty Azure SQL DB ( PaaS ) programmatically. Currently azure SQL DB support import from BACPAC file in PowerShell and GUI but not from .SQL files. Assumptions  – Here we assume that you already have .SQL…

0

Run two PowerShell scripts on a same VM through custom script extension at different stage of Deployment in ARM

Introduction – This blog post illustrates the method through which you can run two different PowerShell scripts on a same VM through custom script extension at different stages /time of deployment in ARM. Currently , it is not possible to run two custom script to perform two different tasks on a same VM through custom…

1

SCOM: Unix/Linux Shell Command Monitoring – Unique Requirement

When I was working with a customer recently, I came across an requirement, to execute a Shell Command and based on the results, the monitor state needs to be set for Target Server. One of the best example solution available in web is this. THE PROBLEM: But the uniqueness however  in this requirement is that…


SCOM: What’s wrong with my Unix agents? Why are they greyed out?

  It is quite difficult to work with the Offline Unix agents especially in a large monitoring environment. Though SCOM offers native heartbeat monitor, it is hard to quickly determine whether the computer is actually down or something wrong with the agent configuration. An Unix agent may be down due to various reasons like issue…


PowerShell Script to Simulate Outlook Web Access URL User Logon

Recently I came across with a requirement to do user logon synthetic transaction on Outlook Web Access URL and capture its performance. This can be accomplished using Invoke-WebRequest PowerShell command let. The command let returns form elements which needs to be filled with username and password and the login page is invoked with the post data….


Windows Azure Pack – Implementation Issue – G2 Hardware Profile could not be selected when create VM from sysprep vhdx

Another minor issue I found while stabilizing Windows Azure Pack IaaS environment, it was noted that when try to create standalone virtual machine by selecting a sysprep vhdx from gallery in WAP you could not select any of the available Hardware Profiles configured with Virtual Machine Generation-2, while all Hardware Profiles with Generation-1 can be…

0

Windows Azure Pack – Implementation Issue – Failed to create VM from sysprep vhdx

I went through another very interesting issue while WAP implementation during stabilizing a WAP production environment, although we able to create standalone virtual machine from different templates, in addition we able to create standalone virtual machine from Windows 2008 R2 sysprep vhdx, however the issue that WAP failed to create standalone virtual machine from Windows…

2

Windows Azure Pack – Implementation Issue – ACTIVE (OUT OF SYNC)

Recently I faced an issue while building a complete Windows Azure Pack solution to provide Infrastructure as a Service (IaaS), initially everything was working properly while I was doing testing after each step of WAP deployment, so I able to create three subscriptions, created some virtual machines using the created subscriptions, and able to access…

2

VHD Disk Requirements in Windows Azure Pack (WAP)

There are some prerequisites for VHD Disks that need to be ready before decide to present VHD Disk in WAP to be used why Virtual Machine Provisioning that will save you a lot of troubleshooting time if you verify all as follows: Library Share that hosts the VHD must be added to the list of…

3