One of your five a day
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
I’ve recently been doing a significant amount with Windows Server Clustering and Availability Groups and I thought I’ d get some of the information posted whilst its all fresh. Clustering, the basics The basics of Windows Server Clustering are
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
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
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
This morning I was asked about Automatic Page Restore as it had been mentioned this was a feature in database mirroring and whether or not it was included in Availability Groups.Since the underlying technologies and disk access layer are similar between database mirroring