I’ve recently needed to move data from our transactional database (an Azure SQL database), into an Azure SQL Data Warehouse. A definite case of “harder than it needed to be”… What’s an Azure Data Warehouse? […]
Azure SQL to Azure Data Warehouse ETL Read More »
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 »