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.
What a chance for me to be able to participate to this great event! First of all I would like to thank dbi management to have given me the chance to go there and to participate to it. Las Vegas is something that needs to be seen one time in life, and this Oracle event is just GREAT! As you…
The last flavor of BSD we’ll look at is NetBSD. We already had FreeBSD (here and here) and OpenBSD (here and here). If you want to learn more about the history of NetBSD and the goals of the project, head over to the about page on the official website. We’ll use the same structure as in the other BSD related…
In the last post we’ve seen that it is quite easy to get started with PostgreSQL on OpenBSD when you install from the provided packages. The downside of this was, that not the latest version of PostgreSQL was provided, 14.2 instead of 14.5, which is the current version as of today. If you want to stay more up to date,…
Almost all of our customers run PostgreSQL on one of the distributions of Linux, either installed from packages or from source code. But there is not only Linux, there a various flavors of BSD you can also run PostgreSQL on. So, if you want to have something more UNIX like, OpenBSD can be an option. This flavor of BSD is…
by Alexandre Nestor Introduction OCI stands for Oracle Cloud Infrastructure and the command line client (CLI) keep the same name: oci The aim of this guide is to give a practical step by step quick flow, that I used on all new created vm, in order to have the oci cli working in no time. Installation The install directory is…
PostgreSQL comes with the “public” schema by default and we always recommend to drop it for PostgreSQL versions up to 14. The reason is, that everybody who is able to connect to a database, by default, can create objects in the public schema. This will not anymore be possible starting with PostgreSQL 15. You can check the release notes for…
By Mouhamadou Diaw In Oracle documentation we can find following lines about Oracle Autonomous Database Autonomous Database provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance, and requires no database administration. You will need an account for Oracle cloud but you can get one free for testing (see in Oracle documentaion) In this blog I describe…
PostgreSQL comes with three data types for storing characters. char, varchar and text. What we often see at our customers is, that varchar(n) is used when they want to store characters and limit the amount of characters which are allowed to store into the field/column. Before we go into the details: The only reason you might want to use char…
The last two posts introduced TOASTing strategies and how TOAST tables look like. Have a look at those posts if you are not yet familiar with TOAST in PostgreSQL. In this post we’ll look a bit under the hood to understand how TOASTing really works. We’ll use the same table as in the last post, which is still there but…
Today the Data Platform Virtual Summit begin at 09:30 am with the keynote: Creating a Data Culture… My schedule for the day: D4B1 – SPHINX – Configure SQL Server for efficient troubleshooting – Intermediate – Christophe Laporte D4B2 – HYDRA – Unleash the testing of your CI/CD pipelines for SQL Server deployments in Azure DevOps – Advanced – Kevin Chant…
Today the Data Platform Virtual Summit begin at 06:00 am for us…It’s in our time offset, this time better to wake up! 😉 My schedule for the day: D3B1 – KATMAI – SQL MI on Kubernetes – Intermediate – Dhananjay Mahajan D3B2 – KATMAI – Extent and Page Management in Microsoft SQL Server – Expert – Torsten Strauß D3B3 –…
Make sure that you read the last post about TOASTing strategies in PostgreSQL before you continue with this one, at least if you are not familiar with the previous topic. The strategies we looked at are one important implementation detail you need to be aware of when it comes to TOASTing. What we didn’t look at until know, is how…
