Posts tagged "database"

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

What Are Joins? Joins in SQL allow you to combine rows from two or more tables based on a related column. They are a powerful tool for retrieving meaningful, interconnected data from multiple...

17.04.2025 0 Read More

VERSE.DB V3 (ANNOUNCEMENT)🔥

I'm here to talk about verse.db—and all I’m gonna say is: Get ready. Update v3 is coming, and it’s not just an update—it’s a whole new level. You’re gonna love what we’ve built. Stay tun...

17.04.2025 0 Read More

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

Problem description & analysis: SQL Server has two tables, Table1：Table2：Task: Now we need to sort Table1 by ID and traverse each record in sequence: retrieve the record in Table2 tha...

17.04.2025 0 Read More

How to Dump Database Tables into Files to Speed Up Queries with esProc

Large data volumes or high database loads can both lead to slow database query performance. In these situations, using esProc to export the data and store into files for subsequent computation can sig...

18.04.2025 0 Read More

🗃️ Introduction to Database Design: Concepts Every Beginner Should Know

If you're diving into the world of databases and wondering how to structure data efficiently, you're in the right place. In this article, we’ll walk through foundational concepts in database design ...

18.04.2025 0 Read More

Test Data Management Demystified: A Comprehensive How-To Guide

Test data is a foundational component of any robust QA strategy. It enables you to compare against successive test results to pinpoint app errors that would otherwise go undetected. However, quality, ...

18.04.2025 0 Read More

Why Denormalizing in ClickHouse will come back to bite you

If you've worked with ClickHouse, you’ve probably felt tempted to denormalize your data to avoid JOINs. It seems like a clever shortcut: combine everything into a single wide table and sidestep the ...

18.04.2025 0 Read More

Mismatch Between SSAS Tabular Model Measures and Data Warehouse Values in Power BI (Direct Query)

I am building a SSAS Tabular model on Visual studio, i created some measures in the Tabular model (like SUM, YTD, etc.) and then deployed the model to SQL Server Analysis Services, and then connected ...

18.04.2025 0 Read More

Kapper benchmarks - how does Kapper 1.3 compare to the competition?

Kapper is a lightweight Kotlin ORM library designed to be simple and idiomatic. Unlike other ORM libraries, such as Hibernate and Ktorm, Kapper avoids being a leaky abstraction over SQL. Instead, it e...

18.04.2025 0 Read More

How Timescale Solves Real-Time Analytics in Postgres

If real-time analytics performance is critical for the demanding application you’re building, this is the technical whitepaper you’ll be glad you read: Timescale Architecture for Real-Time Analyti...

21.04.2025 0 Read More

SQL Joins Made Easy: INNER, OUTER, LEFT, RIGHT Joins

VERSE.DB V3 (ANNOUNCEMENT)🔥

Find the Closest Date Match for Each Record from Two Tables — From SQL to SPL #20

How to Dump Database Tables into Files to Speed Up Queries with esProc

🗃️ Introduction to Database Design: Concepts Every Beginner Should Know

Test Data Management Demystified: A Comprehensive How-To Guide

Why Denormalizing in ClickHouse will come back to bite you

Mismatch Between SSAS Tabular Model Measures and Data Warehouse Values in Power BI (Direct Query)

Kapper benchmarks - how does Kapper 1.3 compare to the competition?

How Timescale Solves Real-Time Analytics in Postgres

#reading

#popular