Teaching the Optimizer to Learn: How Machine Learning Is Reshaping Query Optimization
The optimizer’s oldest weak point Continue reading on Medium » The optimizer’s oldest weak pointContinue reading on Medium » Read More Sql on Medium #sql
How Do We ETL: A Comprehensive Guide to ETL Processes, Table Types, and Slowly Changing Dimensions
A practitioner’s deep dive into building robust, audit-ready data pipelines — from raw extraction to SCD Type 6 and everything in between. Continue reading on Medium » A practitioner’s deep…
10 Technical Skills Every Data Engineer Should Have
The stack everybody actually uses, explained in plain English. Continue reading on Medium » The stack everybody actually uses, explained in plain English.Continue reading on Medium » Read More Sql…
Why RASTER Data in SQL More Powerful Than You Think (And How to Master Them)
How raster data enables powerful spatial analysis, modeling, and visualization directly within SQL workflows Continue reading on Medium » How raster data enables powerful spatial analysis, modeling, and visualization directly…
Perintah Untuk Menjalankan Script SQL
Berikut ini adalah perintah untuk menjalankan script SQL di Ubuntu server versi 26 : Continue reading on Medium » Berikut ini adalah perintah untuk menjalankan script SQL di Ubuntu server…
The End of Dashboards? How AI Is Redefining Enterprise Analytics
*The future of enterprise analytics is not about creating more dashboards. It is about helping people ask better questions and understand… Continue reading on Medium » *The future of enterprise…
How to Write SQL Queries That Detect Silent Join Key RE-ENCODING in Production
SQL validation patterns for detecting hidden join key transformations before they corrupt production results Continue reading on Medium » SQL validation patterns for detecting hidden join key transformations before they…
FROM PEN AND PAPER TO EXCEL, SQL, AND POWER BI
Before the advent of Power BI, SQL, and Microsoft Excel, dealing with data required nothing more than the use of a sheet of paper, a… Continue reading on Medium »…
PostgreSQL Incident Response: A Practical Guide to Diagnosing Production Database Failures
A practical guide to diagnosing and responding to the most common PostgreSQL production incidents, including connection exhaustion, lock… Continue reading on CodeX » A practical guide to diagnosing and responding…
How to format Zipcode / Postal Code in Oracle
Sometimes , in the applications , zipcodes are stored as numbers . That means , the leading zeros for some of the postal codes will not be… Continue reading on…
Data Analysis Help with Expert Tools — 20% Discount ✨
📊 Data Analysis Help with Expert Tools — 20% Discount ✨ Continue reading on Medium » 📊 Data Analysis Help with Expert Tools — 20% Discount ✨Continue reading on Medium…
Leetcode 1148 Article Views 1
In this Question we need to find The Author who has read their own article. Continue reading on Medium » In this Question we need to find The Author who…
ICA VM Write-Up: Complete Walkthrough from Enumeration to Root
In this walkthrough, we will tackle the ICA: 1 vulnerable machine from VulnHub. This boot-to-root challenge provides an excellent hands-on… Continue reading on Medium » In this walkthrough, we will…
Leetcode 1683 Invalid Tweets
The Problem is very simple as we need to find the tweet_id Continue reading on Medium » The Problem is very simple as we need to find the tweet_idContinue reading…
One Data Thing A Day: CTEs Done Right (And the Trap That Almost Got Me)
This week’s theme is CTEs. Not just how to write them — but the one thing about them that nobody explains until it’s already cost you a… Continue reading on…
What I Wish I Knew Before Passing the New DP 800 Microsoft SQL AI Developer Associate Certification
I recently passed the DP-800 SQL AI Developer Associate exam. Since it is a new certification, I want to share some tips that I would have… Continue reading on Medium…
Master SQL from Scratch : A Beginner’s Roadmap to Databases, Data Analysis and Tech Careers
Data is at the centre of almost every modern organisation. Every customer interaction, online purchase, financial transaction, employee… Continue reading on Medium » Data is at the centre of almost…
Marketing Campaign Analysis Using Power BI: Transforming Campaign Data into Business Insights
Introduction: Continue reading on Medium » Introduction:Continue reading on Medium » Read More Sql on Medium #sql
From Spatial Index Join to Eval Data Pipelines
Over June and July 2026, Databend shipped 182 changes across query optimization, spatial analytics, open lakehouse integration, data… Continue reading on Medium » Over June and July 2026, Databend shipped…
From Million-Token Agents to Eval-Ready Data
From Kafka ingestion and schema-flexible raw storage to incremental processing, Evals, and governed analytics for million-token AI… Continue reading on Medium » From Kafka ingestion and schema-flexible raw storage to…