Search: "database-design"

#coding #database #migration

Write a Migration Plan for Renaming a Database Column

Plan a zero-downtime rename of database column [OLD_NAME] to [NEW_NAME] on table...

👁 10 views

legal Intermediate

Write an Internal Data Handling Policy That Employees Will Actually Follow

I need to write an internal data handling policy for a small company. The usual ...

#legal #compliance #data-policy

👁 9 views

#migration #sql #zero-downtime

Write a Defensive Migration Script for a NOT NULL Column Addition

Act as a database migration specialist. I need to add a NOT NULL column [column_...

👁 9 views

Database Query Optimization with EXPLAIN Analysis

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

#coding #sql #database

#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...

#excel #pivot-tables #executive-reporting

excel Intermediate

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

#excel #power query #decision

excel Intermediate

Decide when to use Power Query vs formulas vs a real database

I keep solving the same data problem three different ways across my team's sprea...

data Intermediate

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query

#coding #code review #maintainability

coding Intermediate

Review code like you actually have to maintain it next year

Review the code below as if you'll be the one maintaining it in twelve months. D...

👁 6 views

#data #sql #query-optimization

Optimize a SQL Query for Speed

You are a database performance engineer. I will paste a slow SQL query and the t...

#coding #sql #database

👁 6 views

data Intermediate

Data: Rewrite a Slow Query Without Changing What It Returns

I have a SQL query that's slow. Make it fast while keeping the result set identi...

#coding #sql #performance

Coding: Write the SQL Index I Actually Need (Not the One I Think I Need)

I have a slow query and I'm about to add an index. Before I do, help me think it...

data Advanced

Data: Write a Backfill Query That Won't Take Down the Database

I need to backfill [COLUMN/TABLE] with [LOGIC]. The table has [N] rows. Write th...

#data #sql #backfill

Debug an Intermittent Test Failure That's Only Happening in CI

I have a test that passes 100% of the time on my laptop but fails about 1 in 5 r...

#coding #debugging #ci

data Intermediate

Write and Explain a SQL Query

You are an expert SQL expert. Help me write a correct SQL query and understand e...

#data #sql #query

#caching #architecture #redis

Pick the right caching layer when every option looks reasonable on paper

Act as a staff engineer who has lived with these decisions. I need to add cachin...

👁 4 views