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.
Today, we followed (with Roger Schönmann) the first day of the SQL Konferenz 2024. We will be attending this event from October 01 to 02 in Hanau. At dbi services, we are no strangers to this conference, as we have been sending members of our team for several years now.We consider the sessions to be of high quality and right…
I had the opportunity to participate in the Future Data Driven 2024 event (https://datadrivencommunity.com/FutureDataDriven2024.html) with my colleague Stéphane Haby. Many speakers were present, and I was able to attend several sessions covering the following topics: Azure, AI, CosmosDB, Co-Pilot, Database Watcher. In several sessions, when AI was discussed, we talked about vector databases. These were terms I had heard before…
While PostgreSQL 17 was released just a couple of days ago, the development of PostgreSQL 18 is already going on and the first patches got committed. One of them addresses a limitation with pg_verifybackup: Currently (up to version 17) it can only verify backups created with pg_basebackup which are in “plain” format. This means, backups taken either in “tar” or…
Last night, I followed with Amine Haloui the Future Data Driven Summit 2024 from 3 PM to 2 AM This event was remote and very easy to follow. One day with 5 rooms and more then 55 speakers… Difficult to choose the session between this lot of choice and so interesting. I will share with you my experience on this…
The PostgreSQL optimizer relies on accurate statistics for finding and executing the most efficient plan for a given statement. Wrong or bad statistics usually lead to sub optimal execution plans and this usually is bad performance wise. This is not only true with PostgreSQL, all databases systems which use a cost based optimizer rely on statistics. Usually, you don’t need…
While pg_dump must not be considered a backup tool (please use physical backups for this), it is widely used to dump and reload data. One of the main advantages is, that you can do this across major versions of PostgreSQL. Other advantages are the plenty of options you have for dumping data out of a PostgreSQL database: Only the schema,…
Few weeks ago, I perform a migration of a database and the associate logins.After few days, the customer contact me for a error about “conversion of a varchar data type to datetime data type” on this application.The error was an log4net:exception and without more explanation: For the migration, I perform a backup/restore, the collation on both servers is the same…
Recently after a migration from SQL Server 2012 to SQL Server 2022, a end user contact me because SQL Server Management Studio (SSMS) does not work anymore when he want t o edit rows… I was surprised and do a test… The version of SSMS is 18.12.1 and it’s a version coming out the 21.06.2022… It’s the last version before…
Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the “import mode.” In this mode, the data is imported or copied into our reports to be included. This then allows us to build (for example) dashboards. Once the report is published, the data presented by the report…
Introduction When it is not possible to have SQL Server Enterprise and there is a need to set up an AlwaysOn cluster, it is possible to use SQL Server Standard and implement basic availability groups. However, the Standard edition of SQL Server comes with certain limitations when it comes to availability groups. Here are some of these limitations However some…
Now that we know how we can benchmark a CloudNativePG deployment, it is time to look at how we can connect external applications to the PostgreSQL cluster. Usually, applications run in the same Kubernetes cluster and can directly talk to our PostgreSQL deployment, but sometimes it is required to also connect with external applications or services. By default, this does…
In this blog I will show you how you can setup a basic MariaDB Galera Cluster on Debian 11 (bullseye).If you wish to have a more general overview first you can have a look here: https://mariadb.com/kb/en/what-is-mariadb-galera-cluster/ For this we have 3 servers: galera-cluster-1a/b/c. The following steps will first be executed on my first node, galera-cluster-1a still these steps have to…
