Infrastructure at your Service

Category

Database Administration & Monitoring

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
Elisa Usai

The evolution of MySQL authentication mechanism

By | Database Administration & Monitoring, Database management, MySQL, 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
Nabil Saoual

Control-M/EM : job in wait hosts status

By | Control-M, Database Administration & Monitoring | No Comments

Hello everybody, Introduction Today we will try to debug a classic case of schedulers: The wait host status. Context: On monitoring domain, one or more jobs are not submitted to the host then are in blue (wait host) status Example: The aim is to know what is happening to this job and fix it Analysis The aim is to troubleshoot what could be one of the root cause the host in unavailable and fix it…

Read More
Franck Pachot

The myth of NoSQL (vs. RDBMS) agility: adding attributes

By | AWS, Database Administration & Monitoring, NoSQL, Oracle, Postgres, SQL Server | 3 Comments

By Franck Pachot . There are good reasons for NoSQL and semi-structured databases. And there are also many mistakes and myths. If people move from RDBMS to NoSQL because of wrong reasons, they will have a bad experience and this finally deserves NoSQL reputation. Those myths were settled by some database newbies who didn’t learn SQL and relational databases. And, rather than learning the basics of data modeling, and capabilities of SQL for data sets…

Read More
Jérôme Dubar

Terraform and Oracle Cloud Infrastructure

By | Cloud, Database Administration & Monitoring, Development & Performance, Operation systems, Oracle | No Comments

Introduction When you learn a cloud technology, like OCI, the one from Oracle, you start building your demo infrastructure with the web interface and numerous clicks. It’s convenient and easy to handle, even more if you’re quite used to infrastructure basics: network, routing, firewalling, servers, etc. But when it comes to build complex infrastructures with multiple servers, subnets, rules, databases, it’s more than a few clicks to do. And rebuilding a clone infrastructure (for example…

Read More
Nabil Saoual

Control-M/EM configure GUI display to dissociate each environment

By | Database Administration & Monitoring | No Comments

Hi everybody, today this quick topic will show us how to dissociate easily your different Control M environments Introduction In your daily activity on Control M, you may work on many Control M servers with different level of criticality For example, you can perform tasks on production environment and on a testing environment but changes on your Control M GUI or on CCM may not have the same impact So it can be useful and…

Read More
Mouhamadou Diaw

Migrating From Oracle Non-CDB 19c to Oracle 20c

By | Database Administration & Monitoring, Oracle | 2 Comments

With Oracle 20c, the non-multitenant architecture is no longer supported. So, people will have to migrate their databases to container if they want to use Oracle 20c. There are many methods to transform a non-cdb database to a pluggable one. -Datapump -Full Trabsportable Tablespaces -Plugging non-cdb database , upgrade the plugged database and then convert -Upgrading the non-cdb database, then plug it the container and then convert it ( But I am not sure that…

Read More
Jérôme Dubar

ODA 19.6 is available

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

Introduction It’s been 1 year now that 19c is available on-premise. Finally, 19c is now available today on ODA too, in a real production release. Let’s have a glance of what’s inside. Is 19.6 available for my old ODA? The 19.6 release, like most recent releases, is the same for all ODAs. But oldest ODAs will not support it. First-gen ODA (now 8 years old), X3-2 (7yo) and X4-2 (6yo) won’t support this very latest…

Read More
Stéphane Savorgnano

How Windows Admin Center can backup on Azure

By | Database Administration & Monitoring, Operation systems, SQL Server | No Comments

To be honest I never used before Windows Admin Center but after some hours of utilization I’m still convinced. As SQL Server Management Studio is a great tool to manage our SQL Server instances with a CMS (Centralized Management Server), Windows Admin Center is a great tool to centralize the management of our Physical, Virtual, on-premises…Windows Server. This browser-based tool is also a hybrid tool which is able to integrate your on-premises servers with Azure…

Read More
Stéphane Savorgnano

How to run Avamar backup on SQL Agent Job with PowerShell

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

By one of our customer we use Avamar for the backup and restore solution. I was asked by this customer to find a solution to run Avamar backups for a group of databases on a specified instance. In fact, we currently try a database clone solution on some instances and clone’s databases must not be backed up, but the rest of the databases must be. After some discussions with my colleague I decided to use…

Read More