So you created a Windows Server Failover Cluster on Azure…and now it won’t start

It pays to pay attention to the detail! I created a Windows Server Failover Cluster (WSFC) on a bunch of Windows 2012 R2 virtual machines running in Azure, and at first, it all just worked. I wrote a quick little PowerShell script to install the cluster features, and then used the MMC console to do …

Microsoft SQL Server 2016 on Linux

One of the most exciting updates in SQL Server 2016 is the ability to run it on Linux! Currently working on some designs which incorporate SQL Server 2016 AlwaysOn Availability groups and had to ask; does it work on Linux? Well, there's a Channel9 video for that. The host briefly mentions AlwaysOn Availability Groups, and …

3 Things You Must Do At University (or Things You Didn’t Do and Regret)

I started my university degree as I hit the job market, studying a generic IT degree alongside a generic IT career. I had it pretty lucky; I was fortunate to already have a job in my field, and finishing my degree simply wasn’t a priority. Roll forward 11 years, I finally completed my degree. And …

Office 365 – Day to Day Migration Commands

Connect to Remote Powershell $UserCredential = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection Import-PSSession $Session Create a new move request (with an existing remote powershell open) $OPCred = Get-Credential ### use CORP\user.name.1 New-MoveRequest -Remote -RemoteHostName mrs.onpremdomain.com -RemoteCredential $OPCred -TargetDeliveryDomain tenant.onmicrosoft.com -SuspendWhenReadyToComplete -Identity [email protected] -BadItemLimit 5 -WhatIf IF this proceeds, re-run …

CASE WHEN “I need to learn more T-SQL” THEN GoogleTheResult() END

One of my favorite recent discoveries in my SQL Server work recently, is the awesome T-SQL "CASE...WHEN...THEN" statement. I can't describe how much I love this thing. It's pretty simple really: SELECT CASE WHEN fruit = 'apples' THEN 'not oranges' WHEN fruit = 'oranges' THEN 'not apples' ELSE 'neither apples nor oranges' END AS fruit …

Backing up all SQL Server user databases to file

The ultimate lazy backup script. I wasn't feeling to selective about which databases to backup, and I figured, it'd be best to back them all up, even that testing database I occasionally use for data import/export. Never know when I might need it again... This sits inside a SQL Server Agent job, and runs nightly. Simple enough …

On moving to Seattle…and reviving my camera…

I left the homeland, Australia, in early January. My employer proposed an opportunity of a lifetime, and alas, here I am now in Seattle, the capital of IT for those Microsoft-ies among us. One of the things I am passionate about, is photography, and it is on that note of visiting a new city, that I have …

Server Posterpedia Windows 8 Application

You're designing a new SQL Server infrastructure for a client, but can't remember if that high availability solution topology requires shared storage or not, and need to quickly look it up without searching through TechNet. How? With this application! Some genius has combined all of Microsoft's server architecture posters into a handy Windows 8 application …

Windows 8 Without a Tablet? Nonsense!

Today, Microsoft launched Windows 8 to the masses. And I'm frustrated. Over the past year, I have had the opportunity to play with Windows 8, blowing away my daily work laptop and installing the new operating system at each release - beta, release preview, consumer preview, and RTM. Yes. A laptop. Not a touch screen …