Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
The question to migrate or not to the Cloud comes more and more often now. There are some added values to go to the Cloud as analytics capabilities, scalability and flexibility, cost saving, no dedicated hardware and its related maintenance, no maintenance for patch, no worry to have about HA, DR or Data Protection. We can easily understand this. But…
Introduction Hi Team Here we go again , last time we have seen how to install Redis on Windows 10 using Redis binaries , let’s see the 2nd method I used to install Redis on my machine and of course how to link it to RedisInsight. For that we will install a Linux/Unix from Microsoft store.I have selected openSUSE OS…
Today I had the chance to move forwar with performance testing and some checks on two Flexible Server – Azure Database for PostgreSQL, one with 8vCPU, 64GB RAM and 512GB Storage (2300 IOPs) and another one with the same vCPU and Memory, but 2TB Storage (7500 IOPs). Microsoft told me that they have replaced the used Linux, from Ubuntu 18.04…
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 could be better than being able to install it on your Windows machine?:) ( I know ,I know : having it on a Linux…
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 an IP address will be needed on the bridge interface. I have demonstrate and explain this in one of my…
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 migration and mobility, monitoring, and performance. Last year, Microsoft developers made 42 improvements to the service SQL Managed instance. As you…
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 by security and best practice is disabled – So no possibility to login with a sqlcmd or your SSMS (SQL Server…
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 the Cloud Providers, neither of the database servers are available in the public internet or you are using Oracle Standard Edition where…
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 and Plug of pluggable database We plan to unplug the pluggable database PDB1 from PROD01 and plug it into CLNE02. Both container have TDE configured…
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! Elastic Database Jobs So first, we need to check Elastic Database Jobs. Elastic Database Jobs (preview) – Azure SQL Database | Microsoft Learn …
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 if it is of a reasonable size, then an offline approach may be desirable. This will have the advantage of also working…
