Lee Asher in PostgreSQL Solving the Overlap Query Problem in PostgreSQL Range queries are a very common task in SQL: selecting dates, numbers, or even text values that fall within some... 03 September 2024 10 min read 331
Lukas Vileikis in MySQL MySQL Index Overviews: Composite B-Tree Indexes Indexes in MySQL are one of the primary ways to enhance query performance and they are especially useful when the... 30 August 2024 16 min read
Joe Celko in Theory and design Bad Data and Dirty Databases Many years ago, my wife and I wrote an article for Datamation, a major trade publication at the time, under... 28 August 2024 10 min read 1
Edward Pollack in T-SQL Programming Store & Parse JSON in SQL Server: Strategy Guide Learn how to store, validate, index, and compress JSON in SQL Server. Covers ISJSON, OPENJSON, JSON_VALUE, computed columns, the Azure... 23 August 2024 27 min read 311
Robert Sheldon in NoSQL Introducing Schema Validation in MongoDB Similar to other NoSQL database systems, MongoDB is known for its flexible and variable schema models, unlike relational database systems... 21 August 2024 21 min read
Joe Celko in Theory and design LIKE Constraints In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of... 19 August 2024 10 min read 1
Lee Asher in PostgreSQL PostgreSQL Partitioning: The Most Useful Feature You May Never Have Used Partitioning in PostgreSQL was for many years a feature almost entirely ignored, and even today is often thought of only... 16 August 2024 10 min read 31
Farooq Aziz in Snowflake Change Data Capture Pipeline Automation in Snowflake This article offers technical guidance on automating updates and tracking changes of data examples using Snowflake’s CDC capabilities. The examples... 15 August 2024 12 min read
Lukas Vileikis in Blogs Thoughts Before Speaking at the Software Architecture Conference This blog shares the thoughts of a conference speaker Lukas Vileikis before speaking at a conference called Software Architecture Conference.… 14 August 2024 3 min read
Aisha Bukar in MySQL MySQL vs PostgreSQL: Which Open-Source Database is right for you? When I joined a growing startup company as a backend developer, we were at crossroads choosing between MySQL and PostgreSQL... 12 August 2024 12 min read 31
Lukas Vileikis in MySQL MySQL Index Overviews: B-Tree Indexes In this first entry in a multipart series on indexes, I will cover the most important index type in MySQL,... 05 August 2024 19 min read
Aaron Bertrand in SQL Server Days of the Week, Bitwise Edition I recently had to help support synchronization and distribution of workloads between multiple servers. Some of this work involves Task... 02 August 2024 7 min read 1
Koen Verbeeck in BI How to Stream Data from Azure Event Hubs into a Fabric Eventhouse At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for all data-in-motion. This... 26 July 2024 9 min read
Aaron Bertrand in T-SQL Programming Index cleanup : Harder than it looks I’m not the first person to write about cleaning up unused or redundant indexes. You can read many articles about... 22 July 2024 7 min read
Boris Novikov in PostgreSQL PostgreSQL Temporal Aggregates: SUM, AVG & COUNT Across Time How to compute temporal aggregates in PostgreSQL when values change over time. Covers custom SUM, AVG, COUNT, MIN, and MAX... 16 July 2024 20 min read 11
Robert Sheldon in MongoDB Working with Documents in the MongoDB Compass GUI Throughout this series, I’ve discussed various ways to work with the documents in a MongoDB collection. If you’ve been following... 10 July 2024 23 min read 1
Aaron Bertrand in Database Administration It’s a recovery strategy, not a backup strategy I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. I can’t possibly... 08 July 2024 12 min read
Fabriano Richard in BI Microsoft Fabric, the Land of Wizards and Trolls In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about... 03 July 2024 9 min read 1
Boris Novikov in PostgreSQL Saving Data Historically with Temporal Tables: Part 1: Queries Executive Summary PostgreSQL temporal tables store historical versions of data, allowing you to query what the data looked like at... 28 June 2024 17 min read 11
Robert Sheldon in MongoDB Deleting Documents from a MongoDB Collection So far in this series, we’ve looked at different ways that you can add, retrieve, and update documents in a... 24 June 2024 15 min read
3
1
1
