Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

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

Mar 13

Connecting power bi to SQL databases locally and through cloud service.

#sql #database #productivity #beginners

5 min read

catatsuy

Mar 15

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

#mysql #postgres #database #sql

13 min read

Feb 17

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

#database #performance #sql #sre

6 min read

Mar 2

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

#postgres #database #sql #backend

5 min read

Santhoshi Mary A

Mar 22

Number Guessing Game

#database #python #sql #tutorial

2 min read

Abdelrahman Adnan

Feb 16

Part 2: dbt Project Structure & Building Models 📁

#data #dataengineering #sql #tutorial

4 min read

Abdelrahman Adnan

Feb 16

# Module 4 Summary - Analytics Engineering with dbt

#analytics #dataengineering #sql #tutorial

2 min read

Abdelrahman Adnan

Feb 16

Part 3: Testing, Documentation & Deployment 🚀

#analytics #dataengineering #sql #tutorial

5 min read

Philip McClarence

Mar 2

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

#database #mongodb #postgres #sql

12 min read

Feb 16

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

#backend #database #sql #typescript

4 min read

Mar 2

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

#sql #dataanalytics #database #programming

5 min read

Mar 8

Understanding `GROUP BY` in SQL

#sql

6 min read

Mar 17

Partitioning PotgreSQL Database

#sql #postgres #architecture #performance

4 min read

Mar 1

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

#database #sql

13 min read

Teymur Bayramov

Feb 19

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

#csharp #sql #database #dotnet

7 min read

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