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 […]
Windows 8 Promo Videos
http://www.youtube.com/watch?feature=player_embedded&v=tgKEgI42WA8
Windows Server 2012 Hyper-V Architecture Reference
I was lucky enough to pick one of these up in hard copy form at TechEd Australia 2012!! Very useful reference! Download the full copies from Microsoft here – http://www.microsoft.com/en-us/download/details.aspx?id=29189&ocid=aff-n-we-loc–ITPRO40886&WT.mc_id=aff-n-we-loc–ITPRO40886
Recovering a RAID5 Array on the Intel C600 Controller
Like everyone else in this digital age, my PC is full of stuff which, if I lost, would be beside myself. Pictures of my kids and all of those memories have a special place set aside on my RAID 5 array. A special place I had intended to backup but kept forgetting to setup. And […]