Database Administration & Monitoring

Customizing PostgreSQL parameters in EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In the last two posts we deployed an EDB database container and two pgpool instances and then(…)

Scaling the EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. When you followed the last post you should have two pgpool instances and one EDB Postgres instance running(…)

PDB RMAN backups available after plugging in on a new CDB with Oracle 18c

With Oracle 18c, it is possible to use PDB rman backups created on the source CDB (they are called PREPLUGIN backups) when the PDB has been relocated to a target CDB. In my environment, my original CDB is DB18, with(…)

Deploying EDB containers in MiniShift/OpenShift

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In this post we'll look at how we can deploy EnterpriseDB containers in MiniShift. When you need to(…)

SP2 for SQL Server 2016 is available with new helpful DMVs

Last month (April 24, 2018), the Service Pack 2 for SQL Server 2016 was released and distributed. This Service Pack has new DMVs, already available in SQL Server 2017 RTM.

SQL Server Security: Are your databases ready for the GDPR?

The GDRP (General Data Protection Regulation), voted in 2016, will be applied in the European Union soon (May 25, 2018). We heard a lot of this new directive. The goal is to improve the protection and confidentiality of personally(…)

Load Balancing with Docker Swarm mode and SQL Server containers

Docker swarm mode provides an easy way to publish ports for services. Indeed, in this mode all nodes participate in an ingress routing mesh and accept connections to any service port published. Thus, all incoming requests are routed to available(…)

How uid mapping works in Docker containers?

It can be interesting to see how uids between the docker host and docker containers are mapped. For example, for security concerns. As a reminder, docker containers are based on two linux kernel features:(…)

Oracle 18c clone PDB and Transparent Data Encryption

Let’s do some tests with the Oracle 18c new feature in creating PDB clone with DBCA. Unfortunately, this feature does not work when you have TDE enabled. Just to remember, with Oracle 12.2 we had the possibility to create PDBs with(…)

Managing SQL Server sa credentials with Docker secrets on Swarm

A couple of weeks ago, I was working on a MSSQL Server docker image in a context of Hidora, a swiss cloud provider based on jelastic and for Docker-based applications. When writing(…)