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.
Top Trends in Web Development in 2021

Top Trends in Web Development in 2021

36
Comments 4
3 min read
Promises, Node, Tedious, Azure SQL. Oh My!

Promises, Node, Tedious, Azure SQL. Oh My!

16
Comments
4 min read
How to see a history of queries ran on a SQL server

How to see a history of queries ran on a SQL server

19
Comments 2
2 min read
How to Send a Complex Type List of Objects to SQL Server

How to Send a Complex Type List of Objects to SQL Server

14
Comments 4
5 min read
MySQL

MySQL

4
Comments 4
1 min read
Django ORM Optimization Tips #4 recursive query

Django ORM Optimization Tips #4 recursive query

34
Comments
2 min read
A PostgreSQL-Compatible, Distributed SQL Cheat Sheet: The Basics

A PostgreSQL-Compatible, Distributed SQL Cheat Sheet: The Basics

4
Comments
5 min read
Set up Extended Events in SQL Server

Set up Extended Events in SQL Server

3
Comments 1
5 min read
Introduction to full-text operators and basic search

Introduction to full-text operators and basic search

7
Comments 2
10 min read
Analyzing Data Without Complicated ETLs For Data Scientists

Analyzing Data Without Complicated ETLs For Data Scientists

27
Comments
6 min read
The best way to synchronize (one way) a table in SQL Server

The best way to synchronize (one way) a table in SQL Server

8
Comments
4 min read
Running SQL Migrations Before Booting Docker Compose Services

Running SQL Migrations Before Booting Docker Compose Services

12
Comments
4 min read
Getting Started with IntelliJ IDEA and Distributed SQL

Getting Started with IntelliJ IDEA and Distributed SQL

5
Comments
6 min read
DynamoDB or PostgreSQL???

DynamoDB or PostgreSQL???

4
Comments 1
1 min read
Don't store null bits

Don't store null bits

7
Comments
4 min read
N + What? (Or: a brief introduction to n + 1 queries and how to avoid them)

N + What? (Or: a brief introduction to n + 1 queries and how to avoid them)

10
Comments
5 min read
IT Staff Augmentation Services- Enhance Your Business Growth With the Top Class Tech Talent

IT Staff Augmentation Services- Enhance Your Business Growth With the Top Class Tech Talent

6
Comments 2
4 min read
What is database indexing and how it works

What is database indexing and how it works

6
Comments 1
2 min read
The Complexity of Active Record Transactions

The Complexity of Active Record Transactions

9
Comments 2
7 min read
Normality for a Flexible World

Normality for a Flexible World

2
Comments
2 min read
Common SQL Injections to Watch Out For

Common SQL Injections to Watch Out For

8
Comments
2 min read
Should I use SQL Views With ORM frameworks?

Should I use SQL Views With ORM frameworks?

3
Comments 1
1 min read
Prevent Hibernate from doing N+1 selects with constructor expression

Prevent Hibernate from doing N+1 selects with constructor expression

2
Comments
6 min read
Vaccines for Common SQL Injection Bugs

Vaccines for Common SQL Injection Bugs

4
Comments
2 min read
Django ORM Optimization Tips #3 aggregation

Django ORM Optimization Tips #3 aggregation

10
Comments 1
3 min read
loading...