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.
Tips and tricks for SQL Server database (table) design?

Tips and tricks for SQL Server database (table) design?

4
Comments 1
3 min read
Data Engineering 101: Automating Your First Data Extract

Data Engineering 101: Automating Your First Data Extract

101
Comments
7 min read
Making GraphQL Magic with Sqlmancer 🧙🔮✨

Making GraphQL Magic with Sqlmancer 🧙🔮✨

9
Comments
6 min read
Basic DB Using SQL Server (Part 7) - Set Operations in SQL

Basic DB Using SQL Server (Part 7) - Set Operations in SQL

6
Comments
6 min read
Basic DB Using SQL Server (Part 6)

Basic DB Using SQL Server (Part 6)

6
Comments
5 min read
Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!

Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!

8
Comments 3
13 min read
Fuzzy Searching with PostgreSQL

Fuzzy Searching with PostgreSQL

80
Comments 4
6 min read
We used CosmosDB instead of a relational database, here's what we went through and learned.

We used CosmosDB instead of a relational database, here's what we went through and learned.

9
Comments 2
4 min read
Dark theme in SQL Server Management Studio

Dark theme in SQL Server Management Studio

9
Comments
2 min read
Hacker-rank SQL Median calculation

Hacker-rank SQL Median calculation

7
Comments
1 min read
My Back-end Adventures - Setting up a local database (Postgres)

My Back-end Adventures - Setting up a local database (Postgres)

9
Comments
4 min read
SQL for dummies

SQL for dummies

10
Comments
5 min read
My Back-end Adventures - Intro

My Back-end Adventures - Intro

37
Comments 5
2 min read
Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)

Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)

9
Comments 2
4 min read
SQL injection for developers

SQL injection for developers

128
Comments 5
12 min read
What is the best way store column metadata in SQLite (like, is JSON or is Date)

What is the best way store column metadata in SQLite (like, is JSON or is Date)

7
Comments 6
1 min read
Jupyter Notebooks + IBMi

Jupyter Notebooks + IBMi

14
Comments 2
4 min read
Live Annotated Coding Interviews: SQL, Python and Javascript 1:36:36

Live Annotated Coding Interviews: SQL, Python and Javascript

37
Comments 2
3 min read
Understand SQL JOIN with this simple tutorial and don't fail as I did

Understand SQL JOIN with this simple tutorial and don't fail as I did

58
Comments
5 min read
Azure SQL and Site Reliability

Azure SQL and Site Reliability

13
Comments
8 min read
What SQLite CAN actually do

What SQLite CAN actually do

33
Comments 1
3 min read
Avoid This Mistake When Restoring a TDE Protected Database to a New Server

Avoid This Mistake When Restoring a TDE Protected Database to a New Server

5
Comments
3 min read
Quick and Easy, Exactly-Once, Distributed Work Queues Using Serializable Transactions

Quick and Easy, Exactly-Once, Distributed Work Queues Using Serializable Transactions

20
Comments 4
5 min read
Getting query performance stats with PostgreSQL

Getting query performance stats with PostgreSQL

22
Comments 1
6 min read
Exploring Column Families in CockroachDB

Exploring Column Families in CockroachDB

8
Comments
2 min read
A Primer on Relational Databases for Beginners by a Beginner

A Primer on Relational Databases for Beginners by a Beginner

6
Comments
8 min read
Hierarchical Queries in SQL with C# and Entity Framework Core

Hierarchical Queries in SQL with C# and Entity Framework Core

8
Comments
1 min read
A workout routine with Oracle DEV GYM

A workout routine with Oracle DEV GYM

3
Comments 3
1 min read
SQL DB Backups to Azure Storage with Powershell

SQL DB Backups to Azure Storage with Powershell

6
Comments
2 min read
How to do upserts in Knex.js (PostgreSQL)

How to do upserts in Knex.js (PostgreSQL)

34
Comments 4
3 min read
MySQLDump.js

MySQLDump.js

4
Comments
1 min read
Sending a Text Message with SQL (IBMi)

Sending a Text Message with SQL (IBMi)

10
Comments
4 min read
Use Dash to Build BigQuery-Connected Python Web Apps

Use Dash to Build BigQuery-Connected Python Web Apps

6
Comments
3 min read
Remove Duplicate Records via SQL Server's Rank Function

Remove Duplicate Records via SQL Server's Rank Function

8
Comments 2
3 min read
Tweaking Logger Outputs on the Fly

Tweaking Logger Outputs on the Fly

1
Comments
2 min read
Translate rails query to raw sql in rails console

Translate rails query to raw sql in rails console

8
Comments
1 min read
CSV to SQL import using Node, Express and React

CSV to SQL import using Node, Express and React

3
Comments 4
3 min read
E5 - Save Order in Database

E5 - Save Order in Database

3
Comments
3 min read
Should I install SSMS on a server running SQL Server?

Should I install SSMS on a server running SQL Server?

6
Comments 3
5 min read
Migrondi, Simple SQL migrations tool

Migrondi, Simple SQL migrations tool

9
Comments
5 min read
Getting Started with MariaDB using Docker and Node.js

Getting Started with MariaDB using Docker and Node.js

22
Comments 2
4 min read
How Often Do You Dream In Code?

How Often Do You Dream In Code?

4
Comments 8
1 min read
Learn Web Development for Free

Learn Web Development for Free

118
Comments 6
8 min read
Dapper.NET: Custom Columns Mapping

Dapper.NET: Custom Columns Mapping

7
Comments
4 min read
What's an ACID compliant database?

What's an ACID compliant database?

10
Comments
6 min read
Pocket Guide on Sequelize ORM for NodeJS

Pocket Guide on Sequelize ORM for NodeJS

17
Comments
12 min read
60 lines of code Web crawler and search bar with Wget and Manticore

60 lines of code Web crawler and search bar with Wget and Manticore

10
Comments
7 min read
Working with SQL Relations in Go - Part 2

Working with SQL Relations in Go - Part 2

5
Comments
7 min read
A story on indexing and why it is important for modern applications

A story on indexing and why it is important for modern applications

26
Comments 2
4 min read
Merging development and production MS SQL databases for cloud migration

Merging development and production MS SQL databases for cloud migration

6
Comments
12 min read
Visualizing differences in T-SQL code between multiple databases

Visualizing differences in T-SQL code between multiple databases

5
Comments
7 min read
mySQL vs MongoDB - What's the Difference?

mySQL vs MongoDB - What's the Difference?

13
Comments 2
4 min read
Analyzing the politics of COVID-19 through public data

Analyzing the politics of COVID-19 through public data

54
Comments 4
17 min read
SQL: Beyond The Basics

SQL: Beyond The Basics

6
Comments
4 min read
Dolt is Git For Data

Dolt is Git For Data

34
Comments 3
1 min read
Making Datasets Fly with Datasette and Fly

Making Datasets Fly with Datasette and Fly

7
Comments
7 min read
Dapper .NET: Multiple Mapping

Dapper .NET: Multiple Mapping

8
Comments
6 min read
Beginning of a Blog Series

Beginning of a Blog Series

13
Comments
3 min read
Isolation levels and locking in relational databases

Isolation levels and locking in relational databases

21
Comments 1
10 min read
CS Trivia#7: Why is SQL shouting at me?

CS Trivia#7: Why is SQL shouting at me?

24
Comments 8
3 min read
loading...