Infrastructure at your Service

All posts by David Barbarin

David Barbarin
Senior Consultant & Microsoft Technology Leader

David Barbarin has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies and associated topics such as installation, migration, security audits, troubleshooting of performance issues, or high availability architectures etc. Furthermore, he has many years of experience in .NET development, SSIS packages deployment, and database design in several sectors like retail, health sector, and other industries. David Barbarin is SQL Server MVP (since 2010), Microsoft Certified Master (MCM) for SQL Server, and Microsoft Certified Trainer (MCT). He is also ITIL Foundation V3 certified. He holds an BTS in electronic from France and has a degree in computer sciences from CNAM in Lyon. His branch-related experience covers Public Sector, Financial Services / Banking, Automotive, Health Sector, IT, Watch Industry, etc.
David Barbarin

Deploying SQL Server 2019 AGs on K8s with helm charts

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

This write-up follows my first article about helm chart with SQL Server. This time, I would like to cover the availability groups topic and how to deploy them with helm charts. In fact, to go through this feature for AGs was motivated to its usage in our Azure DevOps CI pipeline in order to deploy a configurable one on an AKS cluster with SQL Server 2019. If you look carefully at the release pipeline, Windocks…

Read More
David Barbarin

Azure SQL Managed instances, Business Critical Tier and high availability

By | Cloud, SQL Server | No Comments

Last blog of this year 2018 with SQL databases and Cloud Azure and this is not trivial choice. <Speculation mode> I would say year 2019 could be important for all stakeholders. Cloud transformation has begun in many forms at customer shops and we heard about some big actors who are coming in Switzerland including Azure or Google. Data Platforms services will not be an exception in some degree of magnitude … <end of speculation mode>….

Read More
David Barbarin

Deploying SQL Server on K8s with Helm charts

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

During the last DockerCon EU in Barcelona, I heard a lot about Helm with K8s architectures. It was also a good opportunity to write about it after attending to this conference. In a nutshell, Helm is a package manager for K8s and you may think of it like the other ones available on the Linux side with apt, yum or zypper to cite few of them. Helm charts are a key component of the Helm architecture and…

Read More
David Barbarin

First immersion in the Docker Conference EU 2018

By | DevOps, Docker | No Comments

In short, a very interesting event for both Devs and Ops. Every day was organized around workshops, hands-on-labs sessions and Hallway tracks. My colleague Mehdi Bada and I tried to attend as much sessions as possible but obviously it was difficult to cover all the topics. Anyway, workshops and hands-on-labs were very interesting especially if you like to mix theory and practice. But I had to admit sometimes we got in trouble to keep up…

Read More
David Barbarin

SQL Server 2019 CTP 2.1 – A replacement of DBCC PAGE command?

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

Did you ever use the famous DBCC PAGE command? Folks who are interested in digging further to the SQL Server storage already use it for a while. We also use it during our SQL Server performance workshop by the way. But the usage of such command may sometimes go beyond and it may be used for some troubleshooting scenarios. For instance, last week, I had to investigate a locking contention scenario where I had to…

Read More
David Barbarin

Is there too much memory for my SQL Server instance?

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

Is there too much memory for my SQL Server instance? This is definitely an uncommon question I had to deal with of my customers a couple of weeks ago. Usually DBAs complain when they don’t have enough memory for environments they have to manage and the fact is SQL Server (like other SGBDRs) provides a plenty of tools for memory pressure troubleshooting. But what about of the opposite? This question raised in a context of an environment…

Read More
David Barbarin

SQL Server 2019 availability groups – Introduction to R/W redirection

By | Database Administration & Monitoring, Database management, SQL Server | 3 Comments

writeThis is a second write-up about SQL Server 2019 CTP2.0 and availability group new features. This time the interesting one is about READRWRITE redirection capabilities. A couple of months ago, I wrote about SQL Server 2017 and new read-scale capabilities and listener management challenges regarding the operating system. Indeed, there are some scenarios where including listener will not as easy as we did with common ones on the top of Windows operation system. A list of…

Read More
David Barbarin

SQL Server availability groups, SQL Browser and Shared Memory considerations

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

Few weeks ago, my colleagues and me discussed availability groups and network considerations for one of our customers including disabling SQL Browser service and shared memory protocol. The point was disabling both features may lead to unexpected behaviors when creating availability groups. Let’s start with the SQL Browser service. It is not uncommon to disable this service at customer shops and to use directly SQL Server listen ports instead. But if you go trough the…

Read More
David Barbarin

First steps into SQL Server 2019 availability groups on K8s

By | Cloud, Database management, DevOps, SQL Server | No Comments

A couple of weeks ago, Microsoft announced the first public CTP version of next SQL Server version (CTP2). It is not a surprise, the SQL Server vNext becomes SQL Server 2019 and there are a plenty of enhancements as well as new features to discover. But for now, let’s start with likely one of my favorites: availability groups on Kurbernetes (aka K8s). As far I may see from customers and hear from my colleagues as well,…

Read More
David Barbarin

Connecting to Azure SQL Managed Instance from on-premise network

By | Cloud, Database Administration & Monitoring | No Comments

A couple of weeks ago, I wrote up about my first immersion into the SQL Server managed instances (SQLMIs), a new deployment model of Azure SQL Database which provides near 100% compatibility with the latest SQL Server on-premises Database Engine. In the previous blog post, to test a connection to this new service, I installed an Azure virtual machine on the same VNET (172.16.0.0/16) including SQL Server management studio. For testing purpose, we don’t need more,…

Read More