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.
The Oracle 23c new feature Lock Free Reservations allows to break with the traditional locking mechanism. Now multiple concurrent sessions can update the same row without be blocked !!! Let’s see how it works. In the traditional locking mechanism, when a first session modifies a row, oracle will hold 2 locks : If a second session tries to update the…
SQL is a wonderful language and very easy to use. For example you can call a PL/SQL function into a SELECT or WHERE clause and the result of the PL/SQL function is returned into the SQL expression. But when we call a PL/SQL function inside a SQL statement there is a context switch between the SQL Engine and the PL/SQL…
This blog comes to complete the excellent blog written by my colleague Gregory Steulet on the same topic. SQL FIREWALL is a new security layer integrated into Oracle Database 23c. First, we create a admin user for which we grant it a new admin privilege “sql_firewall_admin”: We enable the SQL FIREWALL: We create a capture process on the user LFE:…
Introduction Whereas I wanted to perform a quick demo to show some MongoDB useful command to mass update some fields (Increment),I had a MongoDB error: “Cannot increment with a non-numeric argument” I guess the message is explicit: I can’t update this field as it is not a numeric field Identify the field type: As I have created my document with…
Hi everybody Today I will give you a feedback about ab Event organized by MongoDB: The MongoDB.local event Introduction: Last week, I made a trip to Frankfurt to attend a special event made by MongoDB, I learn a lot of things and met a lot of interesting and kind people.It was the occasion to share our knowledge and our working…
Introduction It was a very great pleasure to participate to the Sql Server konferenz 2023 in Hanau, Germany, the 12 and 13 September 2023. I went with my colleague Petar, of the same Microsoft Sql Server team by dbi services, Switzerland. For Microsoft Sql Server fans, this event was really the right place to be. Where is located Hanau First…
Introduction ODA X8-2 series was sold for 3 years, and I would have expected X9-2 series to be on the market for 2-3 years, but I was wrong. ODA X10 series has just been announced. Maybe Oracle has a different strategy for appliances now, I will explain my thought later. You will notice that Oracle removed the number 2 in…
Introduction Out of the 300 features encapsulated in the new Oracle 23c database, I’ve chosen to write during the Oracle CloudWord a brief blog post about a feature that particularly caught my attention: Automatic Transaction Rollback. Starting from version 23c, Oracle enables automatic transaction rollback with parameters to manage this functionality. Through this blog post I’ll demonstrate, with a practical…
PostgreSQL comes with a lot of flexibility for defining new data types, defining tables and defining arrays over data types. You can make that as complex as you want, which does not mean that you should do it. Somehow you still need to manage and maintain what your settings up. The more complex your schema gets, the more time people…
Generative AI changes everything Larry Ellison kicked off his keynote by delving into Artificial Intelligence, particularly focusing on ChatGPT. The phrase is sure to become famous “About a year ago OpenAI demonstrated ChatGPT 3.5 and much to the shock of the people who developed ChatGPT… the baby talks. Seriously the developers did not expect that“. Larry then revisited OpenAI’s history,…
After 2 years, or even 3 years? The organizers could not agree, the SQL Conference took place again in Hanau. 73 speakers have taught us in over 80 sessions with their experience as well as knowledge new. There were incredibly many exciting topics. I would like to highlight the sessions “Migration to the Cloud – What could go wrong? and…
Introduction It is true that it’s a somewhat daring title, and it’s unlikely that SQL firewall has changed anything about the attack that several casinos in Las Vegas suffered last week. However, the opportunity was too good to pass up on this topic. As I write this blog, Las Vegas casinos are experiencing a series of cyberattacks. It turns out…
