All articles

Use MABS to protect Hyper-V on-premises VMs workload

During my last blog post I explained how to installed a MABS. Now that your infrastructure is setup you will be able to protect the workload of your Hyper-V Virtual Machines. You have first to create a new protection(…)

Always free / always up tmux in the Oracle Cloud with KSplice updates

By Franck Pachot . I used to have many VirtualBox VMs on my laptop. But now, most of my labs are in the Cloud. Easy access from everywhere. GCP There’s the Google Cloud free VM which is not(…)

Oracle Database Appliance: which storage capacity to choose?

Introduction If you’re considering ODA for your next platform, you surely already appreciate the simplicity of the offer. 3 models with few options, this is definitely easy to choose from. One of the other benefit is also the hardware support(…)

20c: AWR now stores explain plan predicates

By Franck Pachot . In a previous post https://www.dbi-services.com/blog/awr-dont-store-explain-plan-predicates/ I explained this limitation in gathering filter and access predicates by Statspack and then AWR because of old bugs about reverse parsing of predicates. Oracle listens(…)

SQL Server 2019: Copy files through SQL Server

Three new interesting extended stored procedures comes with SQL Server 2019. I was very interested to discover these new store procedures: Sys.xp_copy_file is to copy a specific files from a folder to another Syntax: exec master.sys.xp_copy_file ‘source folder+file’, ‘destination(…)

How to install MABS (Microsoft Azure Backup Server) and use it to protect on-premise virtual machines

During my last blog-posts I tested the MARS (Microsoft Azure Recovery Service) through Windows Admin Center and how to use Azure Backup to recover files/folders or System State for protected servers. To continue my Azure protection possibilities overview I(…)

Oracle Materialized View Refresh : Fast or Complete ?

In contrary of views, materialized views avoid executing the SQL query for every access by storing the result set of the query. When a master table is modified, the related materialized view becomes stale and a refresh is necessary to(…)

Handle DB-Links after Cloning an Oracle Database

By Clemens Bleile After cloning e.g. a production database into a database for development or testing purposes, the DBA has to make sure that no activities in the cloned database have an impact on data in other production databases. Because(…)

Documentum Upgrade – dm_DataDictionaryPublisher with wrong target server

As part of the same migration & upgrade project I talked about in previous blogs already (corrupt lockbox & duplicate objects), I have seen a strange but consistent behavior in each upgrade(…)

APEX Connect 2020 – Day 1

This year the APEX connect conference goes virtual online, like all other major IT events, due to the pandemic. Unfortunately it spans only over two days with mixed topics around APEX, like JavaScript, PL/SQL and much more. After the welcome(…)