All articles

OctoPerf Load Testing

OctoPerf is a SaaS tool based on Apache JMeter, the load test functional behavior and measure performance reference tool. Among others, it has several advantages compared to JMeter: It can integrate(…)

Redis : Redis installation on Windows 10 : 1st method

Introduction Hi Team As you know Redis is an open source, in-memory data store used by millions of developers as a database, cache, streaming engine, and message broker. Such a pretty cool tool , so what(…)

ODA vnetwork bridge with no IP address

It is not mandatory to setup an IP address on a bridge interface. A bridge forwards packets at MAC layer. But of course, if I would like to reach the DB System or the Compute Instance from the ODA, then(…)

SQLBits 2023 -Day 1-A day with SQL Managed Instance

Tuesday 14.03.23 was the first day of SQLBits. This day was dedicated to the workshop, and I chose to follow “A Day with SQL Managed Instance”.During this day, we talked about provisioning, connection and configuration, security, but also data(…)

Lost access to SQL Server. Now what ?

In this blog we will explain what to do to regain the access to your SQL Server instance. Here is our scenario : – You have by accident removed all logins in SQL Server instance – Your sa account(…)

Oracle Database Backup Cloud Service

In a previous blog I demonstrated how to migrate an Oracle database from AWS to Oracle OCI using Data Guard. But what if you want to migrate to the Oracle Cloud, but don’t have a direct connection between(…)

Unplug/Plug PDB in TDE Environment

By Mouhamadou Diaw In an oracle environment with Transparent Data Encryption (TDE) the transfer of PDB may require additional steps. In this blog we will see some steps which may be required when doing Unplug(…)

Why you should consider keeping your ODA more than 5 years

ODA is a long-lifetime platform!(…)

Maintenance Azure SQL DBs in Elastic Pool (Private Endpoint) – example based on index fragmentation – password less – azure managed identity

How do you check and rebuild your indexes for Azure SQL DBs in Elastic Pool? That question is getting even more interesting if you have only Private Endpoint enabled to connect to the MSSQL DB.  Lets get started! (…)

Move SQL Server database files to different folders with PowerShell

In my previous post, I explained how to move SQL Server databases files programmatically by leveraging the high availability of an Availability Group (AG).But when you can afford to have a database unavailable for a short time, and(…)