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.
How to install Maven (Apache Maven) on Windows 11?

How to install Maven (Apache Maven) on Windows 11?

1
Comments
2 min read
How to Handle Millions of Rows in SQL Without Killing Performance

How to Handle Millions of Rows in SQL Without Killing Performance

24
Comments 1
2 min read
Postgres vs. MySQL: DDL Transaction Difference

Postgres vs. MySQL: DDL Transaction Difference

5
Comments 1
4 min read
Open-source Node.js blogging engine with newsletter functionality

Open-source Node.js blogging engine with newsletter functionality

1
Comments
1 min read
DuckDB 1.20 Released! Exploring the New Features

DuckDB 1.20 Released! Exploring the New Features

Comments
4 min read
#34 50 Advanced SQL Queries Every Developer Should Know

#34 50 Advanced SQL Queries Every Developer Should Know

2
Comments
7 min read
Oracle 23ai: Direct Joins for UPDATE and DELETE Statements

Oracle 23ai: Direct Joins for UPDATE and DELETE Statements

Comments
1 min read
The Hidden Costs of GCP Data Engineering: Are Idle Resources Draining Your Budget?

The Hidden Costs of GCP Data Engineering: Are Idle Resources Draining Your Budget?

Comments
2 min read
Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

Fetch Values from Previous Non-Null Value Rows — From SQL to SPL #24

6
Comments 1
3 min read
Understanding SQL Injection: What It Is and How to Protect Your Website

Understanding SQL Injection: What It Is and How to Protect Your Website

Comments
7 min read
How to check the same status of data in each row within a group with esProc

How to check the same status of data in each row within a group with esProc

6
Comments
2 min read
Exportar Connections do SQL Developer Para a extensão do Vscode

Exportar Connections do SQL Developer Para a extensão do Vscode

Comments
1 min read
Thankful welcome from [email protected]

Thankful welcome from [email protected]

Comments
1 min read
Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server

Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server

1
Comments 2
2 min read
SQL Tutorial Made Easy: From Basics to Advanced Queries

SQL Tutorial Made Easy: From Basics to Advanced Queries

Comments
3 min read
Stop Forcing Time Windows on Bursty User Behavior - Try This Instead

Stop Forcing Time Windows on Bursty User Behavior - Try This Instead

Comments 1
4 min read
How to Access a PostgreSQL Database Remotely

How to Access a PostgreSQL Database Remotely

1
Comments
2 min read
Oracle 21c Enhancements for TTS Export/Import

Oracle 21c Enhancements for TTS Export/Import

Comments
2 min read
IoT monitoring with Kafka and Tinybird

IoT monitoring with Kafka and Tinybird

1
Comments
9 min read
The Best Tools to Design Database Schemas Visually in 2025

The Best Tools to Design Database Schemas Visually in 2025

10
Comments 3
7 min read
Getting the Available Ranges from Two Tables — From SQL to SPL #34

Getting the Available Ranges from Two Tables — From SQL to SPL #34

9
Comments 3
3 min read
Can ADO.NET Be Used in Modern Web Applications?

Can ADO.NET Be Used in Modern Web Applications?

Comments
3 min read
New Tech Talk Proposal 😎 Just Dropped

New Tech Talk Proposal 😎 Just Dropped

2
Comments 1
2 min read
How Snowflake Copilot Inline Transformed My SQL Analysis Experience

How Snowflake Copilot Inline Transformed My SQL Analysis Experience

6
Comments 2
5 min read
EF Query vs SQL View in Entity Framework – Which One Would You Choose?

EF Query vs SQL View in Entity Framework – Which One Would You Choose?

Comments 1
3 min read
loading...