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.
QUICK SQL REVISION

QUICK SQL REVISION

1
Comments
14 min read
SQL Injection: The Security Nightmare Every Developer Must Understand

SQL Injection: The Security Nightmare Every Developer Must Understand

2
Comments
6 min read
Track Blocking and Deadlocks in MSSQL with my custom script

Track Blocking and Deadlocks in MSSQL with my custom script

3
Comments
4 min read
Linked Server vs OPENQUERY vs OPENROWSET vs OPENDATASOURCE

Linked Server vs OPENQUERY vs OPENROWSET vs OPENDATASOURCE

4
Comments
4 min read
Diving Deeper into SQL: Advanced Queries and Real-World Applications

Diving Deeper into SQL: Advanced Queries and Real-World Applications

Comments
3 min read
MySQL Performance Tuning: From Slow Queries to Lightning-Fast Database

MySQL Performance Tuning: From Slow Queries to Lightning-Fast Database

5
Comments
5 min read
Getting Started with Database Migrations using FluentMigrator

Getting Started with Database Migrations using FluentMigrator

Comments
6 min read
Practical SQL Observability for Forge Apps with forge-sql-orm

Practical SQL Observability for Forge Apps with forge-sql-orm

2
Comments
8 min read
🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries

🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries

Comments
2 min read
Free Interactive SQL Practice Platform for Developers

Free Interactive SQL Practice Platform for Developers

Comments
1 min read
Generate UUID in PostgreSQL

Generate UUID in PostgreSQL

1
Comments
1 min read
Getting Started with PostgreSQL: A Comprehensive Guide

Getting Started with PostgreSQL: A Comprehensive Guide

Comments
2 min read
БД2 Практ (подзапрос)

БД2 Практ (подзапрос)

Comments
2 min read
Master SQL with Interactive Hands-On Practice

Master SQL with Interactive Hands-On Practice

Comments
1 min read
How to Generate SQL Queries with AI: Step-by-Step Guide Using Claude Code and DBHub

How to Generate SQL Queries with AI: Step-by-Step Guide Using Claude Code and DBHub

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