All articles

FreeBSD basics – 1 – The first steps

In case you follow the blogs here, you might have noticed that I got interested in FreeBSD over the last months (or even year(s)). The reasons for this are multiple: FreeBSD development is organized in very(…)

PostgreSQL: Maybe we should give ZFS a chance (3) – testing with an aligned record size

In the last post about PostgreSQL on ZFS the pgbench tests showed, that ZFS was slower for the standard tests compared to ext4 on Debian. A comment to that post made me wonder if changing the ZFS record size(…)

DPR and Dbvisit Standby on ODA

Introduction Since patch version 19.21 (current one is 19.25), Oracle Database Appliance (ODA) X7, X8 and X9 will require the use of Data Preserving Reprovisioning (DPR) to apply the patch coming from 19.20 and previous releases. Unlike traditional patching, DPR(…)

Export Data to Azure Storage with SSIS: Solving the ‘Unable to Create Azure Blob Container’ Error

1        Introduction Hello, Readers! While exporting data to Azure Blob Storage using SQL Server Integration Services (SSIS), I encountered the “Unable to create Azure container” error. This article will guide you through a straightforward solution, aiming to save you time(…)

Documentum – 23.4 doesn’t like IPv6 being disabled?

I often see customers with Virtual Machines or Containers that have IPv6 disabled. I assume this is mainly for simplicity, since most services are usually only running internally, and organizations don’t really need more IPs than what IPv4 can provide(…)

PostgreSQL: Maybe we should give ZFS a chance (2) – testing

In the last post we’ve set the baseline for comparing ext4 to zfs when it comes to PostgreSQL. We’ve ended with two PostgreSQL clusters, one running on the ext4 file system while the other is running(…)

New SQL Server Management Studio Version 21 – First Test

Last week, at the Pass Data Summit, they announce the new version of SQL Server Management Studio: SSMS 21 You can find the preview in here. It’s a good opportunity to test this new version before installing it(…)

Ace Your Certification Exams with Confidence: A Proven Recipe for Success

1        Introduction Recently, a colleague approached me, saying, “Hey Nicolas, I’m thinking of going for the PL-300 (Microsoft Power BI Data Analyst Associate) certification. Do you have any advice on how to pass it with confidence?” As knowledge sharing is(…)

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: Maybe we should give ZFS a chance (1) – baseline

Recently I’ve switched my PostgreSQL playground from Linux to FreeBSD. Not because I don’t like Linux anymore, just because I like trying out other operating systems and see what works the same and what is different.