Search: "schema"

#code-review #production #risk-assessment

Review a Pull Request Diff With a Focus on What Could Break Production

Review this pull request diff with one focus: what could break production. Diff:...

👁 7 views

coding Intermediate

Write a SQL query that you'll still understand in six months

Write a SQL query that answers this question: [QUESTION]. Tables and columns I h...

#coding #sql #readability

👁 7 views

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database

#data #database-design #schema

data Advanced

Data: Design a Schema That Won't Need a Migration in 6 Months

I'm designing a schema for [DOMAIN] from scratch. The team wants to ship fast, b...

#power-query #m-language #etl

excel Advanced

Excel Power Query Recipe to Clean and Unify Multi-Sheet Sales Data

You are an Excel Power Query expert. I have a workbook with 12 monthly sales she...

#slo #data-quality #pipelines

data Advanced

Design a Data Quality SLO Framework for a Critical Pipeline

Act as a data reliability engineer. Help me design a data quality SLO framework ...

#migrations #zero-downtime #schema

Coding: Write a Migration Plan for a Schema Change That Can't Take Downtime

I need to change a schema (rename column, change type, add NOT NULL) on a high-t...

data Intermediate

Write a SQL query to find customers who used to engage but have quietly dropped off

I want to find 'silently churning' customers — users who used to be active and h...

#data #sql #churn

#data #analysis #investigation

data Advanced

Investigate a metric that suddenly moved

A metric I track moved unexpectedly. The metric is [METRIC]. It usually sits aro...

#coding #code-review #tech-debt

Push back on a code change that ships a feature but degrades the codebase

Act as a staff engineer. A teammate opened a PR that delivers [FEATURE] on time ...