Skip to content
datarekha
Blog Production AI · GATE DA · how concepts actually work · Page 7 of 13

From theory to the systems that demand real understanding.

Long-form pieces on how production-AI teams orchestrate agents, serve models, and build the stack, plus GATE DA essays that turn probability, linear algebra, DBMS, ML, and AI into durable concepts.

295 posts · 20 categories
SQL Jun 2, 2026

NULL is not a value, and that wrecks your WHERE clause

NULL means unknown, so every comparison involving it yields unknown — not false — and that silent third outcome is responsible for more wrong query results than any other SQL trap.

9 min read Read
Career Jun 2, 2026

Office politics for honest people

Politics is just how decisions and resources get allocated among people — and navigating it with integrity is a learnable skill, not a moral compromise.

8 min read Read
ML Jun 2, 2026

One-hot encoding and the curse of high cardinality

One-hot encoding a zip code column turns 42,000 rows into a sparse desert — thousands of nearly-empty columns that starve your model of signal while drowning it in noise.

9 min read Read
Career Jun 2, 2026

One-on-ones that aren't a waste of time

Most 1:1s quietly die because managers treat them as a status meeting and reports let them, but reclaiming one hour a week can change the entire arc of someone's career.

8 min read Read
ML Jun 2, 2026

Overfitting is memorizing the answer key

A model that aces its training data but collapses on new data has not learned anything — it has memorized noise, and the gap between its training score and its test score is the confession.

9 min read Read
Statistics Jun 2, 2026

p-values are not the probability you are right

A p-value of 0.04 does not mean there is a 96 percent chance your variant wins — it means something far stranger, and knowing the difference is what separates analysts who ship good decisions from analysts who ship confident noise.

10 min read Read
Python Jun 2, 2026

Method chaining: writing pandas like a pipeline, not a pile

Chaining assign, query, groupby, and agg into one readable pipeline beats a pile of intermediate variables — it reads top to bottom like a recipe, kills stale-variable bugs, and sidesteps the SettingWithCopy trap.

10 min read Read
Career Jun 2, 2026

The performance review: making your case

Your manager cannot remember everything you did — your job is to arrive with evidence, not hope.

8 min read Read
Career Jun 2, 2026

Your personal brand at work

Your reputation is built in the moments you are not watching — and most people are either invisible or noisy, with very few landing in the narrow band that actually earns trust and opportunity.

8 min read Read
Career Jun 2, 2026

Prioritization: telling urgent from important

Busy is not the same as effective — the Eisenhower Matrix exposes the one quadrant where real careers are built, and why almost everyone starves it.

8 min read Read
Career Jun 2, 2026

Psychological safety: what it is and how to build it

The team that never disagrees in meetings is not your best team — it is your most dangerous one.

8 min read Read
Career Jun 2, 2026

Public speaking without the panic

Stage fright is just energy without a container — once you know how to structure a talk and practice it out loud, the nerves stop being the enemy and start doing the work for you.

8 min read Read
Python Jun 2, 2026

The mutable default argument, and other Python footguns

Python evaluates default argument values exactly once, at function definition time, which means a mutable default is a shared object that silently accumulates state across every call.

8 min read Read
Career Jun 2, 2026

Quiet quitting to quiet cracking: a field guide to disengagement

Quiet quitting, quiet cracking, boreout, conscious unbossing — work keeps inventing words for checking out. A field guide to what each signals.

9 min read Read
RAG Jun 2, 2026

RAG in one diagram: retrieve, augment, generate

The cleanest mental model for retrieval-augmented generation: why pasting your docs into a prompt beats hoping the LLM already knows them, and the two failure modes that kill every RAG system in production.

8 min read Read
Business Analytics Jun 2, 2026

How to read a P&L in sixty seconds

The income statement is the one page every business speaks fluently, and once you know the grammar you can judge a company before your coffee gets cold.

9 min read Read
SQL Jun 2, 2026

CTEs turned my unreadable query into something I can follow

A common table expression is less a feature than a cognitive tool — it lets you read a complex query from top to bottom, in the order you actually think, instead of inside-out from the deepest parenthesis.

8 min read Read
Career Jun 2, 2026

Reading the room

The same message can land perfectly or detonate silently — the difference is rarely the words you chose, it is whether you read the room before you opened your mouth.

8 min read Read
Career Jun 2, 2026

How to receive feedback without getting defensive

The instinct to defend yourself when criticized is perfectly human — and it is the single habit most reliably separating people who plateau from people who compound.

8 min read Read
ML Jun 2, 2026

Regularization is a tax on complexity

Your model will always overfit given enough rope — regularization is the mechanism that prices complexity so the model only grows elaborate when the data actually demands it.

9 min read Read
Career Jun 2, 2026

Remote work that does not tank your career

Out of sight becomes out of mind faster than you think — but visibility is a skill you can build deliberately, even from a spare bedroom.

8 min read Read
Career Jun 2, 2026

Running a retrospective that changes things

Most retros are theater — same complaints, different quarter — because the team conflates venting with deciding and leaves without a single named owner.

8 min read Read
Career Jun 2, 2026

Negotiating your salary (and why you must)

The raise you fail to negotiate in year one quietly compounds into a six-figure gap by mid-career — and no one will hand it back to you.

8 min read Read
Career Jun 2, 2026

Saying no without burning bridges

Every yes you give carelessly is a debt you will pay with your credibility — learning to decline well is not a career risk, it is what makes your yeses worth anything.

8 min read Read