All articles

Multitenant, PDB, ‘save state’, services and standby databases

By Franck Pachot . Creating - and using - your own services has always been the recommendation. You can connect to a database without a service name, though the instance SID, but this is not what you should do. Each(…)

Introducing SQL Server on Docker Swarm orchestration

SQL Server 2017 is available on multiple platforms: Windows, Linux and Docker. The latter provides containerization features with no lengthy setup and special prerequisites before running your SQL Server databases which are probably the key success of adoption for developers.

Migrate Windows VM with more than 4 Disks from VMware to OVM

Suppose you got an OVA image created on VMware and the VM contains more than 4 Disks and you have to migrate this machine from VMware to OVM. As first step you import the OVA into the OVM in(…)

Result Cache: when *not* to use it

By Franck Pachot . I encountered recently a case where result cache was incorrectly used, leading to high contention when the application encountered a peak of load. It was not a surprise when I've seen that the function was called(…)

Testing Oracle SQL online

By Franck Pachot . Want to test some DDL, a query, check an execution plan? You need only a browser. And you can copy-paste, or simply link, your test-case in a forum, a tweet, an e-mail, a tweet. Here is(…)

Explain Plan format

By Franck Pachot . The DBMS_XPLAN format accepts a lot of options, which are not all documented. Here is a small recap of available information. The minimum that is displayed is the Plan Line Id, the Operation, and the Object(…)

Unplug an Encrypted PDB (ORA-46680: master keys of the container database must be exported)

By Franck Pachot . In the Oracle Database Cloud DBaaS you provision a multitenant database where tablespaces are encrypted. This means that when you unplug/plug the pluggable databases, you also need to export /import the encryption keys. You cannot just(…)

SQL Server on Linux and logging

On Windows world, SQL Server logs information both into the SQL Server error log and the Application log. Both automatically timestamp all recorded events. Unlike the SQL Server error log, the Windows application log provides an overall picture of events(…)

Alfresco DevCon 2018 – Day 2 – Big files, Solr Sharding and Minecraft, again!

Today is the second day of the Alfresco DevCon 2018 and therefore yes, it is already over, unfortunately. In this blog, I will be continuing my previous(…)

Alfresco DevCon 2018 – Day 1 – ADF, ADF and… ADF!

Here we are, the Alfresco DevCon 2018 day-1 is over (well except for the social party)! It’s been already 2 years I attended my last Alfresco event (BeeCon 2016, first of its name (organized by the Order of(…)