Infrastructure at your Service

 
Jérôme Dubar

Should I go for ODA 19.5 or should I wait until 19.6?

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

Introduction As you may know, Oracle Database 19c is available for new (X8-2) or older Oracle Database Appliances since several weeks. Current version is 19.5. But when you go to the official ODA documentation , it still first proposes version 18.7 not compatible with 19c databases. Here is why. 19c database is the final 12.2 First of all, 19c is an important release because it’s the terminal release of the 12.2, as 11.2.0.4 was for…

Read More
Franck Pachot

ROLLBACK TO SAVEPOINT;

By | Oracle | No Comments

By Franck Pachot . I love databases and, rather than trying to compare and rank them, I like to understand their difference. Sometimes, you make a mistake and encounter an error. Let’s take the following example: create table DEMO (n int); begin transaction; insert into DEMO values (0); select n “after insert” from DEMO; update DEMO set n=1/n; select n “after error” from DEMO; commit; select n “after commit” from DEMO; The “begin transaction” is…

Read More
Cesare Cervini

Tracking Logs Inside a Documentum Container (part II)

By | Entreprise content management | No Comments

Testing the log watcher This is part II of the article. Part I is here. All the above code has to be included in the entrypoint script so it gets executed at container start up time but it can also be tested more simply in a traditional repository installation. First, we’ll move the code into a excutable script, e.g. entrypoint.sh, and run it in the background in a first terminal. Soon, we will notice that…

Read More
Cesare Cervini

Tracking Logs Inside a Documentum Container (part I)

By | Entreprise content management | No Comments

Containers running under docker can have their stdout observed from the outside through the “docker logs”command; here is an excerpt of its usage: docker logs –help Usage: docker logs [OPTIONS] CONTAINER Fetch the logs of a container Options: –details Show extra details provided to logs -f, –follow Follow log output –since string Show logs since timestamp (e.g. 2013-01-02T13:23:37) or relative (e.g. 42m for 42 minutes) –tail string Number of lines to show from the end…

Read More
Stéphane Haby

SQL Server Tips: Path of the default trace file is null

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

In addition of my precedent blog about this subject “SQL Server Tips: Default trace enabled but no file is active…”, I add a new case where the default path of the trace file was empty. The first step was to verify if the default trace is enabled with the command: SELECT * FROM sys.configurations WHERE name=’default trace enable’ It is enabled, then I check the current running trace with the view sys.traces SELECT * FROM…

Read More
Saïd Mendi

PostgreSQL Meetup at CERN, Geneva, January 17, 2020

By | Database Administration & Monitoring, Postgres | No Comments

Registration Last Friday (17/01/20) I had the opportunity to go to Geneva at CERN to attend a PostgreSQL meetup. I’m really happy to write a blog about for a lot of reasons. First of all, it was about PostgreSQL (essential these days), also for the contributors as Oleg Bartunov and finally because of the organizers: Franck Pachot (old & soon new colleague by dbi-services) & Laeticia Avrot I met at the SOUG Day in Lausane.

Read More
Daniel Westermann

Adding PostgreSQL extensions without being super user?

By | Database Administration & Monitoring | 2 Comments

Usually, when you need to install a PostgreSQL extension you do this as superuser (or at least I am doing it like this). The downside of that is, of course, that a super user must be available once a new extension is required or that all the extensions are installed by default (e.g. in template1). Recently the question popped up internally if you can install extensions without being super user. The answer is: yes and…

Read More
Jérôme Dubar

Make Oracle database simple again!

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

Introduction Let’s have a look at how to make Oracle database as simple as it was before. Oracle database is a great piece of software, yes it’s quite expensive, but it’s still the reference and most of the companies can find a configuration that fits their needs according to a budget. Another complain about Oracle is the complexity: nothing is really simple, and you’ll need skillful DBA(s) to deploy, manage, upgrade, troubleshoot your databases. But…

Read More
Stéphane Haby

One day training @ Microsoft Azure Cloud Workshop

By | Big Data, Cloud, Database Administration & Monitoring, Database management, SQL Server, Technology Survey | No Comments

Today, with my colleague Christophe, we follow the Microsoft Azure Training Day: Data and Analytics @ Microsoft Zürich (Wallisellen to be exact). After a presentation of SQL Server 2019, we begin with the First Lab about SQL Server 2019 and new features and we going through intelligent query processing, Data Discovery and Classification for personally identifiable information (PII) and General Data Protection Regulation (GDPR) and secure enclave. One of my favorites part of the lab…

Read More