With more than three years of experience as a Database Administrator specializing in SQL Server and PostgreSQL, Adrien Obernesser focuses on performance tuning. He is skilled at diagnosing issues on customer servers and delivering actionable improvement plans, backed by solid leadership experience in cross-cultural environments. Prior to dbi services, he served as Operations Manager and Consultant DBA at Zen-Conseil. His industry experience spans the defense, telecommunications, and industrial sectors.
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 meeting this amazing community in person and I was immediately struck by the camaraderie and shared passion for PostgreSQL. The…
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 experienced it all.Having participated in numerous projects and developed substantial code, you have begun to receive feedback from your Sysadmins…
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. This move marks a pivotal moment for PostgreSQL administrators and users. The Root CVE for Postgresql is RedHat. This last one has only been…
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 from large file handling, streaming, and the absence of Read-Only replicas.
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 laugh, was that DEVOPS didn’t get rid of sysadmins, it is not going to get rid of DBAs, especially with…
