Databases Resources

Mastering Advanced Aggregations in Spark SQL

OLAP (Online Analytical Processing) aggregation techniques in Spark SQL are used for complex, multi-level data analysis over large datasets.

May 15, 2025

by Ram Ghadiyaram

CORE

· 5,461 Views · 8 Likes

Cosmos DB Disaster Recovery: Multi-Region Write Pitfalls and How to Evade Them

Learn how multi-region writes ad managed in Cosmos DB, key considerations to steer clear or, and best practices to architect a resilient system.

May 14, 2025

by Yash Gautam

· 5,118 Views · 3 Likes

Why Database Migrations Take Months and How to Speed Them Up

Database migrations are more than just moving data. With proper planning, preparation, and testing, you can reduce migration time to days or hours.

May 14, 2025

by Alexander Komyagin

· 4,440 Views · 1 Like

MySQL to PostgreSQL Database Migration: A Practical Case Study

In this case study, learn how migrating MySQL to PostgreSQL boosted query speed, optimized JSON and JOINs, and improved scalability for an e-commerce platform.

May 14, 2025

by Vlad Bilyak

· 4,886 Views · 2 Likes

A Simple, Convenience Package for the Azure Cosmos DB Go SDK

Learn about cosmosdb-go-sdk-helper: Simplify Azure Cosmos DB operations with Go. Features auth, queries, error handling, metrics, and Azure Functions support.

May 14, 2025

by Abhishek Gupta

CORE

· 3,826 Views · 1 Like

Performing and Managing Incremental Backups Using pg_basebackup in PostgreSQL 17

PostgreSQL 17 adds incremental backups with pg_basebackup and pg_combinebackup, saving time and storage by capturing only changed data since the last backup.

May 14, 2025

by arvind toorpu

CORE

· 4,105 Views · 4 Likes

Unmasking Entity-Based Data Masking: Best Practices 2025

Master entity-based data masking with best practices in identifying sensitive data, defining clear policies, preserving relationships, and auditing access.

May 13, 2025

by Yash Mehta

· 3,592 Views · 3 Likes

5 Subtle Indicators Your Development Environment Is Under Siege

Threat actors now target SDLC stages. Spot five key indicators of compromise and reinforce dev pipeline security with early detection and response.

May 13, 2025

by Raj Mallempati

· 3,663 Views · 2 Likes

AI-Based Threat Detection in Cloud Security

Learn how AI enhances cloud security with advanced threat detection methods like supervised learning, LLMs, and self-healing systems, tackling modern challenges.

May 12, 2025

by Tanvir Kaur

· 4,718 Views

Unlocking Data with Language: Real-World Applications of Text-to-SQL Interfaces

Leverage machine learning models to convert natural language queries into accurate and efficient SQL statements with AI-driven text-to-SQL conversion.

May 12, 2025

by Abrar Ahmed Syed

· 4,191 Views · 3 Likes

How Trustworthy Is Big Data?

Big data offers potential, but trust issues arise from poor quality, security, and accuracy. Organizations need strategy, governance, and training to ensure reliability.

May 12, 2025

by Dilip Kumar Rachamalla

· 4,264 Views

Automating Data Pipelines: Generating PySpark and SQL Jobs With LLMs in Cloudera

Use LLMs in Cloudera to convert natural language into PySpark or SQL, run pipelines with CDE, and manage secure, governed data using Iceberg and SDX.

May 12, 2025

by Anjan Kumar Ayyadapu

· 14,835 Views · 2 Likes

Revolutionizing Financial Monitoring: Building a Team Dashboard With OpenObserve

Find out how building a unified OpenObserve dashboard transformed my financial monitoring journey—cutting downtime, lowering cost, and enabling proactive operations.

May 9, 2025

by Sushma Kukkadapu

· 4,783 Views · 2 Likes

Mastering Advanced Traffic Management in Multi-Cloud Kubernetes: Scaling With Multiple Istio Ingress Gateways

Optimize traffic in multi-cloud Kubernetes with multiple Istio Ingress Gateways. Learn how they enhance scalability, security, and control through best practices.

May 8, 2025

by Prabhu Chinnasamy

· 8,473 Views · 52 Likes

Cloud Cost Optimization for ML Workloads With NVIDIA DCGM

SQL partitioning, predictive forecasting, GPU partitioning, and spot VMs can cut ML costs by up to 60% without hurting performance.

May 8, 2025

by Vineeth Reddy Vatti

· 3,645 Views · 1 Like

How to Configure and Customize the Go SDK for Azure Cosmos DB

Explore Azure Cosmos DB Go SDK: Configure retry policies, customize HTTP pipelines, implement OpenTelemetry tracing, and analyze detailed query metrics.

May 8, 2025

by Abhishek Gupta

CORE

· 4,884 Views · 1 Like

Start Coding With Google Cloud Workstations

Boost your development productivity with secure, GPU-powered Cloud Workstations. This guide shows you how to set up your environment and connect to BigQuery.

May 8, 2025

by Karteek Kotamsetty

· 37,376 Views · 3 Likes

Building Enterprise-Ready Landing Zones: Beyond the Initial Setup

A successful landing zone requires a carefully customized foundation that addresses organizational needs rather than relying on default cloud provider templates.

May 7, 2025

by Gaurav Mittal

· 4,364 Views · 2 Likes