SQL Server

SQL Server 2019 Accelerated Database Recovery – Instantaneous rollback and aggressive log truncation

In my previous article about Accelerated Database Recovery (ADR), I wrote mostly about the new Persistent Volume Store (PVS), how important it was important in the new(…)

Using non-root SQL Server containers on Docker and K8s

This is something that I waited for a while, in fact since SQL Server 2017 … and the news came out on Wednesday 09th September 2019. Running(…)

When Read-Scale availability groups and Windows Failover Cluster are not good friends

A couple of days ago, with some fellow French data platform MVPS (@thesqlgrrrl and @Conseilit) we discussed an issue around Read-Scale availability groups(…)

Introducing Accelerated Database Recovery with SQL Server 2019

SQL Server 2019 RC1 was released out a few weeks ago and it is time to start blogging about my favorite core engine features that will be shipped with the next version of SQL Server. Things should not be completely(…)

Debugging SQL Server containers considerations

When it comes to troubleshooting processes or to get a deeper look of how SQL Server works internally , I always used debugging tools as windbg on Windows and since SQL Server is available on Linux, I switched to(…)

SQL Server 2019: Java in SQL Server hard to believe, no?

It has already been a few months that we are testing the next version of SQL Server: SQL Server 2019. I already blogged about a previous version of SQL Server supporting R and Python. With the new version(…)

Deploying SQL Server 2019 container on RHEL 8 with podman

Having a fresh install of RHEL8 on my lab environment, I was curious to take a look at new containerization stuff from Red Hat in the context of SQL Server 2019. Good chances are the future version of SQL Server(…)

SQL Server 2019 availability group R/W connection redirection, routing mesh and load balancing

SQL Server 2019 availability group feature will provide secondary to primary replica read/write connection redirection. I wrote about it in a previous blog post here. It consists(…)

Microsoft Inspire Partner Event 2019 / Day 1

dbi services at Microsoft Inspire Conference Summary of my first participation – Day 1 After 20 years in the business of IT Infrastructure, time has come to open my mind 😉 and Microsoft Inspire is the perfect opportunity. It is(…)

SQL Server containers and docker network driver performance considerations

Few months ago I attended to the Franck Pachot session about Microservices and databases at SOUG Romandie in Lausanne on 2019 May 21th. He covered some performance challenges that can be introduced by Microservices architecture(…)