DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
SCD Type-2 Without the Duplicate-Current-Row Footgun
vaishnavprabhu profile

SCD Type-2 Without the Duplicate-Current-Row Footgun

#dataengineering #sql #database #analytics
Comments 1
2 min read
Why Stripe payouts don't match your books
akarazhev profile

Why Stripe payouts don't match your books

#dataengineering #sql #fintech #stripe
Comments 5
4 min read
Ananthika Unlocks Athena: SQL Wisdom Without a Single Server ⚡
ananthikaa4 profile

Ananthika Unlocks Athena: SQL Wisdom Without a Single Server ⚡

#aws #database #serverless #sql
Comments
5 min read
How to Detect Schema Drift Before Production Deployments
databaseinsights profile

How to Detect Schema Drift Before Production Deployments

#sql #sqlserver #database #devops
10
Comments 3
6 min read
Army vs jOOQ
zoro7 profile

Army vs jOOQ

#database #java #opensource #sql
Comments
10 min read
5 Things AI Cannot Do at PostgreSQL
devunionx profile

5 Things AI Cannot Do at PostgreSQL

#postgressql #sql #sqlserver #ai
6
Comments
5 min read
A for Athena
amutha_nila profile

A for Athena

#aws #cloud #learning #sql
Comments
6 min read
Best Snowflake Data Modeling Tools: SQLDBM, Hackolade, erwin & Vertabelo for Reverse Engineering and DDL Generation
joonsystems profile

Best Snowflake Data Modeling Tools: SQLDBM, Hackolade, erwin & Vertabelo for Reverse Engineering and DDL Generation

#data #database #sql #tools
Comments
10 min read
Excel Turned a 20% Discount Into 19.999999999999998%. That Hid $2,325.
keenenwilkins profile

Excel Turned a 20% Discount Into 19.999999999999998%. That Hid $2,325.

#sql #beginners #career #excel
Comments 1
7 min read
Read your SQL back as one sentence before you run it
selene_nyx_ai profile

Read your SQL back as one sentence before you run it

#sql #database #postgres #mysql
Comments
6 min read
Indexes in PostgreSQL
im_nishant profile

Indexes in PostgreSQL

#postgressql #postgres #sql #database
1
Comments 2
5 min read
Is SQLazy Something Missing from Your dbt Workflow?
esproc_spl profile
Judy

Is SQLazy Something Missing from Your dbt Workflow?

#analytics #dataengineering #sql
5
Comments
6 min read
I built a fake 30-year company for a more realistic Postgres sample database
ukhype1983_a92e7968657284 profile

I built a fake 30-year company for a more realistic Postgres sample database

#showdev #postgres #sql #database
Comments
3 min read
Vanna is archived. The failure mode none of the replacements fix.
ashish_sinha_5241c7673d93 profile

Vanna is archived. The failure mode none of the replacements fix.

#sql #ai #database #python
Comments
4 min read
SQL JOINS Explained
sguantai profile

SQL JOINS Explained

#beginners #database #sql #tutorial
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.