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.
compare3
query_filter_591122b53770 profile

compare3

#code #database #sql
Comments
1 min read
Is SQL Injection dead in 2025? Finding Critical Bugs in Item Pagination
icyyy profile

Is SQL Injection dead in 2025? Finding Critical Bugs in Item Pagination

#sql #web #database #security
1
Comments
2 min read
pg-status - a lightweight microservice for checking PostgreSQL host status
krylosov-aa profile

pg-status - a lightweight microservice for checking PostgreSQL host status

#postgres #sql #c
1
Comments
7 min read
HackerRank 'The Pads' MySQL
carol_caillaud profile

HackerRank 'The Pads' MySQL

#dataengineering #beginners #sql #mysql
Comments
3 min read
How to Read SQL Server Execution Plans: 7 Things That Matter
mashrulhaque profile

How to Read SQL Server Execution Plans: 7 Things That Matter

#sqlserver #database #performance #sql
4
Comments
10 min read
7 Best Resources to Learn SQL: My Journey from Confusion to Confidence
stack_overflowed profile

7 Best Resources to Learn SQL: My Journey from Confusion to Confidence

#webdev #programming #sql
Comments
3 min read
From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts
hadywalied profile

From 40% to 100% SQL Generation Accuracy: Why Local AI Needs Self-Correction, Not Perfect Prompts

#sql #llm #machinelearning #ai
1
Comments
4 min read
SQL Injection: The Security Nightmare Every Developer Must Understand
sizan_mahmud0_e7c3fd0cb68 profile

SQL Injection: The Security Nightmare Every Developer Must Understand

#security #database #sql #webdev
2
Comments
6 min read
Track Blocking and Deadlocks in MSSQL with my custom script
abeamar profile

Track Blocking and Deadlocks in MSSQL with my custom script

#sqlserver #sql #database #deadlock
3
Comments
4 min read
Linked Server vs OPENQUERY vs OPENROWSET vs OPENDATASOURCE
abeamar profile

Linked Server vs OPENQUERY vs OPENROWSET vs OPENDATASOURCE

#sqlserver #database #sql #remotequery
4
Comments
4 min read
Diving Deeper into SQL: Advanced Queries and Real-World Applications
ch-kartik profile

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

#sql #database #dataanalytics #datascience
Comments
3 min read
MySQL Performance Tuning: From Slow Queries to Lightning-Fast Database
sepehr profile

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

#mysql #database #performance #sql
5
Comments
5 min read
Getting Started with Database Migrations using FluentMigrator
imdj profile

Getting Started with Database Migrations using FluentMigrator

#fluentmigrator #azure #sql #sqlserver
Comments
6 min read
Practical SQL Observability for Forge Apps with forge-sql-orm
vzakharchenko profile

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

#sql #monitoring #performance #tooling
2
Comments
8 min read
🧠 Understanding SQL Execution Order: The Real Flow Behind Your Queries
nk_sk_6f24fdd730188b284bf profile

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

#database #sql #tutorial
Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.