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.
🍰Top 10 Best Cake Shop Full-Stack Projects for Beginners in C#, ASP.NET, and .NET Core

🍰Top 10 Best Cake Shop Full-Stack Projects for Beginners in C#, ASP.NET, and .NET Core

13
Comments
2 min read
How to Document SQL Server Schemas Visually in 2025

How to Document SQL Server Schemas Visually in 2025

12
Comments 1
4 min read
Design Your Database with dbdiagram.io (Beginner to Pro)

Design Your Database with dbdiagram.io (Beginner to Pro)

10
Comments
3 min read
SQL vs NoSQL? Why Not Both?

SQL vs NoSQL? Why Not Both?

Comments 1
2 min read
PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

PostgreSQL Branching: Xata vs. Neon vs. Supabase - Part 1

16
Comments
12 min read
What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

What’s the Difference Between IS NULL and = NULL in a MySQL WHERE Clause?

2
Comments 2
1 min read
Database optimization best practices

Database optimization best practices

Comments
3 min read
SQL COALESCE Explained: Simplify NULL Handling in Queries

SQL COALESCE Explained: Simplify NULL Handling in Queries

Comments
3 min read
ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools

ALTER TABLE ADD COLUMN in SQL: Syntax, Tips & Tools

Comments
2 min read
จัดการข้อมูล Mac Address ให้อยู่หมัดด้วย PostgreSQL

จัดการข้อมูล Mac Address ให้อยู่หมัดด้วย PostgreSQL

Comments
1 min read
A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn

A COMPREHENSIVE LOOK INTO SQL : - What a Beginner can learn

2
Comments
5 min read
How to Design a Relational Database Schema in 2025

How to Design a Relational Database Schema in 2025

17
Comments 1
8 min read
StrataScratch's Advanced 25 Hard SQL Questions

StrataScratch's Advanced 25 Hard SQL Questions

1
Comments
2 min read
Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative

Automating SQL Reports Without Power BI or SSRS: A Lightweight Alternative

4
Comments 3
4 min read
OUTPUT Clause — Log, Sync, and Debug Like a Pro

OUTPUT Clause — Log, Sync, and Debug Like a Pro

Comments
6 min read
SQL Server String Aggregation: FOR XML PATH vs. STRING_AGG Performance Comparison and Optimization

SQL Server String Aggregation: FOR XML PATH vs. STRING_AGG Performance Comparison and Optimization

Comments
4 min read
Segmented Accumulation by Condition — From SQL to SPL #30

Segmented Accumulation by Condition — From SQL to SPL #30

6
Comments 1
1 min read
Memelang: Hybrid graph-relational query language for RAG

Memelang: Hybrid graph-relational query language for RAG

Comments
4 min read
Spark Augmented Reality (AR) Filter Engagement Metrics

Spark Augmented Reality (AR) Filter Engagement Metrics

1
Comments
3 min read
PawSQL Community Edition: A Free & Self-Hosted Enterprise-Grade SQL Optimizer, Now Available to Individual Developers

PawSQL Community Edition: A Free & Self-Hosted Enterprise-Grade SQL Optimizer, Now Available to Individual Developers

2
Comments
3 min read
MySQL — Removendo Full Only Group By no MacOS X

MySQL — Removendo Full Only Group By no MacOS X

Comments 1
1 min read
🔷 Top 20+ .NET & OOPs Interview Questions (Easy Guide for Freshers)

🔷 Top 20+ .NET & OOPs Interview Questions (Easy Guide for Freshers)

12
Comments
3 min read
N+1 Query Problem

N+1 Query Problem

8
Comments
1 min read
Query YAML Like a Database — Why I Built YamlQL (And How It Works)

Query YAML Like a Database — Why I Built YamlQL (And How It Works)

3
Comments
4 min read
What is SQL and Why Does It Matter

What is SQL and Why Does It Matter

Comments
2 min read
loading...