Databases Resources

Understanding SQL Server Query Store: A Comprehensive Guide

In this article, we will explore what the Query Store is, its benefits, scenarios for its use, and steps to implement it with examples.

April 1, 2025

by arvind toorpu

CORE

· 6,463 Views · 8 Likes

Building Scalable Data Lake Using AWS

Build a secure, scalable AWS data lake with S3, Glue, and Lake Formation, and learn key components, best practices, and analytics for optimized insights.

April 1, 2025

by Digvijay Waghela

· 4,613 Views · 3 Likes

Understanding Database Consistency: A Key Concept in Distributed Systems

This article explores database consistency models in distributed systems and explains trade-offs between strong, eventual, causal, and other consistency types.

March 31, 2025

by Sandeep Kumar Gond

· 6,094 Views · 5 Likes

Doris vs Elasticsearch: A Comparison and Practical Cost Case Study

Apache Doris excels in analytics, SQL support, and cost efficiency, while Elasticsearch leads in text search but has higher storage costs and complexity.

March 31, 2025

by Darren Xu

· 3,655 Views · 2 Likes

Stop Exposing Secrets! Secure Your APIs in Postman Like a Pro

Don't expose your secrets! Learn how to secure your APIs in Postman with Vault, Secret Scanner, and best practices to keep your data safe.

March 31, 2025

by Gbadebo Bello

· 4,613 Views · 6 Likes

AWS WAF Classic vs WAFV2: Features and Migration Considerations

AWS WAFV2 is a major upgrade over WAF Classic, offering better scalability, flexibility, and automation. We'll also look at key migration considerations.

March 31, 2025

by Srinivas Chippagiri

CORE

· 20,366 Views · 2 Likes

Product Design vs Platform Design for Software Development

Compare platform and product design approaches for business needs. Understand their differences and compare them to find the best fit for your use case.

March 31, 2025

by Ravi Kiran Mallidi

CORE

· 4,166 Views · 5 Likes

The Role of DevSecOps in Securing Multi-Cloud Architectures

Discover how DevSecOps enhances security in multi-cloud ecosystems, enabling safe implementation and addressing key challenges with effective strategies.

March 31, 2025

by Hrushikesh Deshmukh

· 4,431 Views · 2 Likes

Why Mocking Sucks

Mocking can be risky as it doesn't replicate real-world conditions, making real development versions of services preferable.

March 28, 2025

by Andy Pai

· 4,398 Views · 2 Likes

Using Terraform Moved Block to Refactor Resources

Terraform moved block, introduced in version 1.1.0, provides a straightforward way to refactor resources by explicitly mapping old resource addresses to new ones.

March 28, 2025

by Mariusz Michalowski

· 4,508 Views · 1 Like

Building a Scalable ML Pipeline and API in AWS

This blog explains the architecture and design for building a scalable end-to-end ML pipeline using AWS for automated model execution, real-time data processing, and API.

March 28, 2025

by Dhanush Thirugnana

· 5,354 Views · 3 Likes

Moving PeopleSoft ERP Data Between Databases With Data Mover Scripts

Learn how to efficiently move application data between different PeopleSoft databases using Data Mover scripts, with detailed examples and step-by-step instructions.

March 27, 2025

by Tirumala Rao Chimpiri

· 4,129 Views · 1 Like

Automatic Versioning in Mobile Apps

This article presents an automatic versioning and migration framework for mobile app databases using schema hashes and seamless upgrades.

March 27, 2025

by Liewen Huang, Ph.D.

· 2,781 Views · 2 Likes

Optimized Metrics Generation With Metadata-Driven Dynamic SQL

Learn about a metadata-driven approach to generate metrics with dynamic SQL, enhancing scalability, flexibility, and efficiency in auditing and reporting.

March 27, 2025

by Tapan Parekh

· 2,801 Views · 1 Like

Avoid Cross-Shard Data Movement in Distributed Databases

Learn four effective strategies to optimize distributed joins, reduce network overhead, and improve query performance in sharded databases.

March 26, 2025

by Baskar Sikkayan

· 6,512 Views · 5 Likes

Jakarta NoSQL 1.0: A Way To Bring Java and NoSQL Together

Jakarta NoSQL 1.0 standardizes NoSQL integration in Java with familiar annotations, a fluent API, and support for multiple NoSQL types—boosting productivity, portability.

March 26, 2025

by Otavio Santana

CORE

· 9,263 Views · 5 Likes

GenAI: From Prompt to Production

GenAI-Logic is a prompt-driven approach to describing a model and logic using natural language. Create a time tracking system and post to production in less than 2 hours.

March 25, 2025

by Tyler Band

· 6,107 Views · 7 Likes

Java Reborn: Conquering Cloud-Native and Next-Gen Concurrency

Brace yourself — Java conquers cloud-native microservices, unleashes Loom’s fast concurrency, and soars with Valhalla and Panama — future-ready and fierce!

March 25, 2025

by Alok Tibrewala

· 8,894 Views · 10 Likes

Mastering Async Context Manager Mocking in Python Tests

Simplify testing complex asynchronous Python code by mastering async context manager mocking with Pytest, ensuring reliable and maintainable test coverage.

March 25, 2025

by Aditya Karnam Gururaj Rao

· 6,686 Views · 2 Likes

Video Generation With Java: Leverage Nova and Amazon Bedrock

Learn how to generate videos using Amazon Nova on Amazon Bedrock with Java. This step-by-step guide covers AWS setup and Java code for video creation.

March 25, 2025

by Danil Temnikov

CORE

· 7,938 Views · 4 Likes

The Latest Databases Topics