Microsoft Team

Azure Compare Total Cost of Ownership (TCO) with comparable Azure deployment

Microsoft Azure allows you to quickly deploy infrastructures and services to meet all of your business needs. You can run Windows and Linux based applications in 36 Azure datacenter regions, delivered with enterprise grade SLAs. Microsoft Azure offer you(…)

SQL Server 2017 high availability and Resumable Online Indexes

Ensuring data availability is an important part of the high availability design. SQL Server AlwaysOn features including SQL Server FCIs and availability groups address some aspects of the problem but we may also rely on the online operations features to(…)

Prochaine édition des 24 HOP 2017 francophone

La prochaine édition du 24 Hours of PASS 2017 edition francophone se déroulera les 29-30 juin prochain. Pour rappel le format est simple: 24 webinars gratuits répartis sur 2 jours de 07:00 à 18h00 GMT et en(…)

SQL Server 2017 on Linux and some log shipping scenarios

In this blog let’s talk a little bit about the log-shipping feature from the SQL Server CTP 2.0. First of all, let’s say that as a Windows version, it is possible to create our own solution based on Linux (and(…)

SQL Server 2017 AlwaysOn AGs and new read-scale architectures

As you probably know Microsoft announced an official name for SQL Server vNext during the last Microsoft Data Amp event on April 19 2017. It becomes officially SQL Serve 2017. In my first(…)

SQL Server on Linux and experimental Flexible Architecture

In this blog post let’s talk a little bit about SQL Server optimal installation on the Linux file system. This is probably one of the first considerations we will have as a database administrator. Actually basic installation of SQL Server(…)

Speaking at the next SQL Nexus at Copenhagen 2017

On May 2nd, I will have the chance to speak during the next SQL Nexus event in Copenhagen (1 -3 may) about SQL Server 2016 and availability groups and if I have(…)

Introducing AlwaysOn availability groups on Linux

A couple of days ago, Microsoft has rolled out the SQL Server vNext CTP 1.3 which includes very nice features and the one that interested me in the supportability of AlwaysOn availability groups on Linux. That(…)

SQL Server Failover Cluster on Linux and synchronizing uids/gids across nodes

In my previous blog post, I talked about SQL Server on Linux and high availability. During my test, I used a NFS server to(…)

SQL Server AlwaysOn – Distributed availability groups, read-only with round-robin capabilities

This blog post comes from a very interesting discussion with one of my friends about the read-only capabilities of secondary replicas in the context of distributed availability groups. Initially, distributed availability groups are designed to address(…)