Oracle, Security Secure your SQL scripts with an Oracle wallet 16.12.2022 by Jérôme Dubar How to secure your SQL script and remove password using Oracle wallets(…)
Database Administration & Monitoring, Database management, Oracle Applying RU on Enterprise Manager 13c R5 16.12.2022 by Oracle Team By Mouhamadou Diaw We often apply Oracle Database RU. Like database Release Update can also be passed on Enterprise Manager. On this blog I am describing how we can update an OEM 13cR5 Update 10 to(…)
Database Administration & Monitoring Redis:Hands-on with Redis ,train with Redisinsight on Windows! 16.12.2022 by Middleware Team What is Redis? Redis which stands for Remote Dictionary Server is “an in-memory data structure store, used as a distributed, in-memory key–value database, cache and message broker, with optional durability” It is a Nosql database which offer you(…)
Database Administration & Monitoring, Database management PostgreSQL 16: Further reducing tasks that require superuser 14.12.2022 by Daniel Westermann In a previous post we’ve seen that vacuum and analyze operations can be granted to users which are not superuser starting with PostgreSQL 16. Work is still(…)
Database Administration & Monitoring, Database management New cast testing functions for PostgreSQL 16 13.12.2022 by Daniel Westermann As the development of PostgreSQL moves on, more and more new features get committed. A recently commit patch added two new functions, which can be used to validate if a cast will work and what error message would be(…)
Ansible, Application integration & Middleware, YaK Overcome jboss-cli Limitations with Ansible 12.12.2022 by Middleware Team The work on YaK JBoss/WildFly component helped me to improve my knowledge of Ansible, but not only. I also learned a lot on jboss-cli scripting and especially limitations that comes with it. For instance, followings(…)
Database Administration & Monitoring, Database management, Development & Performance Improve your development experience in PostgreSQL’s PL/pgSQL by using plpgsql_check 09.12.2022 by Daniel Westermann In the last post we’ve highlighted some tips when developing functions and/or procedures in PostgreSQL’s PL/pgSQL. Especially the Compile-Time and Run-Time checks can save you a lot of work and give you important hints while(…)
Ansible, DevOps, Operating systems cloud-init native Ansible support 07.12.2022 by Jérôme Witt Cloud-init is a software developed to setup automatically a cloud virtual machine using metadata ingested and applied at the first boot or at a chosen frequency. All the magic happens through a #cloud-config YAML file. #cloud-config already supports Ansible(…)
Control-M Control-M/EM : Use case workload policy and odate 07.12.2022 by Middleware Team Introduction Hi team I had a request to block a bunch of jobs in order to allow another to perform a maintenance task on the related servers/applications , but only for specific date and time window(example for(…)
Database Administration & Monitoring, Database management, Development & Performance Some tips when developing in PostgreSQL’s PL/pgSQL 06.12.2022 by Daniel Westermann When you develop functions or procedures in PostgreSQL’s PL/pgSQL there are some points to consider, which make your life easier. This post is not about control structures,(…)