select * from SQL Page 56 - DEV Community

Skip to content

DEV Community

Allowed

Posts about learning SQL
Posts about tips, tricks, problems, and answers
Posts about news or commentary of the field
Posts about specific tooling or frameworks

Think what would someone wanting to learn more about SQL want to see.

Not Allowed

Articles that mention SQL in passing
Articles that break the terms of use

SQL is the language of data, has been for nearly 50 years now!

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Arash Zand

Jul 30

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

#dotnet #csharp #sql #postgres

7 min read

Jun 26

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

#sql #postgres #backend #database

5 min read

Hashir Saud Khan

Jul 19

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

#aws #database #sql #tutorial

3 min read

Jun 26

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

#sql #database #ai #tutorial

5 min read

Vikas Maheshwari

Jun 25

Star Schema vs Snowflake Schema: Which to Use and When

#dataengineering #database #sql #datascience

4 min read

Jun 25

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

#database #performance #sql #tutorial

2 min read

Dipta

Jul 18

READ COMMITTED isn't as safe as you think

#backend #database #postgres #sql

6 min read

Dane Wu

Jun 25

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

#rails #database #sql #performance

7 min read

Serina

Jun 25

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

#ai #database #llm #sql

8 min read

Jun 25

Day 1 of My Microsoft Fabric Learning Journey – Exploring Lakehouses

#dataengineering #learning #microsoft #sql

1 min read

Aug 29

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

8 min read

Joy Mbugua

Jul 18

Building My First Real Database: What a Weekend SQL Assignment Taught Me About Postgres (and Git)

#sql #postgres #database #github

3 min read

Kostya Bartashevich

Jul 28

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 1: Context & Principles

#azure #database #sql #architecture

5 min read

Zubair Iftikhar

Jun 25

How to Convert Plain Text into JavaScript Arrays, Python Lists, JSON, and SQL IN Clauses

#javascript #productivity #python #sql

8 min read

Jul 27

WHERE $1::timestamptz IS NULL OR "timestamp" > $1

#database #performance #postgres #sql

7 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.