Lukas Vileikis in Other

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

Adrien Payong in Theory and design

Database Sharding: Strategies for Seamless Scaling and Performance Optimization

Companies of all sizes and across industries are struggling to cope with an explosion of data never before seen in...

13 September 2024 21 min read

Boris Novikov in PostgreSQL

PostgreSQL Temporal Tables: INSERT, UPDATE & DELETE

Learn how to INSERT, UPDATE, and DELETE data in PostgreSQL temporal tables. Covers temporal integrity constraints using EXCLUDE clauses, temporal...

11 September 2024 19 min read

Lukas Vileikis in Other

Devising the Perfect Index for Your Use Case – MySQL Edition

This blog will walk you through how to choose the perfect index for your specific use case. It will also...

11 September 2024 7 min read

Joe Celko in Theory and design

Uniqueness, Keys, and Identity

If you’ve ever had a traditional logic course, you’ll have run into “The Law of Identity” as the founding principle...

09 September 2024 16 min read

Grant Fritchey in PostgreSQL

PostgreSQL Backups to Support Point In Time Recovery: Learning PostgreSQL with Grant

The focus of your backup strategy should not be backups. Instead, you should be focused on restoring databases, because, after...

07 September 2024 12 min read

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

Ben Johnston in Databases

How to choose the right data types and column options in databases

How to pick the right SQL Server data type for every column - covering size, performance, NULLs, and the code...

31 August 2024 28 min read

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

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

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

Ben Johnston in SQL Server

How to master a database configuration audit in SQL Server: a complete guide

A SQL Server database configuration audit is where most issues are found — from compatibility levels and file locations, to...

20 August 2024 16 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

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

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 Other

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

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

Storing Weekday Sets in SQL Server Using Bitwise Flags: Schedules and Recurring Jobs

Store and query sets of weekdays in SQL Server using bitwise flags - each day encoded as a power of...

02 August 2024 7 min read