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
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 11
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 51
Joe Celko in Theory and design State Transition Constraints in SQL: Temporal Rules & Validation Implement state transition constraints in SQL Server using FOREIGN KEY references, temporal attributes, CTE path validation, and stored procedure wrappers.... 24 June 2025 14 min read 32
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 1
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 11
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
Mercy Bassey in MySQL Replicating MySQL databases in Docker Containers In my prior article, “Running a relational database with Docker”, I showed how to spin up a Docker container with... 13 June 2025 10 min read 1
Anil Kumar Moka in Snowflake Load Data into Snowflake Using Native Snowflake Connector for Python: From Small to Large Datasets In our ongoing exploration of Snowflake data loading strategies, we’ve previously examined how to use pandas with SQLAlchemy to efficiently... 12 June 2025 23 min read
Aaron Bertrand in Database Administration SQL Server 2025 ZSTD Backup Compression Guide SQL Server 2025 adds Zstandard (ZSTD) backup compression with LOW, MEDIUM, and HIGH levels. Compare ZSTD vs MS_XPRESS performance, syntax,... 11 June 2025 15 min read 1
Edward Pollack in Database Administration TempDB Resource Governor Space Controls in SQL Server 2025 This article was updated in September 2025 following the SQL Server 2025 (17.x) Preview release. TempDB is a system database... 09 June 2025 15 min read 21
Jagdish Mohite in PostgreSQL Securing PostgreSQL Against Injection, Misconfiguration, and Privilege Escalation PostgreSQL is a robust and trusted database platform, but it’s not invincible. The PostgreSQL Global Development Group “takes security seriously,”... 06 June 2025 22 min read 1
Kellyn Pot'Vin-Gorman Oracle ASM: A Simple Solution or Another Complexity? (part 1) For highly performant Oracle databases, the storage must be scalable, resilient, and easy to manage—especially as infrastructure complexity grows with... 05 June 2025 6 min read
Aisha Bukar in MySQL MySQL vs. PostgreSQL: Date and Time Data Types Date and time data types are important because they help track and manage time-based information in databases. This includes things... 03 June 2025 21 min read 1
1
