Infrastructure at your Service

 
Stéphane Savorgnano

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

By | Cloud, Database Administration & Monitoring, Database management, SQL Server | No Comments

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 group. This group will contain one or more VMs which will share the same backup configuration for retention, synchronization and recovery. Protection is managed as follow: DPM create a copy of the selected data on the…

Read More
Franck Pachot

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

By | Cloud, Oracle | No Comments

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 limited in time (I still have the 11g XE I’ve created 2 years ago running there) being able to use 40% of CPU with 2GB of RAM: top – 21:53:10 up 16 min, 4 users, load average:…

Read More
Jérôme Dubar

Oracle Database Appliance: which storage capacity to choose?

By | Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

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 of 5 years, and combined with software updates generally available for up to 7 years old ODAs, you can keep your ODA running even longer for non-critical databases and/or if you have a strong Disaster…

Read More
Franck Pachot

20c: AWR now stores explain plan predicates

By | Oracle | No Comments

By Franck Pachot . In a previous post https://blog.dbi-services.com/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 to its customers through support (enhancement requests), though the community (votes on database ideas), and through the product managers who participate in User Groups and ACE program. And here it is: in 20c the predicates are collected by AWS and…

Read More
Stéphane Haby

SQL Server 2019: Copy files through SQL Server

By | Database Administration & Monitoring | No Comments

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 folder+file’ Example: exec master.sys.xp_copy_file ‘C:\Temp\Sources\File1.txt’, ‘C:\Temp\Destinations\File1.txt’ Before the command: After the command: As you can see in my test, you will have these 2 information where indicate the sucess of the query: Commands completed successfully. Time:…

Read More
Stéphane Savorgnano

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

By | Cloud, Database Administration & Monitoring, SQL Server | No Comments

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 will today installed a MABS on one of my virtual on-premise server and uses it to protect my others virtual on-premises servers. To do so you go to your Azure Recovery Services vault. A vault is…

Read More
Lazhar Felahi

Oracle Materialized View Refresh : Fast or Complete ?

By | Database Administration & Monitoring, Oracle | 2 Comments

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 have the materialized view up to date. I will not show you the materialized view concepts, the Oracle Datawarehouse Guide is perfect for that. I will show you, from a user real case,  all steps…

Read More
Alain Lacour

APEX Connect 2020 – Day 2

By | Application integration & Middleware, Development & Performance, Oracle | No Comments

For the second and last virtual conference day, I decided to attend presentations on following topics: – Universal Theme new features – Oracle APEX Source Code Management and Release Lifecycle – Why Google Hates My APEX App – We ain’t got no time! Pragmatic testing with utPLSQL – Why APEX developers should know FLASHBACK – ORDS – Behind the scenes … and more! and the day ended with a keynote from Kellyn Pot’Vin-Gorman about “Becoming…

Read More
Clemens Bleile

Handle DB-Links after Cloning an Oracle Database

By | Oracle | No Comments

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 after cloning production data jobs may still try to modify data through e.g. db-links. I.e. scheduled database jobs must not start in the cloned DB and applications connecting to the cloned database must not modify…

Read More
Morgan Patou

Documentum Upgrade – dm_DataDictionaryPublisher with wrong target server

By | Application integration & Middleware, Entreprise content management | No Comments

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 from Documentum 7.x to 16.x versions. During this process, just before the upgrade, a cloning is done to a staging environment, to keep the source untouched.   As part of this cloning, an update of the target_server value of the dm_job objects is…

Read More
Alain Lacour

APEX Connect 2020 – Day 1

By | Development & Performance, Oracle | No Comments

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 speech and the very interesting Keynote about “APEX 20.1 and beyond: News from APEX Development” by Carsten Czarski, I decided to attend presentations on following topics: – The Basics of Deep Learning – “Make it…

Read More
Elisa Usai

The evolution of MySQL authentication mechanism

By | Database Administration & Monitoring, Database management, Security | No Comments

The authentication, the first level of security for each IT system, is the stage to verify the user identity through the basic username and password scheme. It is crucial to have a mechanism to protect and secure password storing and transmitting over network. In MySQL, there is plenty of different authentication methods available, and last versions improved the security of this concept.

Read More