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.
Part 2: dbt Project Structure & Building Models 📁
abdelrahman_adnan profile

Part 2: dbt Project Structure & Building Models 📁

#data #dataengineering #sql #tutorial
Comments
4 min read
Part 3: Testing, Documentation & Deployment 🚀
abdelrahman_adnan profile

Part 3: Testing, Documentation & Deployment 🚀

#analytics #dataengineering #sql #tutorial
Comments
5 min read
PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL
philip_mcclarence_2ef9475 profile

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

#database #mongodb #postgres #sql
1
Comments
12 min read
Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination
sangwoo_rhie profile

Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

#backend #database #sql #typescript
Comments
4 min read
Beyond the Basics: 5 Game-Changing Secrets of SQL Joins and Window Functions
jason_ndalamia profile

Beyond the Basics: 5 Game-Changing Secrets of SQL Joins and Window Functions

#sql #dataanalytics #database #programming
2
Comments
5 min read
Understanding `GROUP BY` in SQL
andrewlegacci profile

Understanding `GROUP BY` in SQL

#sql
16
Comments
6 min read
Normalização de Banco de Dados: Das Origens às 5 Formas Normais (+ BCNF) com Exemplos Pråticos
felipecezar01 profile

Normalização de Banco de Dados: Das Origens às 5 Formas Normais (+ BCNF) com Exemplos Pråticos

#database #sql
2
Comments
13 min read
Snowflake Data UI Guide - Choose the Right Tool for Every Analytics Use Case
tsubasa_tech profile

Snowflake Data UI Guide - Choose the Right Tool for Every Analytics Use Case

#snowflake #ai #sql #python
1
Comments
16 min read
How to implement “CreatedAt” and “UpdatedAt” timestamps in Entity Framework Core?
tbayramov profile

How to implement “CreatedAt” and “UpdatedAt” timestamps in Entity Framework Core?

#csharp #sql #database #dotnet
4
Comments
7 min read
Why I don't trust AI with my query plans
ash_mse profile

Why I don't trust AI with my query plans

#postgres #database #performance #sql
Comments
2 min read
Jsonb e Gin Index: Otimizando consultas no PostgreSQL
ewertoncodes profile

Jsonb e Gin Index: Otimizando consultas no PostgreSQL

#sql #backend #performance #webdev
1
Comments
3 min read
From RAG to Agents: How TiDB Powers Modern AI Applications
codewithveek profile

From RAG to Agents: How TiDB Powers Modern AI Applications

#ai #agents #vectordatabase #sql
1
Comments
11 min read
SQLx: Your Go-To Database Toolkit for Go Developers
jones_charles_ad50858dbc0 profile

SQLx: Your Go-To Database Toolkit for Go Developers

#go #database #backend #sql
2
Comments
8 min read
Syncing Azure SQL Databases Across Subscriptions Using OpenShift CronJob (Without ADF)
devops_oracle profile

Syncing Azure SQL Databases Across Subscriptions Using OpenShift CronJob (Without ADF)

#cronjobs #openshift #kubernetes #sql
Comments
3 min read
Inline Stopwords, Exceptions, and Wordforms
sanikolaev profile

Inline Stopwords, Exceptions, and Wordforms

#backend #data #database #sql
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.