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.
SQL RecycleBin: An Undo Button for SQL Server

SQL RecycleBin: An Undo Button for SQL Server

Comments 1
3 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 3: The Real Cost of Indexes

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 3: The Real Cost of Indexes

Comments
5 min read
I Completed HackerRank SQL Basic Select .Here's What I Learned...

I Completed HackerRank SQL Basic Select .Here's What I Learned...

Comments
2 min read
From Tables to Insights: A Beginner's Journey into SQL

From Tables to Insights: A Beginner's Journey into SQL

Comments
2 min read
REST-style GraphQL — one line of Java handles filtering + sorting + pagination + stats + CSV export.

REST-style GraphQL — one line of Java handles filtering + sorting + pagination + stats + CSV export.

1
Comments
6 min read
Resume Optimization for US Data Engineering from WeChat Mini-Programs

Resume Optimization for US Data Engineering from WeChat Mini-Programs

Comments
4 min read
Can You Run Hybrid Search on One Database? Yes! Here's How CrateDB Does It

Can You Run Hybrid Search on One Database? Yes! Here's How CrateDB Does It

2
Comments 4
9 min read
A practical journey into SQL

A practical journey into SQL

Comments
6 min read
Building a right-click 'query this file' workflow in VS Code with DuckDB

Building a right-click 'query this file' workflow in VS Code with DuckDB

Comments
2 min read
I Got Tired of Slow SQL Formatters That Upload My Queries — So I Built a Free One

I Got Tired of Slow SQL Formatters That Upload My Queries — So I Built a Free One

Comments
1 min read
5 SQL queries every data analyst ends up googling

5 SQL queries every data analyst ends up googling

Comments
3 min read
LEARNING SQL

LEARNING SQL

Comments
4 min read
Map First, Walk Second: What a Librarian Taught Me About Postgres

Map First, Walk Second: What a Librarian Taught Me About Postgres

1
Comments
3 min read
Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi

Five specific schema patterns — unbounded VARCHAR, nullable columns inside multi

Comments
7 min read
How I Built Memory for a Local AI Companion Without Sending Chats to a Server

How I Built Memory for a Local AI Companion Without Sending Chats to a Server

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