Database Administration & Monitoring

How to flashback databases in dataguard with broker

Last week I had to do some tests with dataguard. To make restores easier restore points were required. Given is following configuration: show configuration; Configuration - ila Protection Mode: MaxAvailability Databases: ila - Primary database(…)

PostgreSQL 11 : Procedures are coming

By Mouhamadou Diaw Reading about new features about future version PostgreSQL 11. I see that procedures will be implemented. Why is it so important? Until now only functions are available in PostgtreSQL. Of course a function is a procedure that(…)

Installing MAMP to play with PHP, MySQL and OpenFlights

By Franck Pachot . You may wonder what I'm doing with those technologies that are completely different from what I usually do. I'll detail in a future blog post but the idea is giving a short introduction to databases to(…)

Patching ODA lite to 12.2.1.3.0

Here is the latest patch for your ODA and it seems that Oracle documentation for this patch is not exactly the procedure you’ll have to follow to successfully patch your appliance. I recently updated X6-2M and X6-2L to this latest(…)

Introducing SQL Server on Kubernetes

After spending some times with Docker Swarm let’s introduce SQL Server on Kubernetes (aka K8s). Why another container orchestrator? Well, because Microsoft gives a strong focus on Kubernetes in their documentation and their events and because K8s is probably one(…)

EDB Failover Manager in EDB containers in Minishift/OpenShift – Failovers

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. In the last post we had a look at the basic configuration of EDB EFM and confirmed that(…)

SQL Saturday Paris 2018 – Pré-conférence SQL Server Linux, Docker et Azure

The next SQL Saturday in Paris is coming soon and the agenda has been published by the @GUSS on twitter. Le prochain SQL Saturday Paris arrive bientôt et l’agenda a été publié sur Twitter par le @GUSS(…)

EDB Failover Manager 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 three posts we deployed an EDB database container and two pgpool instances,(…)

OpenSSH is now available on Windows 10

A couple of days ago, the Windows 10 april 2018 update was installed on my laptop. And what, you may say? Well, surprisingly this update provides some interesting “hidden” features and one of them concerns(…)

Windocks – a different way to use SQL Server on Docker

I spent some times to write blog posts about SQL Server on Docker since few months and you likely noticed it concerned mainly SQL Server on Linux. But what about SQL Server on Docker and Windows? If you take a(…)