Skip to content

Cloud

Moving databases and applications to AWS, Microsoft Azure or Oracle Cloud Infrastructure raises practical questions about architecture, migration, managed services, licensing and cost. Our consultants answer them with what actually worked on customer projects.

How to create an Azure SQL Database using Azure PowerShell

In this blog post, I’ll go through the steps to create an Azure SQL Database using Azure PowerShell. Introduction to Azure SQL Database The SQL database services provided by Microsoft on the cloud are now grouped under the name of Azure SQL. The Azure SQL family contains services that I will briefly summarize; Azure SQL Database – DBaaS (Database-as-a-Service) Azure… 

6 things Oracle could do for a better ODA

Introduction With the latest ODA X8 range, at least 80% of the customers could find an ODA configuration that fits their needs. For the others, either they can’t afford it, either they are already in the Cloud, or they need extremely large storage or EXADATA performance. Among these 80% of customers, only a few choose ODA. Let’s see how Oracle… 

Automate AWS deployments with Ansible + Terraform

Automate AWS deployments with Ansible + Terraform This installation is made from a bastion server already available with the proper network permissions. For different deployment types, you should adapt it to your need. Install requirements Ansible installation: sudo apt update sudo apt install -y software-properties-common sudo apt-add-repository –yes –update ppa:ansible/ansible sudo apt install -y ansible ref: https://docs.ansible.com/ansible/latest/installation_guide/intro_installation.html#installing-ansible-on-ubuntu Terraform installation: wget… 

Oracle Standard Edition on AWS ☁ socket arithmetic

By Franck Pachot . Note that I’ve written previously about Oracle Standard Edition 2 licensing before but a few rules change. This is written in May 2020. TL;DR: 4 vCPU count for 1 socket and 2 sockets count for 1 server wherever hyper-threading is enabled or not. The SE2 rules I think the Standard Edition rules are quite clear now:… 

Use MABS to protect Hyper-V on-premises VMs workload

During my last blog post I explained how to installed a MABS. Now that your infrastructure is setup you will be able to protect the workload of your Hyper-V Virtual Machines. You have first to create a new protection group. This group will contain one or more VMs which will share the same backup configuration for retention, synchronization and recovery.… 

How to install MABS (Microsoft Azure Backup Server) and use it to protect on-premise virtual machines

During my last blog-posts I tested the MARS (Microsoft Azure Recovery Service) through Windows Admin Center and how to use Azure Backup to recover files/folders or System State for protected servers. To continue my Azure protection possibilities overview I will today installed a MABS on one of my virtual on-premise server and uses it to protect my others virtual on-premises… 

The myth of NoSQL (vs. RDBMS) agility: adding attributes

By Franck Pachot . There are good reasons for NoSQL and semi-structured databases. And there are also many mistakes and myths. If people move from RDBMS to NoSQL because of wrong reasons, they will have a bad experience and this finally deserves NoSQL reputation. Those myths were settled by some database newbies who didn’t learn SQL and relational databases. And,… 

Terraform and Oracle Cloud Infrastructure

Introduction When you learn a cloud technology, like OCI, the one from Oracle, you start building your demo infrastructure with the web interface and numerous clicks. It’s convenient and easy to handle, even more if you’re quite used to infrastructure basics: network, routing, firewalling, servers, etc. But when it comes to build complex infrastructures with multiple servers, subnets, rules, databases,… 

AWS Aurora vs. RDS PostgreSQL on frequent commits

This post is the second part of https://www.dbi-services.com/blog/aws-aurora-xactsync-batch-commit/ where I’ve run row-by-row inserts on AWS Aurora with different size of intermediate commit. Without surprise the commit-each-row anti-pattern has a negative effect on performance. And I mentioned that this is even worse in Aurora where the session process sends directly the WAL to the network storage and waits, at commit, that… 

AWS Aurora IO:XactSync is not a PostgreSQL wait event

By Franck Pachot . In AWS RDS you can run two flavors of the PostgreSQL managed service: the real PostgreSQL engine, compiled from the community sources, and running on EBS storage mounted by the database EC2 instance, and the Aurora which is proprietary and AWS Cloud only, where the upper layer has been taken from the community PostgreSQL. The storage… 

AWS Certified Database Specialty (DBS-C01)

Here is my feedback after preparing and passing the AWS Database Specialty certification. There are tips about the exam but also some thoughts that came to my mind during the preparation when I had to mind-shift from a multi-purpose database system to purpose-built database services. Exam Availability This exam was in beta between last December/January and then was planned for…