Data Flows
I gave a session on Azure Data Factory v2; The Data Flows at Data: Scotland on the 13th September. Azure Data Factory is a cloud-based data integration service that allows you to create data-driven workflows in the cloud for orchestrating
vCore-based Database purchase model – Azure SQL Database
Azure SQL Database has been available for a long time now in its own unique DTU licenced model. As of 4th April it is now also available in a vCore-based Database purchase model, in preview, which will align much more
Transparent geographic failover for Azure SQL Database
As many of you know, I am a big fan of Azure SQL Database, the Platform as a Service (PaaS) database solution and that it frequently supports new features such as Active Geo-Replication for Azure SQL Database ALL Tiers and TRIM. A
Azure SQL Database wait stats
I’ve been looking at trying to get some Azure SQL Database wait stats for some time now. We’ve had the useful resource statistics dynamic management views for a while but they only really provided information of utilisation of the CPU, I/O,
Migrating to WordPress – Part 2 (Azure WordPress Options)
After my post on Migrating to WordPress – Part 1 and some questions and comments from colleagues and readers I thought it would be beneficial to describe the various options and costs available to users of Azure and Project Nami to achieve
CREATE DATABASE, AS COPY OF in Azure SQL Database
Recently I had a conversion about the options available to create a copy of a production database for testing and development. There are, the enhanced, CREATE DATABASE and the standard Restore database options available. We’ve got the restore database option,
Setting up Azure SQL Readable Secondaries – Part 2
Previously we provisioned three Azure SQL Servers, one Primary with two Readable Secondaries. Next we need to create a new user with db_datareader permissions in this example, perhaps for a reporting application. First we need to add an allow rule
Setting up Azure SQL Readable Secondaries – Part 1
With our last post and the availability of readable secondaries on all tiers I thought I’d run through the requirements. Firstly we need to create three servers. In this example we’ll create one each in North Europe, West Europe and West US, as below; Then we will add a
Active Geo-Replication for Azure SQL Database ALL Tiers
SQL Azure used to require the Premium (P) tier to take advantage of Active Geo-Replication for Azure SQL Database. Since April 25th this is no longer the case and all tiers, including Basic (B) at around $5/£3 month, now support this
SQL Azure – ROWS UNBOUNDED PRECEDING
At the weekend I had a question from an attendee at SQL Saturday in Cambridge. We were discussing SQL Azure and what it supports and didn’t and the significant improvements in version 12 (v12). v12 made massive differences in what