5 Strategies to Refactor SQL Code
Code refactoring is a common process when developing in procedural languages – and essential to developing high-quality […]
Database
Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices
VIEWs are an undervalued and underused feature in SQL. They basically consist of a query that has […]
How to Use the psql Command-Line Tool with Azure Database for PostgreSQL ...
A number of client tools are available for working with Azure Database for PostgreSQL flexible server. With […]
MySQL Index Overviews: PRIMARY KEY Indexes
If you’re a developer who had interactions with indexes in the past, you certainly know that indexes […]
How to Increase SQL Server Column Width Without IO (Input/Output) ...
One of the most hassle-prone changes that can be made in a SQL Server database is to […]
How to Measure Replication Latency in SQL Server AlwaysOn Synchronous ...
Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; […]
How to use pgAdmin with Azure Database for PostgreSQL flexible ...
Multiple tools are available for working with Azure Database for PostgreSQL flexible server. One of these is […]
How to Use the New PRODUCT() Function in SQL Server ...
With each version of SQL Server, there are always a few new features introduced that we applaud […]
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 […]
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 […]
SQL Window Functions Series: LAG() and LEAD()
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]
Different Ways to Populate the List of Tables
A database administrator has various tasks and responsibilities. Managing and keeping track of the database is one of […]