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

👁 5 views

#excel #pivot-tables #executive-reporting

Database Query Optimization with EXPLAIN Analysis

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

#coding #sql #database

👁 5 views

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

👁 5 views

#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 #sql #query-optimization

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

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

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

#legal #compliance #data-policy

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

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

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

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