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 211
Matt Gantz in SQL Server Measure Replication Latency in SQL Server AlwaysOn AGs Learn how to measure synchronous replication latency in SQL Server AlwaysOn Availability Groups using performance counters. Track HADR_SYNC_COMMIT waits and... 25 July 2025 9 min read 211
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 SQL Server 2025 PRODUCT() Function: Multiply Values in T-SQL Learn the new PRODUCT() aggregate function in SQL Server 2025 - multiply values across rows like SUM() adds them. Covers... 21 July 2025 9 min read 2
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 1
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
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 51
Lukas Vileikis in Blogs Announcing Database Frontiers: a Database Conference You Haven’t Yet Heard About Database Frontiers is a new database conference hitting the spotlight come October 15th, 2025. Here’s everything you need to know.… 15 April 2025 3 min read
Dennes Torres in Blogs 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 SQL Serverless? The... 22 January 2025 3 min read 21
Lukas Vileikis in Blogs Thoughts Before Covering MariaDB Indexes in the MariaDB Server Fest 2024 This blog outlines why you should be coming to see a talk on MariaDB indexes at the MariaDB Server Fest... 13 September 2024 4 min read
Ben Johnston in Blogs 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 hardware audits and... 20 August 2024 15 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 7: MySQL Enterprise Backup In this blog, we walk you through the primary way to take enterprise-level backups in MySQL: MySQL Enterprise Backup. Have... 03 December 2022 7 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 6: Physical vs. Logical Backups In this blog, we compare two of the most popular types of backups in MySQL - backups of a physical... 01 December 2022 9 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 5: Backing Up Big Data This blog will guide you through backing up big data sets in MySQL with ease. Have a read!… 26 November 2022 14 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 4: mydumper In this blog, we walk you through one of the most prominent MySQL logical backup solutions - a CLI-based tool... 22 November 2022 4 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 3: mysqlpump In this blog, we walk you through the brother of mysqldump - mysqlpump - and tell you everything about it.... 19 November 2022 6 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 2: Percona XtraBackup In this blog, we walk you through one of the flagship backup offerings by Percona - XtraBackup.… 16 November 2022 7 min read
Lukas Vileikis Optimizing MySQL: The Basics of Query Optimization In this blog, we will walk you through the basics of query optimization in MySQL. Have a read!… 10 November 2022 4 min read
Database DevOps Grant Fritchey in Database DevOps What is database continuous integration? Have you ever longed for a way of making the delivery of databases more visible, predictable and measurable? Do you... 07 October 2020 9 min read
