Blog
#database
Discover our articles on IT performance, cloud, data science and industry best practices.
All articles
Database Engines Trends Dashboard
DB-Engines.com is a website that reference and rank hundreds of database engines, threw the most famous ones likes Oracle, MySQL, SQL Server, PostGreSQL…
SQL Server Features Comparison and Evolution
Let's concentrate on the last 3 versions to see features evolution and comparison between edition.
Using DuckDB with Tableau Desktop on Windows
DuckDB is an in-process SQL OLAP database management system. These database is very fast for OLAP queries and have several advantages: There is also…
LAST_VALUE performance issue on SQL Server
The story begins after migrating table structures and data from Netezza to SQL Server.
Methane Gaz Emissions
The Emissions Database for Global Atmospheric Research (EDGAR) provides independent estimates of the global anthropogenic emissions and emission trends…
How minimal is SQL Server Minimal Logging
One day, one of my clients complained about the size of his SQL Server log. He mentioned that it had reached 1GB for just 1 million inserted rows.
The Database of Databases Dashboard
After extensively delving into the database world through dbdb.io and enjoying numerous online courses that delve deep into databases (a subject I'm truly…
ROLLBACK DELETE vs TRUNCATE vs DROP in several RDBMS
What are the differences between DELETE vs TRUNCATE vs DROP? The first one is DML whereas the last two are DDL but can which are rollbackle and which are…
Oracle Database Features Evolution
From version 11.2 to the 23c version oracle database have more than 1600 features.
