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.
Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table
Cover image for Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table

Learn SQL: Microsoft SQL Server - Episode 13: Insert new records in a Table

6
Comments
3 min read
Airbyte: Data Integration / CDC Solution for Modern Data Teams!

Airbyte: Data Integration / CDC Solution for Modern Data Teams!

6
Comments
12 min read
🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

🐘🚀 Triggers & Stored Procedures for pure data integrity logic and performance

5
Comments 2
15 min read
Data structures in SQL: the definitive guide
Cover image for Data structures in SQL: the definitive guide

Data structures in SQL: the definitive guide

16
Comments
7 min read
How to read / make sense this multiple JOINS SQL query properly?

How to read / make sense this multiple JOINS SQL query properly?

3
Comments 1
1 min read
How to write SQL recursive CTE in 5 steps
Cover image for How to write SQL recursive CTE in 5 steps

How to write SQL recursive CTE in 5 steps

55
Comments 9
7 min read
Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String
Cover image for Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

Learn SQL: Microsoft SQL Server - Episode 12: Finding the length of a String

7
Comments
3 min read
Creating Tables and Associations using Ruby/Active Record/Rake

Creating Tables and Associations using Ruby/Active Record/Rake

6
Comments
5 min read
Fun times with MySQL upgrade

Fun times with MySQL upgrade

4
Comments
5 min read
Getting started with Redshift
Cover image for Getting started with Redshift

Getting started with Redshift

10
Comments
5 min read
My week three experience as an intern at TaskForce4.0
Cover image for My week three experience as an intern at TaskForce4.0

My week three experience as an intern at TaskForce4.0

4
Comments
2 min read
Seven URL Shortener
Cover image for Seven URL Shortener

Seven URL Shortener

6
Comments 1
10 min read
What Is Trino And Why Is It Great At Processing Big Data
Cover image for What Is Trino And Why Is It Great At Processing Big Data

What Is Trino And Why Is It Great At Processing Big Data

27
Comments
7 min read
Extracting example SQL statements from a log

Extracting example SQL statements from a log

3
Comments
3 min read
SQL Server Interview Questions

SQL Server Interview Questions

12
Comments 4
2 min read
Quick 📸 on 🐘 active SQL from pg_stat_statements

Quick 📸 on 🐘 active SQL from pg_stat_statements

8
Comments
3 min read
7 modern and practical MySQL/MariaDB features you should know and use

7 modern and practical MySQL/MariaDB features you should know and use

4
Comments
5 min read
⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

⏱ Read from the nearest peer in a multi-region database 🚀 with followers read

6
Comments
12 min read
How to count newest entries created in an oracle database
Cover image for How to count newest entries created in an oracle database

How to count newest entries created in an oracle database

6
Comments 2
1 min read
What is the N prefix in MSSQL all about?
Cover image for What is the N prefix in MSSQL all about?

What is the N prefix in MSSQL all about?

5
Comments
3 min read
Making Dapper and JSON friends

Making Dapper and JSON friends

32
Comments 3
6 min read
"Rows Removed by Index Recheck" on YugabyteDB Index Scan

"Rows Removed by Index Recheck" on YugabyteDB Index Scan

5
Comments
8 min read
De-identify SQL: Transforming Production Data
Cover image for De-identify SQL: Transforming Production Data

De-identify SQL: Transforming Production Data

7
Comments
3 min read
SQL Joins - Inner Join vs Outer Join

SQL Joins - Inner Join vs Outer Join

5
Comments 1
1 min read
What are database indexes?
Cover image for What are database indexes?

What are database indexes?

56
Comments
5 min read
loading...