Database Administration & Monitoring

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(…)

Deploying PostgreSQL in MiniShift/OpenShift

The last post quickly outlined on how you can setup MiniShift for playing around with OpenShift on your workstation. In this post we'll setup PostgreSQL in MiniShift using the default PostgreSQL image that already comes with MiniShift.

Setting up MiniShift

Currently we have many requests to support customers in running PostgreSQL in Docker containers. Some of those use redhat OpenShift as the management platform for their Docker deployments. Setting up an OpenShift cluster requires quite some resources and(…)

Can I do it with PostgreSQL? – 19 – Create user … identified by values

Puh, that last post in this series is already half a year old. Time is moving too fast :( Today, while being at a customer again, this question came up: Can I do something comparable in PostgreSQL(…)

2018.pgconf.de, recap

Finally I am home from pgconf.de in Berlin at the beautiful Müggelsee. Beside meeting core PostreSQL people such Devrim and Bruce, Andreas and joining Jan again for great(…)

MySQL – Time mismatch between system and log files

I was working on MySQL upgrades to version 5.7 at a customer, when I found out that for my instance, time in the error log file didn’t correspond to local system time: mysql@test1:/u01/app/mysql/admin/mysqld1/log/ [mysqld1] mysql -uroot -p Enter password: ERROR(…)