One of your five a day
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
MCSE qualification requires a recertification every three years to validate your skills on the SQL Server Platform. With my certification soon requiring the update I started to think about getting it done sooner rather than later. Recently the SQL Server
If you currently have a Visual Studio Premium with MSDN or Visual Studio Ultimate with MSDN then you will be upgraded automatically to Visual Studio Enterprise with MSDN when Visual Studio 2015 is released.https://www.visualstudio.com/en-us/products/free-upgrade-visual-studio-enterprise-vs.aspx
Whilst having a discussion about Azure and app service/web hosting/web sites I was asked how to manage their web site to stop it being unloaded during extended periods of inactivity. There is the Always On button, which is recommended if you are
Recently I’d been asked to increase the partner timeout of all the mirrored databases on an instance. There were many databases on this instance so I decided to use the undocumented feature sp_MSforeachdb instead. This system stored procedure returns all