database

Methane Gaz Emissions

The Emissions Database for Global Atmospheric Research (EDGAR) provides independent estimates of the global anthropogenic emissions and emission trends, based on publicly available statistics, for the atmospheric modeling community as well as for…


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. His issue was that sometimes he had to insert 1 billion of them ! Hopefully there is SQL Server…


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 passionate about), I thought it would be a fitting gesture to give back to someone I…


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 not ? It will depends the RDBMS => DELETE vs TRUNCATE vs DROP : Rollbackable ? SQL…


Oracle Database Features Evolution

From version 11.2 to the 23c version oracle database have more than 1600 features. This dashboard try to give you a vision of Oracle database features evolution and the ability to quick search over them. The data comes from here…


Oracle Database Editions Comparator

Oracle provide many informations about features that are available or not in their licensing page : https://docs.oracle.com/en/database/oracle/oracle-database/21/dblic/Licensing-Information.html .But we found the reading a little bit hard so we use…


PostgreSQL Features Matrix GPT-Optimized

The QuestPostgreSQL is a hip and happening DBMS that’s gaining more and more popularity. It’s got all these cool features that make its users feel like they’re in the front row of a rock concert. Unlike most of its competitors,…


Snowflake TPCH SF100 Results

TPCH with Snowflake : SF100

Snowflake is a fantastic Datawarehouse and Datalake SaaS Solution ! Very easy to use, scale, develop with and continuously integrate data inside of it central storage is quite fun. But what about performance ? Snowflake have a really good reputation…


TPCH SF10 MSSQL 2022

TPCH SF10 : Query 13 and SQL Server Collations Performance Impact

After benchmarking several cloud databases (Snowflake, BigQuery, SingleStore, Databricks) using TPCH SF10 data, after benchmarking DuckDB and Tableau Hyper on my own machine, I ask to myselft : « hey, why not testing using the official SMP Databases…


TPCH SF10 Dashboard Comparison

TPCH SF10 : Tableau Hyper Engine vs DuckDB vs Snowflake vs BigQuery vs Databricks vs SingleStore

After a first try with TPCH SF10 using DuckDB on 2 differents laptops and compare parquet storage vs native storage (see TPCH SF10 using DuckDB vs SnowFlake, Bigquery, SingleStore and Databricks) I would like to try th Hyper Engine used by Tableau…


TPCH-SF10-DuckDB_vs_Cloud_Databases

TPCH SF10 using DuckDB vs SnowFlake, Bigquery, SingleStore and Databricks

I was very interested in 2 articles of Mimoune Djouallah (aka mim) that compare Snowflake, BigQuery, Databricks, SingleStore, PowerBI Datamart and DuckDB using tpch benckmark with different scale factor (TPCH-SF10 then SF100) TPCH benchmark is a…


SQL Server Extended Events Dashboard

SQL Server Extended Events Dashboard

SQL Server Extended Events is a powerful feature in Microsoft SQL Server that enables database administrators to capture and analyze events that occur within the server. Extended Events provides a lightweight and customizable infrastructure that can…


MSSQL Features Comparison and Evolution

SQL Server Features Comparison and Evolution

Let’s concentrate on the last 3 versions to see features evolution and comparison between edition. Clic, Ctrl+Clic, or mouse maintain and select area to filter others on th dashboard. Click elsewhere to release filter or change it. On the…


DBEngines Dashboard

Database Engines Trends Dashboard

Database Engines Trends DashboardDB-Engines.com is a website that reference and rank hundreds of database engines, threw the most famous ones likes Oracle, MySQL, SQL Server, PostGreSQL, MongoDB, Redis to omes more confidential like Hazelcast…


SQL Server editions comparison dashboard by domains features and scale capacities

The article allow you to direct use the sql server editions comparison dashboard You can select the version of SQL Server You can select a group of features to adapt the details with your selection Multi-selections is also…


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 : it can read and write Parquet files very efficiently, it use parallelism and SIMD for impressive performance.…


Export data as fast as possible : from HANA to CSV

What is the fastest method to export HANA to CSV ?I use a HANA 2.0 database. I want to export from HANA to CSV. As source, a table or a sql query, as target an external client, of course as fast as possible and using a command line (i’m on…


SQL Server Trace Flags Classification

database Trace flags are used to set specific server characteristics or to alter a particular behavior. For example, trace flag 3226 is a commonly used startup trace flag which suppresses successful backup messages in the error log. Trace flags are…


Compression des données XML dans SQL Server

databaseAlexandre Blois Problème : On stocke des données XML dans une table qui commence à grossir sérieusement et il devient important de réfléchir à des solutions pour essayer de gagner un peu de place de stockage pour éviter que la table explose…


T-SQL Bad Practices

150 T-SQL Bad Practices

Many times i was asking for given best practices for T-SQL code but I don’t like best practices advices. They can be deprecated faster than you think and they can be a good advice in one case and very bad advise for another case. T-SQL Bad…


SQL Server CLR Functions vs SQL 2019 Function Inlining

Booster vos performances SQL Server en utilisant des fonctions compilées CLR C# à l'intérieur même de votre SGBDR préféré à la place des fonctions SQL classiques ! Ce tutorial montre toutes les étapes pour : écrire une…


GPU Analytics Ep 2, Load some data from OmniSci into a GPU dataframe

Although the post title is about loading some data from a GPU database into a GPU dataframe, most of it is about running JupyterLab on a GPU AWS instance, which is a little bit cumbersome to set up. Finally, once JupyterLab is running on our…


GPU Analytics Ep 1, GPU installation of OmniSci on AWS

In this post, we are going to install the OmniSci 4.6 GPU database on an Ubuntu 18.04 AWS instance. These are the actual command lines I entered when performing the installation. But let's start by introducing the motivation behind GPU databases:…