ramblings of a sql solution architect

High Availability

Hi all. I spent some time recently reading through a stack of links to articles and videos put out by Microsoft on the upcoming SQL Server 2019 product, and thought I’d share the more pertinent links with you, as we SQL Consultants need to stay ahead of the curve and be prepared when having discussions … [Read more…]

In my opinion, the quick answer is “not quite” – not even with the release of SQL 2016 SP1. Let me explain … SQL Server 2016 was released to manufacture in June 2016. With it came the highly anticipated Basic Availability Group (BAG) HADR feature in the Standard Edition, with ‘regular’ availability groups (first found … [Read more…]

DBA’s, have you ever woken up one morning and found your SQL 2012, 2014 or 2016 Availability Group had mysteriously failed over during the wee hours? Of course there can be several legitimate reasons why it failed over (Windows Cluster or Quorum issue, O/S resources, SQL Server/node rebooted, SQL Services restarted, lost network connectivity, storage … [Read more…]

Have you every noticed that when you add a database (where the db owner is ‘sa’) in to a SQL 2012 availability group and synchronise the db to one or more secondary replicas, the database owner at each secondary is no longer ‘sa’ but the name of the account used to add the database into … [Read more…]