Databases Resources

From Monolith to Containers: Real-World Migration Blueprint

This guide shows how to move from a monolith to containers: containerize the app, split services gradually, adopt Kubernetes, automate with CI/CD, and modernize.

June 5, 2025

by Ravi Teja Thutari

CORE

· 4,321 Views · 7 Likes

Enhancing SQL Server Security With AI-Driven Anomaly Detection

Learn how to detect, manage, and resolve orphaned users in SQL Server using advanced queries, best practices, and AI-driven security enhancements.

June 4, 2025

by Bhanuprakash Madupati

· 71,641 Views · 24 Likes

How I Supercharged My GenAI App and Saved My Sanity

Finding a better way to handle real-time data for my GenAI app pushed me to rethink the tools I use—and that decision paid off in ways I never expected.

June 4, 2025

by Haymang Ahuja

· 1,596 Views · 1 Like

Zero-Latency Architecture: Database Triggers + Serverless Functions for Modern Reactive Architectures

Trigger serverless functions directly from database changes to build event-driven applications that respond instantly to data updates.

June 4, 2025

by Mahesh Vaijainthymala Krishnamoorthy

· 2,545 Views · 3 Likes

Master SQL Performance Optimization: Step-by-Step Techniques With Case Studies

Optimize SQL queries by using proper indexing, selecting necessary columns, optimizing joins, and minimizing subqueries to enhance database performance.

June 4, 2025

by Priyam Ganguly

· 3,140 Views · 2 Likes

Supercharge Your Java Apps With AI: A Practical Tutorial

A practical, code-rich tutorial showing Java developers AI integration via TensorFlow and OpenAI with examples like NLP, chatbots, and image processing.

June 4, 2025

by Alok Tibrewala

· 4,205 Views · 4 Likes

8 Steps to Proactively Handle PostgreSQL Database Disaster Recovery

PostgreSQL offers robust features like failover slot synchronization and precise WAL control to help recover from data corruption.

June 4, 2025

by Dr. Ibrar Ahmed

· 2,848 Views · 14 Likes

Managing Encrypted Aurora DAS Over Kinesis With AWS SDK

Amazon Aurora DAS streams encrypted activity data via Kinesis for secure monitoring. This guide shows how to decrypt it using the AWS Encryption SDK.

June 3, 2025

by Shubham Kaushik

· 2,005 Views · 2 Likes

Improving Cloud Data Warehouse Performance: Overcoming Bottlenecks With AWS and Third-Party Tools

Cloud data warehousing performance can be optimized with AWS tools and third-party solutions like Matillion, Fivetran, and Looker.

June 3, 2025

by Dilip Kumar Rachamalla

· 3,100 Views · 1 Like

PostgreSQL Performance Tuning

PostgreSQL 17 brings several performance improvements and features for OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) workloads.

June 2, 2025

by Dr. Ibrar Ahmed

· 3,008 Views · 2 Likes

The Truth About AI and Job Loss

AI isn't just another technological shift; it's a race against time where it requires faster learning and adaptation than any previous technological transition.

June 2, 2025

by Niruta Talwekar

· 4,685 Views · 8 Likes

MySQL Formatter: How to Make Beautiful Code and Why You Need It

Learn about MySQL Formatter and Beautifier, its significance in database management, and how it works. Improve your MySQL queries for better readability and maintenance.

June 2, 2025

by Edwin Sanchez

· 2,860 Views

How to Improve Copilot's Accuracy and Performance in Power BI

Copilot in Power BI is a powerful tool, but it heavily depends on how well the data model is created and the clear metadata description of tables, columns, and measures.

June 2, 2025

by Harsh Patel

· 2,723 Views · 1 Like

Scaling Azure Microservices for Holiday Peak Traffic Using Automated CI/CD Pipelines and Cost Optimization

Automate Azure microservice scaling with CI/CD, AKS, and IaC for cost-effective, error-free holiday peak traffic handling.

May 30, 2025

by Prabhu Chinnasamy

· 5,798 Views · 52 Likes

Resolving Parameter Sensitivity With Parameter Sensitive Plan Optimization in SQL Server 2022

Learn how SQL Server 2022's Parameter Sensitive Plan Optimization (PSP) solves parameter sniffing by caching multiple execution plans for parameterized queries.

May 30, 2025

by arvind toorpu

CORE

· 3,927 Views · 3 Likes

Source-Driven Development in Salesforce: Managing Metadata and API Versions

Source-Driven Development streamlines Salesforce deployments with version control and consistent API management, boosting stability and scalability.

May 30, 2025

by Ilya Dudkin

CORE

· 3,953 Views · 1 Like

ACID vs BASE: Transaction Models Explained

When it comes to handling transactions, its ACID vs BASE principles. I will cover their description, use cases, and in-depth comparison.

May 29, 2025

by Bartłomiej Żyliński

CORE

· 2,904 Views

Introducing Graph Concepts in Java With Eclipse JNoSQL, Part 2: Understanding Neo4j

Learn how to integrate Neo4j into Java apps using Eclipse JNoSQL 1.1.8 — model entities, define relationships, and query graphs with Cypher and Jakarta Data.

May 28, 2025

by Otavio Santana

CORE

· 4,994 Views · 1 Like

Comparing Managed Postgres Options on The Azure Marketplace

Azure offers several managed Postgres services designed for a variety of use cases. In this article, we review the key differences among them.

May 28, 2025

by Carlota Soto

· 4,686 Views · 2 Likes

How to Use AWS Aurora Database for a Retail Point of Sale (POS) Transaction System

Using Aurora, AWS's managed, highly scalable relational database, for a POS transaction system ensures efficient scaling to handle high transaction volumes.

May 28, 2025

by Spurthi Jambula

· 4,454 Views · 2 Likes

The Latest Databases Topics