Incrementally Loading Data into Parquet with Python
Parquet is a column-oriented open-source storage format increasingly used for “big data” analytics. Yet despite its growing […]
Database
Columnstore Index Improvements in SQL Server 2025
Columnstore indexes are a powerful tool for storing analytic data directly in SQL Server. This feature has […]
Announcing Database Frontiers: a Database Conference You Haven’t Yet Heard ...
Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you […]
SQL Database Project in Azure Data Studio
Introduction This article teaches how to use the Azure Data Studio extension to handle SQL Database projects. It […]
Azure SQL Serverless: Discover What’s new and Increase Your Savings
Before jumping into the news and code, let’s start from the beginning: Why does someone use Azure […]
FinOps pour Microsoft Fabric
Version de l’article en Anglais sur LinkedIn : Le FinOps et Microsoft Fabric, deux sujets qui m’intéressent […]
Auditing SQL Server – Part 4 – Database Configuration Audit
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level […]
Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Introduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for […]
Forget the Models, Your Data is the Secret Sauce for ...
Credit: Image generated by Google Bard Generative AI (GenAI) models like GPT, Gemini, PaLM, DALL-E, and others offer […]