-
PowerShell script to update Azure firewall rule
*Updated 2017-06-28 I’ve recently moved house, and as a result had to change my broadband plan from cable to ADSL (sad face). This also means I’ve gone from having a fixed IP address to a dynamically assigned one. Usually, this wouldn’t… continue reading…
-
SQL Server 2016 & Azure Query Store
I hadn’t been following the news much regarding SQL Server 2016, so when I did some reading the other day I was quite pleasantly surprised by some of the new features announced (not to mention that it looks like SSMS… continue reading…
-
Red Gate Azure backup failures
We use Red Gate Cloud Services to backup our Azure database, as well as some storage accounts to Amazon EC2 storage, etc. It all works really well 99% of the time, but after a few failures in a short time… continue reading…
-
Head in the clouds
Wow – 2 years and 4 days with no posts. What a slacker… Anyway… I’ve been busy doing a few things in that time. The most relevant probably being that I moved on from Trade Me near the end of 2014,… continue reading…
-
SQL Server version information from build numbers
Just a quick post in case anyone else finds this useful; for a report I’ve created, I wanted to have SQL Server versions displayed in a nice, readable form, rather than the usual build number format (e.g. 11.0.3128.0). So I found… continue reading…
-
Customising SQL Management Studio 2012
I’m setting up my new work laptop, and decided to have a look around the net for what the cool kids were doing these days as far as customising SQL Management Studio 2012. Surprisingly not a lot seems to have changed… continue reading…