State of the Database Landscape Results 2024
Every year, Redgate surveys technologists to ask a big question (through lots of little questions, naturally.) This […]
stateofdatabaselandscapesurvey
MySQL joins
Tables in a MySQL database are commonly related to one another, often in multiple ways, and it […]
Alternatives To SQL-2022 Built-in function GREATEST
If you haven’t already heard, SQL 2022 has introduced a new built-in system function called GREATEST. Simply […]
Working with MySQL constraints
MySQL provides a set of constraints that you can include in your table definitions to help ensure […]
Microsoft Fabric: Lakehouse and Data Factory in Power BI environment
Microsoft is merging Data Factory and Power BI Dataflows in one single ETL solution. It’s not a […]
Orchestrating a MySQL Container on Kubernetes
If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, […]
A Beginners Guide to MySQL Replication Part 5: Group Replication
This article is part of Aisha Bukar’s 6 part series on MySQL Replication. The entries include: Part […]
Working around schema drift in SQL Server
At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical […]
Database Concurrency in PostgreSQL
Concurrency control is an essential aspect of database systems that deals with multiple concurrent transactions. PostgreSQL employs […]