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.
DuckDB 1.20 Released! Exploring the New Features
nk_maker profile

DuckDB 1.20 Released! Exploring the New Features

#duckdb #sql #csv
Comments
4 min read
#34 50 Advanced SQL Queries Every Developer Should Know
flnzba profile

#34 50 Advanced SQL Queries Every Developer Should Know

#sql #database #dataengineering
2
Comments
7 min read
The Hidden Costs of GCP Data Engineering: Are Idle Resources Draining Your Budget?
rithesh_raj_dd0391f0ba889 profile

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

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

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

#programming #database #sql #esprocspl
6
Comments 1
3 min read
Understanding SQL Injection: What It Is and How to Protect Your Website
terminaltools profile

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

#sql #sqlinjection #cyber #cybersecurity
Comments
7 min read
Exportar Connections do SQL Developer Para a extensão do Vscode
devkaiqueramos_133321f65e profile

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

#oracle #sql #oracelsqldeveloper #vscode
Comments
1 min read
Beginner’s Guide to Designing a Relational Database Schema
roxana_haidiner profile

Beginner’s Guide to Designing a Relational Database Schema

#database #sql #schema #mysql
13
Comments 5
4 min read
Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server
seanmdrew profile

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

#sqlserver #sql
1
Comments 2
2 min read
Stop Forcing Time Windows on Bursty User Behavior - Try This Instead
__354f265b41dafa0d901b profile

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

#news #datascience #database #sql
Comments 1
4 min read
How to Access a PostgreSQL Database Remotely
msnmongare profile

How to Access a PostgreSQL Database Remotely

#postgres #postgressql #sql #database
1
Comments
2 min read
Oracle 21c Enhancements for TTS Export/Import
vahidusefzadeh profile

Oracle 21c Enhancements for TTS Export/Import

#devops #linux #database #sql
Comments
2 min read
IoT monitoring with Kafka and Tinybird
tbperegrine profile

IoT monitoring with Kafka and Tinybird

#analytics #eventdriven #programming #sql
1
Comments
9 min read
The Best Tools to Design Database Schemas Visually in 2025
roxana_haidiner profile

The Best Tools to Design Database Schemas Visually in 2025

#database #sql #mysql #postgres
10
Comments 3
7 min read
MySQL vs MongoDB - Visual Design with Real Data Models
roxana_haidiner profile

MySQL vs MongoDB - Visual Design with Real Data Models

#mysql #mongodb #sql #nosql
11
Comments 2
5 min read
New Tech Talk Proposal 😎 Just Dropped
sarahmatta profile

New Tech Talk Proposal 😎 Just Dropped

#techtalks #womenintech #sql #database
3
Comments 1
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.