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

Dealing with automatic restart and SQL Docker containers

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, a customer asked me how to restart containers automatically after a reboot of the underlying host. In his context, it was not an insignificant question because some containers are concerned by SQL Server databases and he wanted to stay relaxed as long as possible even after a maintenance of the Linux host by sysadmins. The concerned (DEV) environment doesn’t include container orchestration like Swarm or Kubernetes. The interesting point is…

 
Read More
David Barbarin

Introducing SQL managed instances on Azure

By | Database Administration & Monitoring | No Comments

I never wrote about data platform solutions on Azure so far. The fact is in Switzerland we’re definitely late about the Cloud adoption and Azure data platform solutions. There are different reasons that are more or less valid but I don’t want to contribute to any debate here. In any case the last announcements in this field with Azure data centers in Switzerland could encourage customers to reconsider this topic in the near future. Don’t…

 
Read More
David Barbarin

Dealing with ugrade scenarios for SQL Server on Docker and Swarm

By | Database Administration & Monitoring | No Comments

This blog post comes from an interesting experience with one customer about upgrading SQL Server on a Docker environment. Let’s set quickly the context: a production environment that includes a standalone Docker engine on the top of openSUSE Linux distribution with some SQL Server 2017 Linux containers. The deal was to update those SQL Server instances from 2017 CU1 to 2017 CU7. The point is we applied the same kind of upgrades earlier on the morning but it…

 
Read More
David Barbarin

Introducing SQL Server on Kubernetes

By | Database Administration & Monitoring | No Comments

After spending some times with Docker Swarm let’s introduce SQL Server on Kubernetes (aka K8s). Why another container orchestrator? Well, because Microsoft gives a strong focus on Kubernetes in their documentation and their events and because K8s is probably one of the most popular orchestration tools in the IT industry. By the way, I like to refer to the Portworx Annual Container Adoption Survey to get a picture of container trend over the years and we…

 
Read More
David Barbarin

SQL Saturday Paris 2018 – Pré-conférence SQL Server Linux, Docker et Azure

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

The next SQL Saturday in Paris is coming soon and the agenda has been published by the @GUSS on twitter. Le prochain SQL Saturday Paris arrive bientôt et l’agenda a été publié sur Twitter par le @GUSS Cette année, un savant mélange de speakers francophones et internationaux, un plus pour les participants … Un rapide coup d’œil à l’agenda – si on se focalise sur la partie moteur SQL Server – montre également qu’une bonne…

 
Read More
David Barbarin

OpenSSH is now available on Windows 10

By | Database Administration & Monitoring | No Comments

A couple of days ago, the Windows 10 april 2018 update was installed on my laptop. And what, you may say? Well, surprisingly this update provides some interesting “hidden” features and one of them concerns OpenSSH that is now available on-demand in Windows 10 (and likely available soon on Windows Server). This a obviously a good news because so far, I used either putty or directly a bash environment from my Windows 10 laptop available since…

 
Read More
David Barbarin

Windocks – a different way to use SQL Server on Docker

By | Database Administration & Monitoring | No Comments

I spent some times to write blog posts about SQL Server on Docker since few months and you likely noticed it concerned mainly SQL Server on Linux. But what about SQL Server on Docker and Windows? If you take a look at the Docker images provided by Microsoft, only 2017 version is available and it is only intended for development and testing use. Versions prior 2017 seem to not be supported so far (but I…

 
Read More
David Barbarin

Load Balancing with Docker Swarm mode and SQL Server containers

By | Database Administration & Monitoring | No Comments

Docker swarm mode provides an easy way to publish ports for services. Indeed, in this mode all nodes participate in an ingress routing mesh and accept connections to any service port published. Thus, all incoming requests are routed to available nodes hosting a service. That’s a pretty cool feature but it has some drawbacks. Let’s say that a node goes wrong … In this case the application must retry connecting to the next available node…

 
Read More
David Barbarin

Managing SQL Server sa credentials with Docker secrets on Swarm

By | Database Administration & Monitoring | No Comments

A couple of weeks ago, I was working on a MSSQL Server docker image in a context of Hidora, a swiss cloud provider based on jelastic and for Docker-based applications. When writing my jps manifest file I was agreeably surprised about the section concerning the MSSQL Server credentials information. We may able to define global variables for SQL Server sa password with ${fn.password} as function as shown below: globals: sa_password: ${fn.password} user_password: ${fn.password} nodes: -…

 
Read More
David Barbarin

SQL Server on Docker and network bridge considerations

By | Database Administration & Monitoring | No Comments

Let’s continue with this blog post series about SQL Server and Docker. A couple of days ago, I was in a customer shop that already implemented SQL Server 2017 on Linux as Docker containers. It was definitely a very interesting day with a lot of customer experience and feedbacks. We discussed with him about lot of architecture scenarios. The interesting point here is I was able to compare with a previous customer who used docker…

 
Read More