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.
Building a User Registration System in .NET Core & C#

Building a User Registration System in .NET Core & C#

4
Comments
2 min read
Multi Tenant Architecture in Software: What Is It and Its Databases Patterns

Multi Tenant Architecture in Software: What Is It and Its Databases Patterns

16
Comments 5
4 min read
Rails Self-Join Tables - Parent-Child Magic

Rails Self-Join Tables - Parent-Child Magic

Comments
3 min read
MariaDB to PostgreSQL: Lessons & Challenges

MariaDB to PostgreSQL: Lessons & Challenges

3
Comments
6 min read
Database Design Principles - Normalization and Denormalization

Database Design Principles - Normalization and Denormalization

Comments
3 min read
OLTP Explained: Speed, Integrity, and High Availability in Databases

OLTP Explained: Speed, Integrity, and High Availability in Databases

3
Comments 3
2 min read
Como Alterar o Nome do Seu SQL Server

Como Alterar o Nome do Seu SQL Server

Comments
1 min read
SQL Injection - In Just 5 Minutes!

SQL Injection - In Just 5 Minutes!

Comments
3 min read
Find logged Microsoft SQL Server Messages

Find logged Microsoft SQL Server Messages

Comments
1 min read
PostgreSql Tasks - Case study:2

PostgreSql Tasks - Case study:2

1
Comments
2 min read
How to Import/Export CSV file in pgAdmin

How to Import/Export CSV file in pgAdmin

Comments
3 min read
SQL Coding

SQL Coding

Comments 1
3 min read
Why Developers Are Ditching SQL Pain Points with Open-Source SPL

Why Developers Are Ditching SQL Pain Points with Open-Source SPL

6
Comments
7 min read
Mastering `SelectMany` in EF Core: SQL Equivalents and Best Practices

Mastering `SelectMany` in EF Core: SQL Equivalents and Best Practices

4
Comments
3 min read
SQL 101 | Chapter 8: Using Subqueries for Improved Modularity and Dynamic Calculations

SQL 101 | Chapter 8: Using Subqueries for Improved Modularity and Dynamic Calculations

3
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.