Infrastructure at your Service

Category

Database Administration & Monitoring

Daniel Westermann

Where can you find core developers asking people what is missing in PostgreSQL? pgconf.eu.2019

By | Database Administration & Monitoring | No Comments

One of the major advantages of PostgreSQL conferences when you compare it to other conferences is, that you can listen to talks where the actual developers are presenting their work. You have questions about a feature, you want to know more about this or that: Just catch one of the developers and start to talk. It is as easy as that. Today it was even more impressive: Alvaro came to our booth and asked what…

Read More
Daniel Westermann

Creating a customized PostgreSQL container using buildah

By | Database Administration & Monitoring | No Comments

Quite some time ago I blogged about how you could build your customzized PostgreSQL container by using a Dockerfile and Docker build. In the meantime Red Hat replaced Docker in OpenShift and SUSE replaced Docker as well in CaaS. As a consequence there need to be other ways of building containers and one of them is buildah. You can use buildah to build from a Docker file as well, but in this post we will…

Read More
Clemens Bleile

Oracle 19c

By | Database Administration & Monitoring | No Comments

Oracle 19c has been released quite a while ago already and some customers already run it in Production. However, as it is the long term supported release, I thought I blog about some interesting information and features around 19c to encourage people to migrate to it. Download Oracle 19c: https://www.oracle.com/technetwork/database/enterprise-edition/downloads or https://edelivery.oracle.com (search e.g. for “Database Enterprise Edition”) Docker-Images: https://github.com/oracle/docker-images/tree/master/OracleDatabase Oracle provides different offerings for 19c: On-premises: – Oracle Database Standard Edition 2 (SE2) –…

Read More
David Barbarin

SQL Server 2019 Accelerated Database Recovery – Instantaneous rollback and aggressive log truncation

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

In my previous article about Accelerated Database Recovery (ADR), I wrote mostly about the new Persistent Volume Store (PVS), how important it was important in the new SQL database engine recovery process and the potential impact it may have on the application workload. This time let’s talk a little bit more about ADR feature benefits we may get with instantaneous rollback and aggressive log truncation. These two capabilities will address some DBA pains especially when…

Read More
Cesare Cervini

Documentum Administrator in a Container

By | Database Administration & Monitoring | No Comments

In article A Small Footprint Docker Container with Documentum command-line Tools, we presented a possible way to containerize the usual Documentum clients idql, iapi, dmawk and dmdocbroker. Those are command-line tools mostly used in batch processing or for one-of-its-kind manual tasks such as investigating or troubleshooting. OpenText also offers Documentum Administrator (aka DA), a java WDK-based client which is very useful for the occasional manual tasks. With its GUI running in a browser, it gives…

Read More
Cesare Cervini

A Small Footprint Docker Container with Documentum command-line Tools

By | Database Administration & Monitoring | No Comments

The aim here is to have a minimalist container with the usual Documentum clients idql, iapi, dmawk and dmqdocbroker. Documentum Administrator (DA) could also be a useful addition to our toolbox. We will show how to containerize it in a future article. A word of warning is in order here: the title’s catchy “small footprint” qualifier is relative. Don’t forget that said container will contain a certified O/S, a JRE, the DFCs and a few…

Read More
Marc Wagner

Migrating Oracle database from windows to ODA

By | Database Administration & Monitoring | 2 Comments

Nowadays I have been working on an interesting customer project where I had to migrate windows oracle standard databases to ODA. The ODAs are X7-2M Models, running version 18.5. This version is coming with Red Hat Enterprise Linx 6.10 (Santiago). Both windows databases and target ODA databases are running PSU 11.2.0.4.190115. But this would definitively also be working for oracle 12c and oracle 18c databases. The databases are licensed with Standard Edition, so migrating through…

Read More
David Barbarin

Using non-root SQL Server containers on Docker and K8s

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

This is something that I waited for a while, in fact since SQL Server 2017 … and the news came out on Wednesday 09th September 2019. Running Non-Root SQL Server Containers is now possible either on the next version of SQL Server (2019) and it has been backported on SQL Server 2017 as well. Non-root SQL Server containers will likely be part of hidden gem of SQL Server new features, but this is definitely a…

Read More
Grégory Steulet

Managing Licenses with AWS License Manager

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

Introduction Computing environments became more and more agile over these last years. Companies need to provide solutions helping people to quickly set up new resources, starting and stopping them, scaling them according to the need and finally, removing them. In such environments, it could be tricky to follow license compliance when resources are changing on hourly basis. Having a look on AWS services, I saw that AWS provides a license managing tool named “AWS License…

Read More