Cloud

DynamoDB: adding a Local covering index to reduce the cost

By Franck Pachot . This is a continuation on the previous post on DynamoDB: adding a Global Covering Index to reduce the cost. I have a DynamoDB partitioned on “MyKeyPart”,”MyKeySort” and I have many queries(…)

DynamoDB: adding a Global covering index to reduce the cost

By Franck Pachot . People often think of indexes as a way to optimize row filtering (“get item” faster and cheaper). But indexes are also about columns (“attribute projection”) like some kind of vertical partitioning. In relational (“SQL”) databases(…)

Restore S3 Object with AWSPOWERSHELL

AWS S3 offers different Storage Classes, allowing to optimize cost among others. For instance, some classes are used for archiving purposes: S3 Glacier and S3 Glacier Deep Archive. It means the(…)

Oracle 20c SQL Macros: a scalar example to join agility and performance

By Franck Pachot . Let’s say you have a PEOPLE table with FIRST_NAME and LAST_NAME and you want, in many places of your application, to display the full name. Usually my name will be displayed as ‘Franck Pachot’ and(…)

Running SQL Server on the Oracle Free tier

By Franck Pachot The Oracle Cloud is not only for Oracle Database. You can create a VM running Oracle Linux with full root access to it, even in the free tier: a free VM that will be always up, never(…)

One day training @ Microsoft Azure Cloud Workshop

Today, with my colleague Christophe, we follow the Microsoft Azure Training Day: Data and Analytics @ Microsoft Zürich (Wallisellen to be exact). After a presentation of SQL Server 2019, we begin with the First Lab about(…)

Some words about SOUG Day in Lausanne

Today I participate to SOUG Day which takes place in Lausanne at the "Centre Pluriculturel et social d’Ouchy".

A simple Terraform script to create an AWS EC2 playground

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(…)

Avoiding patching madness by using AWS SSM

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(…)

Provisioning a AKS cluster and KubeInvaders with Terraform

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.