search

Category: Microsoft Azure


Create Microsoft SQL Azure Database Read-Only User

Posted by in Microsoft Azure, Microsoft SQL

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…


Removing virtual machines from Azure in bulk

Posted by in Microsoft Azure

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…


Windows Powershell for Managing Azure

Posted by in Microsoft 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…


FIX: Oracle SQL Developer timeout when connected to Azure

Posted by in Microsoft Azure, Oracle SQL

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…


close
search

Hi, guest!

settings

menu