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.
Our SQL Server loop kept writing the previous row's value

Our SQL Server loop kept writing the previous row's value

Comments
4 min read
SQL vs NoSQL Databases: Which One Should You Choose?

SQL vs NoSQL Databases: Which One Should You Choose?

5
Comments
5 min read
I Built a Chrome Extension - Sidekick

I Built a Chrome Extension - Sidekick

5
Comments
2 min read
Managing Database Migrations with Alembic

Managing Database Migrations with Alembic

Comments
2 min read
Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras

Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras

1
Comments
11 min read
Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained

Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained

2
Comments
4 min read
Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

Comments
3 min read
Breaking the SQL Barrier: How to Build a Natural Language Database Assistant

Breaking the SQL Barrier: How to Build a Natural Language Database Assistant

1
Comments 2
2 min read
Migrating 200 Million Records in .NET without crashing production: From Row-by-Row to a Crash-Safe Batched Pipeline

Migrating 200 Million Records in .NET without crashing production: From Row-by-Row to a Crash-Safe Batched Pipeline

Comments
7 min read
SQL window functions: what separates a mid-level from a senior developer

SQL window functions: what separates a mid-level from a senior developer

Comments
5 min read
Deploying MySQL on RDS and Joining Tables Like It's Production

Deploying MySQL on RDS and Joining Tables Like It's Production

Comments
3 min read
Prompting AI for Complex Multi-Table SQL: A Practical Guide

Prompting AI for Complex Multi-Table SQL: A Practical Guide

1
Comments
5 min read
Star Schema vs Snowflake Schema: Which to Use and When

Star Schema vs Snowflake Schema: Which to Use and When

Comments
4 min read
Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks

Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks

Comments
2 min read
READ COMMITTED isn't as safe as you think

READ COMMITTED isn't as safe as you think

Comments 2
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.