Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
Introduction: Redis allows you to use many commands to create and administrate your database. There is especially one useful feature which which allows you to execute a series of commands as a single unit of work: The Redis transactions! In this post will check how it works how it can be useful for your daily work. How do transactions work?…
[ORA-20001] How can LC_* localisation environment variables can break Oracle datapatch
When it comes to sorting strings it is all about locales and how PostgreSQL is using them. PostgreSQL uses the locales provided by the underlying operating system, by default this is “C” or “POSIX”. To see how that works lets do some simple demos to start with and then go a bit deeper. The system I am using here is…
When you want to know the currently connected user in PostgreSQL for your session there are two system information functions which seem to do the same thing. There is “session_user” and there is “current_user”. So what is the difference between those or is there no difference at all? Looking at my users in PostgreSQL all I have right now is…
This is a feature I am sure a lot of people have waited for and finally it was committed for PostgreSQL 17. Back in my Oracle days it was quite common to have a trigger firing once a user logged into the database. This is e.g. useful to setup some logging or deny logins based on the day of the…
Having multiple users but don’t want them to use the same account?In such a case you can use a role to group your users together.And even better you can set default privileges for that role before creating anything important in your database to have your access privileges setup right from the get go!In PostgreSQL terms the only difference between a…
When it comes to conversions between time zones in PostgreSQL, there is already much you can do today. What PostgreSQL up to version 16 does not support, is the conversion to the local session’s time zone with ‘AT LOCAL’. Starting with PostgreSQL 17 this will be possible, as this functionality was just committed. Let’s have a look at how you…
When working with a PostgreSQL instance, most of the time the initial superuser is called “postgres”. One might think this is always the case, and this user is there by default. But the name for that user is chosen by some rules and in this post we’ll look at this. In almost all the installations we’ve seen out there, PostgreSQL…
Using FileTables with Basic Availability Groups in SQL Server offers a robust solution for storing non-relational data but requires careful management due to potential risks like data corruption during long transactions and failovers. While BAG ensures data integrity, challenges arise from large file handling, streaming, and the absence of Read-Only replicas.
Introduction Oracle Database Appliance now includes a powerful virtualisation layer based on KVM and fully integrated with odacli. For sure, an ODA is mostly dedicated to Oracle databases, but you can also benefit from unused cores to run application VMs in the same box as your databases. And it works like a charm. One of my customer recently asked if…
Recently I have the case that a customer has a lot of databases not more used but need to be accessible at any time. In this case, we had a lot of T-log with the size when there are used and now we can really shrink and have some place on the disk. I don’t precise but it’s very important…
In this blog I want to introduce some of the new features of the Oracle 23c developer edition. It will be only a selection of some of the main features. It is not the intention to give you a thorough picture of all the features in this blog. I have tested some of the essential ones (in my opinion) on…
