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.
Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained
interviewshow-cs profile

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

#career #coding #interview #sql
3
Comments
4 min read
Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes
sanikolaev profile

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

#backend #database #search #sql
Comments
3 min read
Breaking the SQL Barrier: How to Build a Natural Language Database Assistant
rodrigo_sidneycolquequi profile

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

#ai #python #sql #tutorial
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
arash_zand profile

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

#dotnet #csharp #sql #postgres
Comments
7 min read
SQL window functions: what separates a mid-level from a senior developer
lbraun7 profile

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

#sql #postgres #backend #database
Comments
5 min read
Deploying MySQL on RDS and Joining Tables Like It's Production
hashirsaudkhan profile

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

#aws #database #sql #tutorial
Comments
3 min read
Prompting AI for Complex Multi-Table SQL: A Practical Guide
vivekdraxlr profile

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

#sql #database #ai #tutorial
1
Comments
5 min read
Star Schema vs Snowflake Schema: Which to Use and When
maheshwari9980 profile

Star Schema vs Snowflake Schema: Which to Use and When

#dataengineering #database #sql #datascience
Comments
4 min read
Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks
im_parzavilly_9fc83da282 profile

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

#database #performance #sql #tutorial
Comments
2 min read
READ COMMITTED isn't as safe as you think
dip_032d2fe1959e1990ddbb1 profile

READ COMMITTED isn't as safe as you think

#backend #database #postgres #sql
Comments 2
6 min read
A 1000x Speedup From One Index — and Why It Sometimes Does Nothing
danewu profile

A 1000x Speedup From One Index — and Why It Sometimes Does Nothing

#rails #database #sql #performance
Comments
7 min read
When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data
serina_8340 profile

When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data

#ai #database #llm #sql
5
Comments
8 min read
Day 1 of My Microsoft Fabric Learning Journey – Exploring Lakehouses
arunkarthick_kandasamy profile

Day 1 of My Microsoft Fabric Learning Journey – Exploring Lakehouses

#dataengineering #learning #microsoft #sql
Comments
1 min read
Tối ưu hóa cơ sở dữ liệu SQL trên máy chủ mã nguồn mở: Nghệ thuật của sự tinh giản
phantam38 profile

Tối ưu hóa cơ sở dữ liệu SQL trên máy chủ mã nguồn mở: Nghệ thuật của sự tinh giản

#sql #server
Comments
8 min read
Why Even Advanced AI Breaks Stock Registers: 12 Years of Snapshot Log Evolution and RDBMS Physics
alexcrazy74 profile

Why Even Advanced AI Breaks Stock Registers: 12 Years of Snapshot Log Evolution and RDBMS Physics

#ai #sql #programming #rdbms
Comments 1
4 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.