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
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
Bravin Wasike in CI/CD Why Every Project Needs a CI/CD Pipeline No Matter How Small Have you ever experienced a scenario as a developer when a seemingly simple weekend bug fix throws your entire project... 09 August 2024 15 min read
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
Steve Jones in Editorials 5 Ways to Spend Your 2024 Learning and Development Budget in the US Not many data professionals get a personal Learning and Development (L&D) budget that we can use at our discretion. This... 30 July 2024 7 min read
Marcella McKeown in Editorials Insights from Redgate’s PASS Senior Program Manager In today’s editorial, guest writer Marcella McKeown shares some insights from her tenure from working on the program of PASS... 27 July 2024 5 min read
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
Goodness Woke in Web An Introduction to Frappe Framework: Features and Benefits Frappe is a full-stack, battery-included web framework with MariaDB as the database, written in Python and JavaScript. Frappe is a... 19 July 2024 16 min read
Boris Novikov in PostgreSQL Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions The temporal database is a database that can keep information on time when the facts represented in the database were,... 16 July 2024 20 min read
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
Matt Hilbert in News Hot off the press Every day an avalanche of news hits us from all directions in all kinds of media. So what are the... 09 July 2024 5 min read
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
Bravin Wasike in Containers and Virtualization Docker Logging Guide Part 2: Advanced Concepts & Best Practices Welcome to part 2 of our Docker Logging Guide series. In this article, we will cover Docker logging in detail.... 05 July 2024 20 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
Boris Novikov in PostgreSQL Saving Data Historically with Temporal Tables: Part 1: Queries In this article we discuss how to store data temporally in PostgreSQL. Temporal database store data in a way that... 28 June 2024 16 min read
Mercy Bassey in Containers and Virtualization Going serverless in Kubernetes with Knative Serverless computing has become increasingly popular in the field of cloud computing, with more organizations opting for cloud-based architectures. The... 26 June 2024 11 min read
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
Edward Pollack in T-SQL Programming XML Performance Tuning and Added Options SQL Server provides a variety of ways to tune XML so that it provides consistent performance, consumes less space, all... 21 June 2024 12 min read
