Author: Mike

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…

Determine Microsoft SQL Azure Version

Posted by in Uncategorized

To determine the MSSQL version: SELECT @@version

Deleting worksheets from Excel using VBA

Posted by in Uncategorized

On Error Resume Next ‘turn off error handling Application.DisplayAlerts = False ‘turn off alerts Worksheets(“Summary”).delete Worksheets(“RBI”).delete Worksheets(“HR”).delete Worksheets(“ERA”).delete Application.DisplayAlerts = True ‘turn alerts back on On Error GoTo 0 ‘turn error handling back on

Senior photo videos in iMovie

Posted by in Digital Photo

Each photo is 4 seconds – 3 seconds for the photo and 1 second for the transition (cross dissolve). I use the photo album theme with a senior pic as the album cover along with their name. Each video is roughly divided into 4 sections (pre-elementary, elementary, middle, and high school). The first three sections correspond…

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…

Count Number of Rows In Microsoft SQL Table

Posted by in Microsoft SQL

To count the number of rows in a Microsoft SQL database table: SELECT COUNT(*) FROM dbo.table_name;  

Windows Powershell for Managing Azure

Posted by in Microsoft Azure

Download and Install Windows Management Framework: Ref:   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…

Install Linux Updates via Command Line

Posted by in Linux

sudo apt-get update     #Gets list of available updates sudo apt-get -y upgrade    #Upgrades current packages sudo apt-get -y dist-upgrade   #Installs new updates #Run as a single command sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y dist-upgrade

How To Test For Empty ResultSet In Java

Posted by in Java

In theory, we set a String variable populated with “before” indicating that “results” have not been populated with .executeQuery yet. Set a watch on the String variable. Set a breakpoint so you can see the variable populate with your “before” text. Set a breakpoint on the first line of the setters code so you can…

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: Put the unzipped…

‹ previous posts next posts ›

Hi, guest!