-
Lessons Learned Creating TayTayTexts.com
Back in March, the BOQ Hackathon was held in Brisbane, and after reviewing the mentor list, I did some research about what the different mentors brought to the hackathon and if I could learn anything from them. One of the mentors had created a website, “KanyeTexts” in a day, using a bunch of cloud services…
-
BizTalk 2016 & SQL Always On Availability Groups
Microsoft introduced support for SQL Server AlwaysOn Availability Groups with BizTalk 2016; and it’s a fair bit to digest. Availability Groups is available in SQL Server 2016 Enterprise Edition, and introduces some valuable and important options for disaster recovery and high availability. Implementing these features to provide resiliency and protection for BizTalk requires even more understanding and a…
-
Don’t follow the instructions
Ever purchased an IKEA flatpack and tried to assemble it yourself? Often, it results in a little bit of cursing, rarely does it work out perfectly the first time. At what point did you pull out the instructions? In this process driven world, we are led to produce endless reams of step by step instructions…
-
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…