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.
SQLAlchemy Table Relationships

SQLAlchemy Table Relationships

22
Comments
4 min read
SQL: comandos básicos

SQL: comandos básicos

6
Comments
4 min read
On why wasting 0.000005 seconds is still bad idea

On why wasting 0.000005 seconds is still bad idea

27
Comments 1
5 min read
Get started with MySQL | Mini-Guide

Get started with MySQL | Mini-Guide

10
Comments
14 min read
Designing Schemas for Relational Databases

Designing Schemas for Relational Databases

11
Comments
4 min read
Comparing aggregated data to unaggregated data in SQL

Comparing aggregated data to unaggregated data in SQL

3
Comments
5 min read
Watch OVER your WINDOW of opportunities

Watch OVER your WINDOW of opportunities

8
Comments
3 min read
SQL Dump in Docker

SQL Dump in Docker

6
Comments
1 min read
Serverless REST API with Azure Functions, Node, JSON and Azure SQL

Serverless REST API with Azure Functions, Node, JSON and Azure SQL

64
Comments
6 min read
MySQL Command Notes

MySQL Command Notes

4
Comments
1 min read
A new way of tokenization of Chinese or How to make Chinese full-text search

A new way of tokenization of Chinese or How to make Chinese full-text search

23
Comments 3
5 min read
Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

6
Comments 1
5 min read
What is a Database Query? SQL and NoSQL queries explained

What is a Database Query? SQL and NoSQL queries explained

17
Comments
7 min read
Guide to Cyber Security: learn how to defend your systems

Guide to Cyber Security: learn how to defend your systems

17
Comments
10 min read
How to find SQL Server database Restore and Recovery time ?

How to find SQL Server database Restore and Recovery time ?

6
Comments
1 min read
Database Version Control With Liquibase

Database Version Control With Liquibase

6
Comments
4 min read
SQL Server Service Broker for Asynchronous Applications

SQL Server Service Broker for Asynchronous Applications

8
Comments
7 min read
Synchronize Databases with Only Five Lines of Code

Synchronize Databases with Only Five Lines of Code

56
Comments 3
2 min read
Replicating Azure SQL DB Instances on the fly for SaaS apps

Replicating Azure SQL DB Instances on the fly for SaaS apps

1
Comments
2 min read
The Easy Way to Find Customers Likely to Churn

The Easy Way to Find Customers Likely to Churn

23
Comments
4 min read
Important TIPs for SQL Database Design

Important TIPs for SQL Database Design

7
Comments 2
7 min read
Practical Azure SQL Database for Modern Developers

Practical Azure SQL Database for Modern Developers

14
Comments
4 min read
How to Measure Cohort Retention using BigQuery

How to Measure Cohort Retention using BigQuery

9
Comments
5 min read
Postgres concat_ws() function

Postgres concat_ws() function

1
Comments
1 min read
[PT-BR] Join SQL, quando usar?

[PT-BR] Join SQL, quando usar?

51
Comments 12
2 min read
SQL Tips & Tricks: Counting Rows

SQL Tips & Tricks: Counting Rows

5
Comments
5 min read
Machete MySQL(Cheatsheet) level 1

Machete MySQL(Cheatsheet) level 1

6
Comments
3 min read
Reading a datetime with miliseconds into an Oracle DATE

Reading a datetime with miliseconds into an Oracle DATE

6
Comments
2 min read
MySQL Commands You Need To Know To Create A New User

MySQL Commands You Need To Know To Create A New User

10
Comments 1
2 min read
SQL Practice Problem to Help You Pass Your Interview

SQL Practice Problem to Help You Pass Your Interview

18
Comments 5
3 min read
Switching the offset for a UTC date in SQL Server

Switching the offset for a UTC date in SQL Server

2
Comments
2 min read
Reports performance improvement

Reports performance improvement

7
Comments
1 min read
First impressions of PopSQL’s collaborative SQL editor

First impressions of PopSQL’s collaborative SQL editor

42
Comments 1
4 min read
Getting to know SQL Server Extended Events

Getting to know SQL Server Extended Events

26
Comments
7 min read
Code-First ORM For Go: GORM

Code-First ORM For Go: GORM

9
Comments
3 min read
Distributed SQL Tips and Tricks – Aug 17, 2020

Distributed SQL Tips and Tricks – Aug 17, 2020

2
Comments
4 min read
SQL Cheatsheet - Most Common Commands

SQL Cheatsheet - Most Common Commands

18
Comments 1
13 min read
How to ace coding interviews. The ultimate guide.

How to ace coding interviews. The ultimate guide.

80
Comments
14 min read
Don't ever use LIMIT again!!!

Don't ever use LIMIT again!!!

6
Comments 1
5 min read
Convince me to use SQL

Convince me to use SQL

29
Comments 17
1 min read
Alembic: setting a column to nullable=False if it already has data in it

Alembic: setting a column to nullable=False if it already has data in it

6
Comments 1
2 min read
Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

48
Comments 1
7 min read
Azure SQL for Beginners - Video Playlist

Azure SQL for Beginners - Video Playlist

28
Comments
1 min read
SQL Server Profiler, underused and undervalued

SQL Server Profiler, underused and undervalued

8
Comments
5 min read
Why SQLite is simple to use!

Why SQLite is simple to use!

6
Comments 2
2 min read
DataGrip: Exporting Data as SQL Batch Inserts (and more)

DataGrip: Exporting Data as SQL Batch Inserts (and more)

3
Comments
2 min read
Version Control for Distributed SQL Databases with Flyway

Version Control for Distributed SQL Databases with Flyway

3
Comments
6 min read
Should I Take the Data Engineer Nano Degree?

Should I Take the Data Engineer Nano Degree?

4
Comments 2
3 min read
Django Same data objects get created every time!

Django Same data objects get created every time!

3
Comments 1
2 min read
4 SQL Tips For Data Scientists And Data Analysts

4 SQL Tips For Data Scientists And Data Analysts

91
Comments 4
7 min read
Banco de dados relacional - Introdução

Banco de dados relacional - Introdução

8
Comments
3 min read
Hidden Gems: Event-Driven Change Notifications in Relational Databases

Hidden Gems: Event-Driven Change Notifications in Relational Databases

6
Comments
10 min read
A Case Study of Date and Time

A Case Study of Date and Time

3
Comments 1
6 min read
High Performance Database Access with EF Core

High Performance Database Access with EF Core

22
Comments 1
1 min read
WSFC + SQL AlwaysOn no AZURE sem Active Directory [#3]

WSFC + SQL AlwaysOn no AZURE sem Active Directory [#3]

3
Comments
9 min read
WSFC + SQL AlwaysOn no AZURE sem Active Directory [#1]

WSFC + SQL AlwaysOn no AZURE sem Active Directory [#1]

4
Comments
6 min read
Sqlmancer - translate GraphQL queries into SQL statements

Sqlmancer - translate GraphQL queries into SQL statements

20
Comments
3 min read
Keep your Code and Database in Sync

Keep your Code and Database in Sync

32
Comments 1
1 min read
PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II

5
Comments 1
13 min read
Database design

Database design

63
Comments 3
4 min read
loading...