All articles

PostgreSQL on Amazon RDS – Adding a replica to the beast

In the last post I looked on how you can change the PostgreSQL parameters when the instance is running in the Amazon cloud. In this post we’ll look at how to add a replica to the PostgreSQL instance(…)

Linux – How to check the exit status of several piped commands

As piping in bash commands is common and very usefull, controling the exit status of each piped commands in bash scripting can be vital, especially for backups. I was checking by a customer the backups of a critical MySQL instance(…)

log file sync / user commits

By Franck Pachot . When presenting 'Interpreting AWR Reports - Straight to the Goal' at UKOUG TECH15 I had a very good question about the Statspack report I read which had log file sync much smaller than user commits. I(…)

PostgreSQL on Amazon RDS – Configuring the beast

In the last post I looked at how you can strengthen the security for your PostgreSQL instance in Amazon RDS. In this post I’ll look at how you can configure your PostgreSQL instance. When you login to(…)

SQL Server 2016: temporal table with In-Memory

In SQL Server 2016 CTP 3.0, temporal tables with In-Memory OLTP is supported. 🙂 At the JSS2015 (Journée SQL Server 2015), I have presented a little demo about temporal table with a table(…)

PostgreSQL on Amazon RDS – Securing the beast

In the last post I looked at how to bring up a PostgreSQL instance in the Amazon cloud. In this post I’ll look into how to restrict access to this instance to specific IP addresses to strengthen security.

PostgreSQL on Amazon RDS – Setting up the beast

Today I had a look at PostgreSQL in Amazon RDS. Once you have an Amazon AWS account (this requires a valid credit card for verification) setup bringing up a PostgreSQL instance is pretty easy. The first(…)

SQL Server 2016 – availability groups and gMSAs

This blog post will probably not concern customers where either password policy change rules are not defined for service accounts or Kerberos authentication is not used. But I’m sure that the number of these customers has decreased over at least(…)

Flashback table after multiple drop

By Franck Pachot . FLASHBACK TABLE restores the latest version that is available in recycle bin. If you did multiple drop / create you may want to restore oldest versions. Of course it's documented - everything(…)

PDB Snapshot using dbms_dnfs.clonedb_renamefile

By Franck Pachot . In the previous post I've explained how to use 'snapshot copy' PDB creation for thin provisioning and quick restore of initial state for continuous integration tests. If you don't have the multitenant(…)