Infrastructure at your Service

All Posts By

Microsoft Team

Microsoft Team

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

By | Database Administration & Monitoring, SQL Server | 2 Comments

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 in redirecting client application connections to the primary replica regardless of the target server specified in the connections string. That’s pretty interesting in some scenarios as read scale-out or specific multi-subnet configurations where creating the traditional AG listener is not an viable option. The new R/W connection redirection…

Read More
Microsoft Team

SQL Server containers and docker network driver performance considerations

By | Database Administration & Monitoring, DevOps, Docker, SQL Server | No Comments

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 and especially when database components come into the game with chatty applications. One year ago, I was in a situation where a customer installed some SQL Server Linux 2017 containers in a Docker infrastructure with user applications located outside…

Read More
Microsoft Team

Deploying SQL Server on Azure virtual machine with Terraform

By | Cloud, DevOps, SQL Server | 4 Comments

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 great tool to use in such scenario is certainly terraform and I introduced it during the last PowerSaturday pre-conference named “DBA modern competencies”. Installation paradigms in the cloud differ from what we usually do on-premises either…

Read More
Microsoft Team

Windocks and K8s support

By | DevOps, Docker, Kubernetes, SQL Server | No Comments

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 for deploying Windocks containers that will make my application deployment definitely easier. Let’s say you want to deploy your application that is tied to a Windocks container for SQL Server. In a previous blog post I explained why we…

Read More
Microsoft Team

RCSI with foreign keys, NULL values and paramater sniffing behavior

By | Development & Performance, SQL Server | No Comments

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 first one was why SQL Server continues to use shared locks in RCSI mode leading to blocking scenarios and the second one was about compiled objects with weird NULL value parameter sniffing behavior. This discussion was very funny for…

Read More
Microsoft Team

Windocks, SQL Server and Azure in our internal CI pipeline

By | Cloud, DevOps, Docker, Kubernetes, SQL Server | One Comment

During the last DevOps Day in Geneva, I presented a sample of our CI implementation related to our MSSQL DMK maintenance product. It was definitely a very good experience for me and good opportunity to get feedback from DevOps community as well. During the session I explained our CI pipeline includes SQL Server containers both on AKS (K8s as managed service in Azure) and Windocks. I got questions from some of attendees who asked me…

Read More
Microsoft Team

How To Push An Image Into Amazon ECR With Docker

By | Cloud | No Comments

8 Steps To Push An Image Into Amazon ECR With Docker Please bear in mind that Amazon elastic container registry (ECR) is a managed AWS Docker registry service. In this topic, we will use the Docker CLI to push an CentOS image into Amazon ECR. 1. Install Docker desktop for Windows and AWS CLI Verify and confirm that each version has been installed properly (see below): docker (dash dash)version aws (dash dash)version 2. Authentication to AWS Open Power…

Read More
Microsoft Team

Upgrading SQL Server pods on K8s and helm charts

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes, SQL Server | No Comments

It has been while since my last blog. Today it is about continuing with helm charts and how to upgrade / downgrade SQL Server containers to a specific cumulative update. My first write-up in my to-do list. Last year, I wrote an introduction of SQL Server containers on K8s. I remembered to face some issues when testing upgrade scenarios (probably a lack of knowledge). Since then, I have discovered helm charts and I use them…

Read More
Microsoft Team

SQL Konferenz 2019 – Day 1

By | SQL Server | No Comments

For my first “dbi visit”, I went to Darmstadt, in Germany, to attend SQL Konferenz 2019. There were more than 50 sessions over two days (20 & 21.02.2019) in several areas as SQL Administration, BI, DevOps, Azure & BigData. I decided to write a short glimpse of the most appreciated sessions. Keynote To start this event, they introduced the German SQL Server community (PASS.de) and the upcoming meetings this year, the well-known people are present…

Read More
Microsoft Team

How To Create A Recovery Services Vault In Azure

By | Cloud | No Comments

Creating A Recovery Services Vault In Azure To create a recovery services vault, we first need to create a resource group by using either the CLI or the Azure interface. Creating a resource group using the command line interface $resourceGroup = “recovvault” $location = “westeurope” az group create -n $resourceGroup -l $location The resource recovvault has been created successfully. Now we need to setup  the recovery services vault. From Azure portal, select the resource group…

Read More