All articles

Manage Feathers.js authentication in Swagger UI

In addition to my previous articles Add a UI to explore the Feathers.js API and Add authentication in a Feathers.js REST API, today, I will explain how to manage Feathers.js authentication in Swagger UI and make it(…)

“Edit Top 200 rows” does not work between SSMS 18.12.1 & SQL Server 2022

Recently after a migration from SQL Server 2012 to SQL Server 2022, a end user contact me because SQL Server Management Studio (SSMS) does not work anymore when he want t o edit rows… I was surprised and do a(…)

Power BI – Scheduled refresh stuck

Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the “import mode.” In this mode, the data is imported or copied into our reports to be included.

SQL Server: Basic AG – One listener, multiple databases

Introduction When it is not possible to have SQL Server Enterprise and there is a need to set up an AlwaysOn cluster, it is possible to use SQL Server Standard and implement basic availability groups. However, the Standard edition of(…)

CloudNativePG – Connecting external applications

Now that we know how we can benchmark a CloudNativePG deployment, it is time to look at how we can connect external applications to the PostgreSQL cluster. Usually, applications run in the same Kubernetes cluster and(…)

Setting up MariaDB Galera Cluster

In this blog I will show you how you can setup a basic MariaDB Galera Cluster on Debian 11 (bullseye).If you wish to have a more general overview first you can have a look here: https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/(…)

Alfresco – Impact of SSL and LB on the import perf.

Have you ever wondered what is the impact of SSL communications or the impact of a specific Load Balancing mechanisms on the performance of your Alfresco environment? Alfresco (the Company at that time, before it became Hyland) ran some benchmark(…)

Automatic Transaction Rollback in Oracle Database 23ai

In the Oracle Database 23ai Enterprise Edition, it is now possible to automatically rollback some transactions, and a set of new parameters have been added to control this behavior. Of course implementing this feature requires deep understanding of your application,(…)

Hot Clone of a Remote PDB in a Dataguard Environment 19c

Introduction In Oracle Database 19c, if you have a Dataguard Configuration of a multitenant database, and you want to clone a pluggable database from a remote server to your primary, then you have to mind that the dataguard mechanism is(…)

And what about cloning a PDB in a Data Guard environment on ExaCC?

I have recently blogged about how to create a new PDB on ExaCC in a Data Guard environment, see https://www.dbi-services.com/blog/create-new-pdb-in-a-data-guard-environment-on-exacc/. And what about if I clone a PDB on the primary CDB? Let’s see. Clone PDB on the primary(…)