Skip to content

DEV Community

select * from SQL

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

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

Amar Abaz

Jan 18

Modular Approach to Database Performance and Maintainability

#sqlserver #filegroups #tutorial #sql

4 min read

Yukti Sahu

Dec 14 '25

5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

#tutorial #beginners #sql #database

4 min read

Jan 13

SQL Aggregations Finally Made Sense: GROUP BY, HAVING, MIN, MAX, AVG

#database #postgres #beginners #sql

3 min read

Prashant Sharma

Dec 11 '25

DuckDB: how to fine tune parameters?

#database #performance #tutorial #sql

2 min read

Rebooter.S

Jan 16

SARGable Condition Rewriting: Practical Solutions for Date Filtering Optimization

#sql #mysql

9 min read

SGTSanjay

Dec 11 '25

How I Reduced a 53-Minute MySQL Job to 15 Minutes on MySQL 5.7 (Without Changing Hardware)

#database #performance #sql

1 min read

Hui

Dec 15 '25

The One Thing You Can't Refactor: How to Architect Bulletproof Database Schemas with AI

#database #sql #architecture #systemdesign

5 min read

Cristian Malaga

Jan 15

How To Solve LeetCode 1193

#leetcode #sql

2 min read

Dec 11 '25

sql9

#help #database #sql

2 min read

Dec 11 '25

sql2

#cli #sql #tooling

1 min read

Cristian Malaga

Jan 15

How To Solve LeetCode 586

#sql #leetcode

2 min read

Dec 11 '25

Tutorial SQL Injection: Panduan Lengkap untuk Pemula

#cybersecurity #sql #beginners #tutorial

11 min read

Lucas Wade

Dec 9 '25

SQL vs NoSQL for SaaS Platforms Which One to Choose

#saas #database #sql #architecture

4 min read

Erlan Akbaraliev

Dec 10 '25

БД5 Практ (View)

#database #sql #tutorial

1 min read

Dec 9 '25

map

#database #dataengineering #sql

1 min read

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