Microsoft Team

SQL Server 2016 AlwaysOn: distributed availability groups

This time, I will talk about distributed availability groups. What’s that? In short, a group of availability groups. Sounds good right? But in which cases may we need such architecture? Firstly, let’s say that(…)

SQL Server 2016 AlwaysOn: Add DBs in AGs with direct seeding

In this blog I would like to talk about two new features shipped with SQL Server 2016 for AlwaysOn availability groups. The first one concerns the new direct seeding capability and the seconde one introduces distributed availability groups(…)

SQL Server AlwaysOn: is my database ready for failover?

In this blog post I just want to clarify values that we may find from the is_failover_ready column of the sys.dm_hadr_database_replica_cluster_states DMV. A couple of days ago, I had an interesting discussion with one of my customers during which he(…)

SQL Server 2016 is available on msdn

Breaking news lady and gentlemen. In case you missed it, SQL Server 2016 is live from MSDN subscription. As a reminder, this version offers a lot of very interesting new features and enhancements. Here a(…)

Windows Failover Cluster : Introduction to paxos tag

A couple of days ago, I was in charge to install a new SQL Server AlwaysOn and availability group with one of my colleague Nathan Courtine. During the installation, we talked about testing a disaster recovery(…)

Stored procedure execution may fail with nonclustered columnstore indexes

In this blog post, let’s talk about a weird situation where I faced a nonclustered columnstore issue with SQL Server 2012. Let’s say we are in the same context than this previous blog post here. So(…)

SQL Server 2016 RTM – Coming soon!

The first RTM release of SQL Server 2016 will be released soon. It’s official now! Indeed, Microsoft announced here the SQL Server 2016 RTM release being generally available for use the 1st June 2016. What does(…)

SQL Server: switch partition and metadata inconsistency issue

In this blog post, I would like to share with you a weird issue I faced when I implemented a sliding Windows partition scenario on SQL Server 2014 SP1 at one of my customer. The idea was to keep SQL(…)

Columnstore index rebuild cannot start

A couple of weeks ago, I was charged to migrate an SQL Server datawarehouse environment to a more recent version of SQL Server (from 2005 to 2012 in my case). After discussing with my customer we decided to benefit from(…)

SQL Server 2016 RC3: .NET Framework 3.5 is no longer required during installation

As you may certainly know, the last release candidate of SQL Server 2016 (RC3) has been released by Microsoft a couple of days ago. You may find the announcement here.  As usual, after downloading the binaries(…)