Databases Resources

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,045 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,745 Views · 12 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

· 1,830 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,016 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

· 2,888 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,601 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,703 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,509 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,696 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,788 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,796 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,804 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,861 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,480 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,283 Views · 2 Likes

Memory-Optimized Tables: Implementation Strategies for SQL Server

Through practical implementation guidance and real-world examples, learn how this in-memory technology can deliver 5- 30x performance improvements for OLTP workloads.

May 28, 2025

by arvind toorpu

CORE

· 4,537 Views · 4 Likes

How to Introduce a New API Quickly Using Micronaut

Knowing when to pivot can be vital to staying ahead of the competition. See how Cursor AI and Heroku can be leveraged to transform an idea into a reality.

May 28, 2025

by John Vester

CORE

· 14,056 Views · 2 Likes

Useful System Table Queries in Relational Databases

System tables store metadata about database objects like tables, columns, indexes, users, and privileges, which helps in understanding the configuration.

May 27, 2025

by Dhaval Patolia

· 3,136 Views · 2 Likes

Optimizing Serverless Computing with AWS Lambda Layers and CloudFormation

Learn how AWS Lambda Layers and CloudFormation simplify serverless computing by managing dependencies and automating infrastructure provisioning.

May 27, 2025

by Srinivas Chippagiri

CORE

· 17,312 Views · 3 Likes

A Guide to Auto-Tagging and Lineage Tracking With OpenMetadata

Learn how to automate PII tagging, metadata management, and SQL lineage tracking with GPT-4, OpenMetadata, dbt, Trino, and Python for smarter data governance.

May 27, 2025

by Sreenath Devineni

CORE

· 6,004 Views

The Latest Databases Topics