Microsoft Azure

Create Microsoft SQL Azure Database Read-Only User

by

To create a login (server wide account) which uses a simple username + password combination for SQL authentication: CREATE LOGIN ReadOnlyUserName WITH PASSWORD = ‘strong_password’; NOTE: This allows the user to connect using SQL Management Studio. It is not required if the user only needs to connect to a specific database.   To create a user to … Read more

Removing virtual machines from Azure in bulk

by

Using Microsoft Azure PowerShell and Azure Service Manager, this script will loop through all provisioned cloud services and display them in a selection box to allow multiple cloud services to be selected to be deprovisioned and deleted, easily, at one time.  Very handy for cleaning up after demonstrations and student labs. # Modified from a blog post … Read more

Windows Powershell for Managing Azure

by

Download and Install Windows Management Framework: https://www.microsoft.com/en-us/download/details.aspx?id=48729 Ref: https://msdn.microsoft.com/en-us/library/mt125356.aspx   Start –> All Programs –> Accessories –> Windows Powershell Right-click Windows Powershell ISE and select “Run as Administrator” Execute the following in the PowerShell window: Install-Module AzureRM #Install the Azure RM modules Install-AzureRM #Download and install each module of Azure RM Install-Module Azure #Install the ASM module … Read more

FIX: Oracle SQL Developer timeout when connected to Azure

by

When using Oracle SQL Developer to connect to an Oracle database housed on a VM in Microsoft Azure, Developer will “timeout” after approx. 2 – 3 minutes due to Azure closing unused connections. Using this configuration, Oracle SQL Developer will hold the connection open indefinitely. Download and unzip the Oracle InstantClient: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Put the unzipped … Read more