Something’s always bugged me when it comes to managing indexes in SQL Server; keeping track of when I created or dropped them. You can already check just about everything you could want to know about […]
Keeping track of your SQL Server index “inventory” Read More »
*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
PowerShell script to update Azure firewall rule Read More »
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
SQL Server 2016 & Azure Query Store Read More »
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
Red Gate Azure backup failures Read More »
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
Head in the clouds Read More »
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
SQL Server version information from build numbers Read More »