Deploy MSSQL Server with Pulumi in Azure
Introduction This is the second part of my series explaining Pulumi using C#. In the first post, you got a brief introduction to the basics. This time, I want to showcase how to deploy an Azure SQL Server instance with a database. For validation, I will restrict database access to my current IP address. Additionally, as preparation for Keycloak, the database will include a separate user. There are three main components to set up: ...
Use Infrastructure as Code
Introduction Have you ever worked with cloud environments and realized how time-consuming it can be to set them up and develop quickly, consistently, securely, and, above all, reproducibly? There are many tools available to help. Some are provider-specific, such as CloudFormation for AWS or Bicep for Azure. Others, like the well-known Terraform and its open-source successor OpenTofu, support multiple cloud service providers. Most of these tools use a domain-specific language (DSL) to define your environment. They offer robust toolsets to ensure security and consistency. While useful, learning another language and tackling its complexities can be a drawback. ...
Rds Import Bacpac
Have you ever tried to import a BACPAC file into an RDS Microsoft Sql Server instance? Than you might experienced the same issue, that the import process was aborted and the added database was inaccessible. Import Error To understand what causes this issue, we have to understand what a BACPAC is. In the documentation from Microsoft they explain it like this: A BACPAC file is a ZIP file with an extension of BACPAC containing the metadata and data from the database.1 ...
How to improve your Workstation setup
Typically, you don鈥檛 install your operating system and all the tools too often. However, I had to do that exactly several times in the past two months. The first time is still exciting, because you deal with the new functions and tools. The second time at the latest, the work through the configuration is annoying. With this article I want to show how you can (partially) automate the installation and configuration of your tools and thus achieve a repoducible working environment. ...