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.
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
Optimizing SQL LIKE Security, Performance and Best Practices

Optimizing SQL LIKE Security, Performance and Best Practices

Comments
10 min read
SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL

SQL for Data Analytics: A Must Read for Beginner Data Analysts Before Diving Into SQL

1
Comments 2
4 min read
Using LIKE with Variables and Patterns in SQL

Using LIKE with Variables and Patterns in SQL

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