Adrien Obernesser

Offloading PostgreSQL Backups to Azure Blob Storage Using PGBackRest, Managed Identity, and SAS Tokens

Introduction One of the nice things with cloud providers is the low costs of their storage. Whenever you want to optimize your long-term backups and push them on Azure, you might face a wall of questions on how to do(…)

Postgresql Security with Builtin Roles and functions.

Introduction As PostgreSQL continues to gain traction in enterprise-grade applications, I am increasingly tasked and asked about implementing robust security policies. And, as most current DBA positions are multi-systems nowadays, I wanted to make a quick summary on roles and(…)

PostgreSQL Conference Europe 2024 – Last day

As I reflect on my last day at PGConf.EU 2024 in the beautiful city of Athens, I am filled with a profound sense of gratitude and excitement. The conference was a melting pot of innovation, knowledge sharing, and community spirit,(…)

PostgreSQL Conference Europe 2024 – Day 2

Here’s the following day 2 of the PostgreSQL Conference Europe 2024 in Athens, if you haven’t read the first day here is the link. After a fantastic first day, I was excited to dive into the next day of(…)

PostgreSQL Conference Europe 2024 – Day 1

Attending PostgreSQL Conference Europe 2024 in Athens is an incredible experience, full of enriching conversations and technical deep dives. As a DBA Consultant and speaker (on the reserve list and honored to have been chosen), it was my first time(…)

What DEVs need to hear from a DBA and why SQL and RDBMS still matters…

The Average case As a skilled developer, you are well-versed in the latest trends and fully capable of building an application from scratch. From the frontend to the RESTful API backend, through to the ORM and the database, you have(…)

PostgreSQL’s New Milestone in Security: Officially CVE Numbering Authority

The PostgreSQL Community just made a significant leap forward in database security :Postgresql is now a CVE Numbering Authority (CNA). Here is the original announcement about PostgreSQL being added as a CNA on the CVE website.

The Case of FileTable with Basic Availability Groups

Using FileTables with Basic Availability Groups in SQL Server offers a robust solution for storing non-relational data but requires careful management due to potential risks like data corruption during long transactions and failovers. While BAG ensures data integrity, challenges arise(…)

Do we need DBAs in 2023?

Introduction : Over the past months, people asked me more and more questions about the DBA role and the underlying question was often: Are we witnessing the end of the DBA role in IT? My first answer, after a big(…)