Databases Resources

Doris: Unifying SQL Dialects for a Seamless Data Query Ecosystem

Apache Doris breaks this barrier with its powerful SQL dialect compatibility and builds a unified data query ecosystem for users.

April 28, 2025

by Darren Xu

· 3,368 Views

Building Event-Driven Go Applications With Azure Cosmos DB and Azure Functions

Learn how to build serverless Azure Functions with Go, using Cosmos DB triggers and Azure OpenAI for generating embeddings in this step-by-step guide.

April 28, 2025

by Abhishek Gupta

CORE

· 3,122 Views

SQL Server Index Optimization Strategies: Best Practices with Ola Hallengren’s Scripts

This guide covers the effective implementation of Ola Hallengren's SQL Server Maintenance Solution for index optimization, especially in Availability Group environments.

April 25, 2025

by arvind toorpu

CORE

· 8,984 Views · 4 Likes

How to Build the Right Infrastructure for AI in Your Private Cloud

Build scalable infrastructure with GPUs for AI workloads, manage data pipelines efficiently, and ensure security and compliance.

April 25, 2025

by Siva Kiran Nandipati

· 6,124 Views · 2 Likes

CRDTs Explained: How Conflict-Free Replicated Data Types Work

Explore Conflict-free Replicated Data Types. Data structure designed to ensure that data on different replicas will eventually converge into a consistent state.

April 24, 2025

by Bartłomiej Żyliński

CORE

· 6,238 Views · 2 Likes

Auto-Instrumentation in Azure Application Insights With AKS

Demo of auto-instrumentation with App Insights on AKS: This article provides a demo of how to enable monitoring on applications without requiring code changes.

April 24, 2025

by Aritra Ghosh

· 4,290 Views

Failure Handling Mechanisms in Microservices and Their Importance

In this article, we will explore different failure-handling mechanisms in microservices and understand their importance in building resilient applications.

April 23, 2025

by Arunkumar Kallyodan

· 9,015 Views · 12 Likes

A Modern Stack for Building Scalable Systems

Dive into modern stack recommendations for building robust and scalable systems. This stack is agnostic and can be integrated into all programming languages.

April 23, 2025

by Bartłomiej Żyliński

CORE

· 8,890 Views · 2 Likes

From Concept to Cloud: Building With Cursor and the Heroku MCP Server

In this article, I used Cursor and Heroku’s MCP Server to build and deploy a SvelteKit app entirely through prompts—no CLI, just AI.

April 22, 2025

by Alvin Lee

CORE

· 5,260 Views · 1 Like

How to Restore a Transaction Log Backup in SQL Server

Learn to restore SQL Server transaction log backups step by step, including prerequisites, backup types, troubleshooting errors, and best practices.

April 22, 2025

by Nisarg Upadhyay

· 5,308 Views

Platform Engineering for Cloud Teams

Platform engineering empowers cloud teams by streamlining infrastructure, automating workflows, and enhancing developer experience to drive efficiency and innovation.

April 21, 2025

by Josephine Eskaline Joyce

CORE

· 7,122 Views · 10 Likes

Simplifying Vector Embeddings With Go, Cosmos DB, and OpenAI

Learn how to build a Go web app to generate, store, and query vector embeddings using Azure Cosmos DB and OpenAI, with step-by-step guidance.

April 21, 2025

by Abhishek Gupta

CORE

· 3,834 Views · 2 Likes

Why I Built the Ultimate Text Comparison Tool (And Why You Should Try It)

Learn how my comprehensive text comparison tool combines exact, fuzzy, and phonetic matching to solve your messiest data reconciliation challenges in minutes.

April 17, 2025

by Mokhtar Ebrahim

· 4,275 Views · 3 Likes

Debugging Deadlocks Using Java Synchronization Aids

This article explains how to isolate and test concurrent operations that led to deadlock and demonstrates how CountDownLatch and CyclicBarrier could help achieve this.

April 16, 2025

by Horatiu Dan

CORE

· 8,027 Views · 10 Likes

Enhancing Avro With Semantic Metadata Using Logical Types

Avro logical types add semantic meaning to primitive data types, making schemas more expressive. This blog explores their benefits and common use cases.

April 16, 2025

by Gurmeet Saran

· 6,555 Views · 2 Likes

How to Attach SQL Database Without a Transaction Log File

Learn to attach a SQL database without a log file using SSMS or T-SQL. Follow steps to seamlessly attach your database, even if the log file is missing.

April 15, 2025

by Priyanka Chauhan

· 6,148 Views · 1 Like

A Deep Dive into Apache Doris Indexes

Apache Doris offers various index types, each designed for specific needs. Let’s delve into their features and discover what drives their exceptional performance.

April 14, 2025

by Darren Xu

· 6,087 Views

How Doris + Hudi Turned the Impossible Into the Everyday

Want to know how this "data giant ship" navigates the waves? Follow this article to uncover the amazing story of Doris and Hudi, the "dream team" of data.

April 14, 2025

by Zen Hua

· 5,835 Views · 4 Likes

Transforming Data Analytics by Combining SQL and ML

Learn how AI and ML extend SQL's capabilities for advanced analytics, predictive insights, and query optimization, transforming database interactions.

April 10, 2025

by Ramalakshmi Murugan

· 5,509 Views · 2 Likes

Python Packages for Validating Database Migration Projects

This article analyzes three widely used Python libraries — Pandas, SQLAlchemy, and PyMySQL/psycopg2 — detailing their capabilities, advantages, and limitations.

April 10, 2025

by Vignesh Govindarajan Ravichandran

· 4,195 Views

The Latest Databases Topics