Database Administration & Monitoring

Create index CONCURRENTLY in PostgreSQL

In PostgreSQL when you create an index on a table, sessions that want to write to the table must wait until the index build completed by default. There is a way around that, though, and in this post we'll look(…)

firewalld rules for Veritas Infoscale 7.3 with Oracle

You might wonder, but yes, Veritas is still alive and there are customers that use it and are very happy with it. Recently we upgraded a large cluster from Veritas 5/RHEL5 to Veritas InfoScale 7.3/RHEL7 and I(…)

Is it an index, a table or what?

A recent tweet from Kevin Closson outlined that in PostgreSQL it might be confusing if something is an index or table. Why is it like that? Lets have a look and start be re-building the example from(…)

A response to: What makes a community?

A recent tweet of mine resulted in Martin Widlake to write a really great blog post about What makes a community. Please read it before you continue to read this. There was another response(…)

Can I do it with PostgreSQL? – 18 – Instead of triggers on views

It has been quite a while since the last post in this series but today comes the next one. Being at a customer this morning this question popped up: Can we have instead of triggers on a view in PostgreSQL(…)

Auto pre-warming in EDB Postgres Advanced Server 10

Some days ago EDB Postgres Advanced Server 10 was released and one feature which might be handy is auto pre-warming. What this does is to save all the buffers (or better a description of the buffers) which(…)

Displaying the contents of a PostgreSQL data file with pg_filedump

Did you ever wonder what exactly is in a PostgreSQL data file? Usually you don't care, I agree. But there might be situations where knowing how you can do this might be a great help. Maybe your file is corrupted(…)

SQL Server Tips: Deactivate the Customer Experience Improvement Program (CEIP)

Before SQL Server 2016, you had the possibility to check the case “Send Windows and SQL Server Error Reports….” during the installation if you want to be a part of the Customer Experience Improvement Program (CEIP). In SQL Server(…)

Pass Summit 2017: how to bypass SQL Server security

Last Friday I saw a very interesting session in Pass Summit 2017 about how to Bypass, or Ensure, SQL Server security by Matt Martin. Matt explained us how to bypass SQL Server security with the complicity of your SQL(…)

Can I have the same table published and subscribed (bi-directional) in PostgreSQL 10 logical replication?

When you start using PostgreSQL 10 logical replication you might think it is a good idea to setup bi-directional replication so you end up with two or more masters that are all writable. I will not go into the details(…)