As I told you in my previous post, I started my new job lately as a DBA team lead (I didn’t tell you where, but now that I started and
Ch-Ch-Ch-Ch-ChangesCh-Ch-Ch-Ch-Changes
I haven’t written anything in my blog for a few months now, and if you have been following me for a long time you know that’s quite unusual. However, there
What Oracle Database Patches Do I Need?What Oracle Database Patches Do I Need?
A few years ago I wrote the post All You Need to Know about Oracle Database Patching, and I also presented a presentation about this topic a few time. But
Database for Developers: Connection PoolsDatabase for Developers: Connection Pools
When you develop an application that uses a database, one of the topics you need to consider is how to connect to the database. Some application use a one-to-one connection,
DB Comparison Project: Working with DatesDB Comparison Project: Working with Dates
As I started this project, I prepared a list of topics for my posts. One of them was “working with different data types” as there are differences between the different
DB Comparison Project: Pseudo ColumnsDB Comparison Project: Pseudo Columns
This is the third post in this project, where I compare 4 major databases: Oracle, SQL Server, PostgreSQL, and MariaDB, and this time I’ll talk about pseudo columns (or system
DB Comparison Project: Handling TransactionsDB Comparison Project: Handling Transactions
Before I start I just wanted to remind that this is one part of a series about comparing the basic functionality of four different RDBMS: SQL Server, Oracle, MariaDB, and
DB Comparison Project: Using NULLsDB Comparison Project: Using NULLs
I decided to start a comparison between four main databases from a development perspective. If you want to read more about it, I introduced the project here. And for the
DB Comparison Project for Developers (mainly)DB Comparison Project for Developers (mainly)
I’ve decided to start an interesting project. I have no idea how long it will be or how many topics I’ll decide to research, but I have at least a
An Issue with Automatic Flashback of Standby DatabaseAn Issue with Automatic Flashback of Standby Database
I dedicate this post to Pieter Van Puymbroeck, who left us way too early. I actually sent him details about this issue one day before I got the news of