Infrastructure at your Service

Category

Cloud

Daniel Westermann

A simple Terraform script to create an AWS EC2 playground

By | Cloud, Database Administration & Monitoring | No Comments

When I started to write the blog about AWS SSM I quickly realized that I need a way to bring up and destroy my AWS EC2 playground in an easy and reproducible way. There are several options for this: I could have used the AWS command line interface or AWS CloudFormation. Both work pretty well and would have been more than enough for my simple requirements. In the end I decided to use Terraform for…

Read More
Daniel Westermann

Avoiding patching madness by using AWS SSM

By | Cloud, Database Administration & Monitoring | No Comments

As we have more and more customers either currently moving to AWS or already moved much, if not even all, of their workloads to AWS, one question pops up quite frequently: Now that we have so many EC2 instances up and running how do we regularly patch them? There are many tools around for patching operating systems, such as Microsoft SSCM, Red Hat Satellite or SUSE Manager just to name a few. There are many…

Read More
David Barbarin

Provisioning a AKS cluster and KubeInvaders with Terraform

By | Cloud, DevOps, Kubernetes | No Comments

Provisioning a K8s infrastructure may be performed in different ways. Terraform has a connector called the Kubernetes provider but it doesn’t allow building and deploying a Kubernetes cluster. The cluster must be up and running before using the provider. Fortunately, there are different cloud-specific provider depending which cloud provider you want to provision your cluster. In our CI pipeline for the MSSQL DMK maintenance, we provision SQL Server containers on Linux to perform then different…

Read More
David Barbarin

Deploying SQL Server on Azure virtual machine with Terraform

By | Cloud, DevOps, SQL Server | 2 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
Stéphane Savorgnano

How to migrate from on-premise to an Azure SQL Database

By | Cloud, Database management | No Comments

As a SQL Server DBA we have the habit to migrate databases from an instance to another one or to a new environment. But migrate a database from on-premise to the Azure Cloud is an operation that we don’t deal with every day. As a reminder, Azure SQL Database is a relational database-as-a-service (DBaaS) which gives the ability to manage your databases directly from the Cloud with the performance of your choose, reliability, security and…

Read More
Stéphane Savorgnano

How to create an Azure SQL Database

By | Cloud, SQL Server | No Comments

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 SQL Server Database Engine. We have the choose between 2 purchasing models: a vCore-based purchasing model and a DTU-based (Database Throughput Unit) purchasing model. 3 Deployment options possible: single database: has its own set of…

Read More
David Barbarin

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