Microsoft Team

Introducing high-availability and multi-subnet scenarios with SQL Server on Linux

On my first blog about SQL Server on Linux, I introduced the new high availability feature which concerns only SQL Server failover(…)

Introducing high-availability with SQL Server on Linux

A couple of months ago, I did my first installation of SQL Server on Linux. I wrote about it in this blog post. So(…)

Dealing with WSFC 2016 quarantine state and availability groups

I was playing with my lab environment which includes Windows 2016 and SQL Server 2016 and I noticed an interesting scenario while testing cluster node failures. After simulating some network outage scenarios, I was not able to(…)

MS Cloud Summit Paris 2017

Une nouvelle année commence et 2017 devrait être un bon cru dans le domaine de la base donnée notamment en prédiction des effets d’annonces faites par Microsoft cette fin d’année 2016. En effet, il a été notamment été question de la prochaine(…)

Migrating your existing availability group infrastructure to 2016

Have you already a plan to migrate your old SQL Server 2012 availability group infrastructure to windows 2016 and SQL Server 2016? In a previous post, I talked about distributed availability groups and cross-cluster migration scenarios(…)

SQL Server 2016: distributed availability groups and cascaded replicas

During the last MVP summit, we had some interesting discussions about availability groups with the SQL Server team and I remember someone asked for managing scenarios like Oracle cascaded destinations and the good news is that(…)

First installation of SQL Server on Linux REHL 7.2

As you certainly know Microsoft announced yesterday the first preview of SQL Server vNext on Linux. Obviously we are far from a final version suitable for production and the list of unsupported features will probably be good indicator of the(…)

SQL Server 2016 SP1 and unlocked enterprise features!

Starting with the release of SQL Server 2016 SP1, you will probably notice that the standard edition will benefit from a lot of features previously available only on Enterprise edition. Such features concern different areas as performance,(…)

Run SQL Server everywhere!

Running SQL Server everywhere is not a dream anymore!  Microsoft has just announced the first release of SQL Server CTP1 on Linux today! But that’s not all! SQL Server Vnext is also available on Windows,(…)

SQL Server AlwaysOn availability groups and statistic issues on secondaries

I would like to share with you an interesting issue you may face while using SQL Server AlwaysOn availability groups and secondary read-only replicas. For those who use secondary read-only replicas as reporting servers, keep reading this blog post because(…)