Azure SQL to Azure Data Warehouse ETL
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
Keeping track of your SQL Server index “inventory”
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 »
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 …
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 …
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 …
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 …