One of your five a day
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
Although SQL Server 2016 is now in RC1 it looks as though there will be some changes to the default options in DBCC CHECK with regards to the EXTENDED_LOGICAL_CHECKS option. With the increasing amount of spatial data being used in today’s databases its
With the new version of Community Technology Preview 3 of SQL Server 2016 we have a new T-SQL command DROP TABLE IF EXISTS <tablename> This is a fantastic yet simple addition, easier to read and remember. Other statements are supported
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
The Edinburgh (UK) SQL Server User Group will be starting up again on Thursday 3rd September from 6pm to 9pm.Myself @sqltomato and Satya @SQLMaster will be talking about “a look at some of the new features of SQL 2016 CTP2”
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
Two years ago I was lucky enough to be able to attend the SQL Saturday event in Cambridge. I had a great time and the City is absolutely beautiful.This year the SQL Saturday community day is on September 12th and
Since I’ve been looking to achieve the new “MCSD: Azure Solutions Architect” certification as in my post here it was with great interest that edX has announced a new course, DEV205x: Architecting Microsoft Azure Solutions, which aligns closely to 70-534 Architecting
I was having at look at the query plan operators today in preparation for a talk I will be giving on Plan execution and cache and noticed that some of the operators present are not used in SQL Server 2016, most notable the “Bookmark