Infrastructure at your Service

 
Michael Hein

Cause for looping sssd

By | Operation systems | No Comments

In RedHat Enterprise Linux 7, the sssd daemons can connect to active directory servers. Default behaviour is to update DNS entries dynamically. If a statical DNS entry already exists this can lead to a CPU consuming sssd_nss daemon. To prevent this behaviour, the dynamic DNS updates should be switched off with this setting in every doman section of config file /etc/sssd/sssd.conf: dyndns_update = False After that sssd should be restarted to take this change effect.

Read More
Daniel Westermann

The EDB filter log extension

By | Database Administration & Monitoring | No Comments

This is another post dedicated to EnterpriseDB Postgres. Sometimes you may want to get specific messages not getting logged to the server’s logfile or audit records. That might be specific error codes or, even more important, passwords you specify when you create users. EDB comes with a solution for that by providing an extension which is called EDB Filter Log. Lets see how you can install, and even more important, how to use that extension.

Read More
Daniel Westermann

Auditing with EDB Postgres Enterprise

By | Database Administration & Monitoring | No Comments

It might be that there is a requirement to audit operations in the database. Maybe because of legal requirements, maybe because of security requirements or whatever. I’ve already written a post in the past describing what you can do in community PostgreSQL, this post is specific to EDB Postgres. The auditting features come be default in EDB Postgres and you do not need to install any extension such as pgaudit.

Read More
David Barbarin

Windocks, SQL Server and Azure in our internal CI pipeline

By | Cloud, DevOps, Docker, Kubernetes, SQL Server | One Comment

During the last DevOps Day in Geneva, I presented a sample of our CI implementation related to our MSSQL DMK maintenance product. It was definitely a very good experience for me and good opportunity to get feedback from DevOps community as well. During the session I explained our CI pipeline includes SQL Server containers both on AKS (K8s as managed service in Azure) and Windocks. I got questions from some of attendees who asked me…

Read More
Diawo Mayaki

How To Push An Image Into Amazon ECR With Docker

By | Cloud | No Comments

8 Steps To Push An Image Into Amazon ECR With Docker Please bear in mind that Amazon elastic container registry (ECR) is a managed AWS Docker registry service. In this topic, we will use the Docker CLI to push an CentOS image into Amazon ECR. 1. Install Docker desktop for Windows and AWS CLI Verify and confirm that each version has been installed properly (see below): docker (dash dash)version aws (dash dash)version 2. Authentication to AWS Open Power…

Read More
Petre Radut

When you change the UNDO_RETENTION parameter, the LOB segment’s retention value is not modified

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Oracle | No Comments

Below, I will try to explain, a particular case for the general error : ORA-01555 snapshot too old error.. Normally, when we have this error, we are trying to adapt the retention parameters or to tune our queries. SQL> show parameter undo; NAME TYPE VALUE ———————————— ———– —————————— temp_undo_enabled boolean FALSE undo_management string AUTO undo_retention integer 3600 –extended from 900, undo_tablespace string UNDOTBS1 But, are some scenarios where the above rule is not working . We…

Read More
Stephane Biehler

OpenText Enterprise World Europe 2019 – Day 3

By | Application integration & Middleware, Cloud, Database Administration & Monitoring | No Comments

Last but not least, today was mainly dedicated to demos and customer cases. It started with the global stream presenting some OpenText applications like Core for Quality: An application developed with AppWorks and integrated to Magellan. It was meant to manage quality issues and connected to Documentum in order to link issues with SOP documents. In the different demos we saw the integration of these SaaS applications in OT2 and their responsiveness (drag and drop…

Read More
Stephane Biehler

OpenText Enterprise World Europe 2019 – Day 2

By | Application integration & Middleware, Cloud, Database Administration & Monitoring, Entreprise content management | No Comments

Day 2 of OTEW, we followed the global stream this morning which was taking most of the points from yesterday. But we had the pleasure to have a session from Dr. Michio Kaku, Theoretical Physicist, Futurist and popularizer of science. He wrote several books about physics and how he sees the future. He sees us in the next 20 years ultra connected with internet lenses, the Moore’s law will collapse in 2025 where it will…

Read More
David Barbarin

Upgrading SQL Server pods on K8s and helm charts

By | Database Administration & Monitoring, DevOps, Docker, Kubernetes, SQL Server | No Comments

It has been while since my last blog. Today it is about continuing with helm charts and how to upgrade / downgrade SQL Server containers to a specific cumulative update. My first write-up in my to-do list. Last year, I wrote an introduction of SQL Server containers on K8s. I remembered to face some issues when testing upgrade scenarios (probably a lack of knowledge). Since then, I have discovered helm charts and I use them…

Read More
Lazhar Felahi

SQL Tuning – Mix NULL / NOT NULL Values

By | Development & Performance, Oracle | No Comments

One of the difficulty when writing a SQL query (static SQL) is to have in the same Where Clause different conditions handling Null Values and Not Null Values for a predica. Let’s me explain you by an example : Users can entered different values for a user field from an OBI report: – If no value entered then all rows must be returned. – If 1 value entered then only row(s) related to the filter…

Read More