Create Microsoft SQL Azure Database Read-Only User

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 moreCreate Microsoft SQL Azure Database Read-Only User

Removing virtual machines from Azure in bulk

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 moreRemoving virtual machines from Azure in bulk

Windows Powershell for Managing Azure

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 moreWindows Powershell for Managing Azure

FIX: Oracle SQL Developer timeout when connected to Azure

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 moreFIX: Oracle SQL Developer timeout when connected to Azure