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 …

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 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

What’s New in Windows Server 2012 Hyper-V

I recently attended TechEd 2012 on the Gold Coast, and was pretty spoilt for choice as to what technologies I wanted to learn more about. I have an infrastructure background, and recently completed the MCITP Virtualisation Administrator certification for Windows Server 2008 R2, so Hyper-V was still fresh in my mind and one of those …

MCSE Private Cloud Certification

Released a few months ago, Microsoft have re-vamped their certification for the 2012 suite of products, introducing, most notably, the MCSE Private Cloud certification. For all the MCITP’s, this shouldn’t come as bad news, requiring exorbitant amounts of further study and certification. In fact, it’s quite the opposite. MCITP SA and EA’s automatically receive the …

Building a Hyper-V Lab – cheaply!

I’ve been trying to build a lab at home for a while, but have continued to put the thought aside, over and over. Not because I lack motivation, no, because it’s so damned expensive to purchase so much kit if I’m going to use it for a few months, and then not use it again. …

Windows 8 – to be or not to be?

Microsoft has a track record for releasing horrible operating systems every now and then, as witnessed by the IT world more recently with Windows Vista. It begs the question, after a very successful Windows 7, what is in store for Windows 8? Will it be king, or will it flop? My motivation for this article, …

Lion-style Inverse Scrolling – On Windows XP

My home computer is a Mac, now running OSX Lion. I’ve become quite accustomed to the backwards/reversed scrolling which seems to be the default in Lion – and matches the “natural” swipe up/down gestures you would use on an iPhone or other touch screen device. Today I was looking around on my work Windows XP …

IIS, PHP, and LDAPS with Active Directory.

Why you’d ever want to do this is probably a discussion best left to the political arena. But for the purpose of that thing I call my “day job”, I was required to do just this. External website, authenticates against Active Directory using LDAPS. Website is coded in PHP, and runs on IIS on Windows …