Lee Asher in SQL Server Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples Discover how the FULL OUTER JOIN in SQL can simplify queries, improve performance, and solve real-world data problems with practical... 26 August 2025 12 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 6 – Backups and Recovery Procedures) Learn how to automate MySQL performance tuning using MySQL Shell. Discover intelligent backup and recovery strategies, configuration tracking, and optimization... 18 August 2025 18 min read
Lukas Vileikis in MySQL MySQL Index Overviews: PRIMARY KEY Indexes Learn how to use PRIMARY KEY indexes in MySQL - a type of B-tree index designed to help a database... 15 August 2025 16 min read
Mercy Bassey in PostgreSQL Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices Learn how to run PostgreSQL in Docker with production-grade SSL encryption, certificate-based authentication, and custom configuration files - perfect for... 13 August 2025 10 min read
Chisom Kanu in MySQL MySQL Shell Basic Configuration Management (Part 5a – Optimizing MySQL Performance) Learn how to optimize MySQL performance using MySQL Shell. This guide covers network tuning, query optimization, and configuration best practices... 08 August 2025 22 min read
Joe Celko in SQL Server Mastering SQL VIEWs: Syntax, Use Cases, and Best Practices Learn how to use SQL VIEWs effectively with practical examples, syntax breakdowns, and expert tips for recursive, union, and updatable... 05 August 2025 10 min read
Robert Sheldon in PostgreSQL How to Use the psql Command-Line Tool with Azure Database for PostgreSQL Flexible Server Learn how to install and use the psql command-line tool to connect to and manage Azure Database for PostgreSQL Flexible... 04 August 2025 20 min read
Edward Pollack in Featured How to Increase SQL Server Column Width Without IO (Input/Output) Overhead One of the most hassle-prone changes that can be made in a SQL Server database is to widen an existing... 28 July 2025 14 min read
Matt Gantz in SQL Server How to Measure Replication Latency in SQL Server AlwaysOn Synchronous Availability Groups Learn how to measure replication latency in SQL Server AlwaysOn synchronous availability groups using performance counters and DMVs for better... 25 July 2025 8 min read
Robert Sheldon in PostgreSQL How to use pgAdmin with Azure Database for PostgreSQL flexible server Learn how to connect and manage Azure PostgreSQL Flexible Server using pgAdmin, a powerful GUI tool for PostgreSQL.… 23 July 2025 17 min read
Edward Pollack in Featured How to Use the New PRODUCT() Function in SQL Server 2025 Learn how the new PRODUCT() function in SQL Server 2025 simplifies multiplicative aggregation. See examples, performance tips, and use cases.… 21 July 2025 8 min read
Lee Asher in Python Incrementally Loading Data into Parquet with Python In this article, we'll introduce the Parquet format, explain some strategies for incrementally updating a Parquet repository, and, with a... 17 July 2025 14 min read
Edward Pollack in Featured Using Regular Expressions (Regex) in SQL Server 2025: A Complete Guide Everything you need to know about Regular Expressions (Regex) in SQL Server 2025 - learn what it is, how to... 14 July 2025 18 min read
Jim Czuprynski in Oracle Creating Uber-Fast Maps With 23ai Vector Tiles and H3 Indexes: Part 1 Oracle Database 23ai added 300+ new features like the new VECTOR datatype that get most of the attention, but often... 08 July 2025 13 min read
Aaron Bertrand in Featured Common SQL Server Problems: Network Related or Instance Specific Error Occurred This is the first in a series of articles meant to provide practical solutions to common issues. In this post,... 07 July 2025 6 min read
Edward Pollack in SQL Server Columnstore Index Improvements in SQL Server 2025 Learn about the improvements to columnstore indexes in SQL Server 2025, including detailed demonstrations for each of these new changes.… 30 June 2025 11 min read
Joe Celko in Theory and design State Transition Constraints About two decades ago, I introduced the concept of transition constraints to show Data Validation in a database is a... 24 June 2025 14 min read
Kellyn Pot'Vin-Gorman in Oracle Oracle ASM: Monitoring and Managing (Part 2) In the first part of this series, we explored the fundamentals of Oracle Automatic Storage Management (ASM)—a powerful volume manager... 20 June 2025 5 min read
Matt Gantz in Database Administration Replacing a Column in a Large Active SQL Server Table In a previous post I showed how to use a batching strategy to remove large amounts of data from a... 19 June 2025 11 min read
Robert Sheldon in PostgreSQL Getting started with Azure Database for PostgreSQL Flexible Server Along with its many other cloud services, Microsoft now offers Azure Database for PostgreSQL Flexible Server, a database-as-a-service platform based... 18 June 2025 19 min read