SQL Server

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 design(…)

Deploying SQL Server on Azure virtual machine with Terraform

We are entering now to the infrastructure as code world and provisioning a SQL Server infrastructure is not excluded from the equation. This is especially true when it comes the Cloud regardless we are using IaaS or PaaS. One(…)

Windocks and K8s support

I got recently the 4.08 update from the Windocks team and I was very excited to evaluate some of new features. The first cool one I want to present in this blog concerns the Kubernetes support(…)

How to create an Azure SQL Database

Azure SQL Database is a relational database-as-a-service (DBaaS) which gives us the possibility to create application with a performant database without to take care of the relying infrastructure. Azure SQL Database is based on the latest stable version of Microsoft(…)

RCSI with foreign keys, NULL values and paramater sniffing behavior

In this blog post let’s go back to the roots (DBA concern) with a discussion with one of my friends about a weird transaction locking issue. In fact, this discussion was specifically around two questions. The(…)

Windocks, SQL Server and Azure in our internal CI pipeline

During the last DevOps Day in Geneva, I presented a sample of our CI implementation related to our MSSQL DMK maintenance product(…)