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.
The 500-foot Cab Ride: Using BigQuery to find out how dirty (sinister?) NYC's cab ride data is

The 500-foot Cab Ride: Using BigQuery to find out how dirty (sinister?) NYC's cab ride data is

9
Comments 1
3 min read
Working with SQL Relations in Go - Part 4

Working with SQL Relations in Go - Part 4

3
Comments
7 min read
SQL Vs NoSQL, Lequel Peut Gérer Facilement Une Base De Données Web Médicale?

SQL Vs NoSQL, Lequel Peut Gérer Facilement Une Base De Données Web Médicale?

4
Comments
12 min read
Tutorial: How to Connect a SQL Database to Google Sheets

Tutorial: How to Connect a SQL Database to Google Sheets

4
Comments
2 min read
Subqueries and Correlated Subqueries

Subqueries and Correlated Subqueries

3
Comments
2 min read
AyeSQL: Writing Raw SQL

AyeSQL: Writing Raw SQL

12
Comments 2
9 min read
Connect to SQLite DB in windows

Connect to SQLite DB in windows

4
Comments
1 min read
MySQLでサブクエリを使ってUPDATE

MySQLでサブクエリを使ってUPDATE

7
Comments
1 min read
When STRING_SPLIT() falls short

When STRING_SPLIT() falls short

5
Comments
3 min read
Building an end to end Machine Learning Pipeline in Bigquery

Building an end to end Machine Learning Pipeline in Bigquery

7
Comments
5 min read
Joining the Friends of Redgate program 🎉

Joining the Friends of Redgate program 🎉

4
Comments
1 min read
Introduction to MySQL queries

Introduction to MySQL queries

7
Comments 1
3 min read
Modern data practice and the SQL tradition

Modern data practice and the SQL tradition

17
Comments
2 min read
ROW_NUMBER, PARTITION, & other reasons SQL is beautiful

ROW_NUMBER, PARTITION, & other reasons SQL is beautiful

14
Comments
2 min read
Analyze one year of radio station songs aired with SQL, Spark, Spotify, and Databricks

Analyze one year of radio station songs aired with SQL, Spark, Spotify, and Databricks

6
Comments
16 min read
Manipulando Datas no Postgres

Manipulando Datas no Postgres

5
Comments
2 min read
Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

Devart Introduced The New Version of Its Flagman Solution — dbForge SQL Complete v.6.4

4
Comments
2 min read
SQL: Select Statements

SQL: Select Statements

7
Comments
3 min read
A (not so) small rant on techniques to copy MySQL database structures

A (not so) small rant on techniques to copy MySQL database structures

6
Comments
4 min read
Visually Creating MySQL Queries With dbForge Studio for MySQL

Visually Creating MySQL Queries With dbForge Studio for MySQL

6
Comments
4 min read
SQL: Table Creation and Basic Queries

SQL: Table Creation and Basic Queries

6
Comments
3 min read
A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

A 'Nike Foamposites' mobile app I developed was finally accepted by Apple

4
Comments
2 min read
Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

Psycopg2: PostgreSQL & Python (the Old Fashioned Way)

16
Comments
6 min read
Temporal tables or JSON storage

Temporal tables or JSON storage

6
Comments
3 min read
Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

Rewrite this SQL for NoSQL, graph-db (e.g. Neo4j)

7
Comments
1 min read
Why you must add relational database development to your toolkit

Why you must add relational database development to your toolkit

5
Comments
5 min read
Answer: Does the join order matter in SQL?

Answer: Does the join order matter in SQL?

2
Comments
1 min read
Automate SQL Queries in the cloud

Automate SQL Queries in the cloud

6
Comments
1 min read
Basic DB Using SQL Server (Part 1) - Basic commands!

Basic DB Using SQL Server (Part 1) - Basic commands!

9
Comments
3 min read
Makers - Week 4

Makers - Week 4

4
Comments
1 min read
i doing SQL tuning in Company databases but i don't know where to start

i doing SQL tuning in Company databases but i don't know where to start

3
Comments 3
1 min read
Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

Joining Data in DynamoDB and S3 for Live Ad Hoc Analysis

5
Comments
8 min read
Answer: SQL Server - How to lock a table until a stored procedure finishes

Answer: SQL Server - How to lock a table until a stored procedure finishes

6
Comments
1 min read
Importing geo-partitioned data… the easy way

Importing geo-partitioned data… the easy way

3
Comments 1
1 min read
Avoiding Hard Coding and Magic Strings in code and databases

Avoiding Hard Coding and Magic Strings in code and databases

38
Comments 1
3 min read
Popular SQL interview question met in practice

Popular SQL interview question met in practice

10
Comments
3 min read
λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

8
Comments
3 min read
Working with JSON in an RDBMS – Part 2, PostgreSQL

Working with JSON in an RDBMS – Part 2, PostgreSQL

7
Comments
9 min read
How to deploy project local to production server using gulp?

How to deploy project local to production server using gulp?

6
Comments 1
1 min read
What is an execution plan?

What is an execution plan?

5
Comments
1 min read
MySQL reserved words checker for Laravel migrations on PhpStorm

MySQL reserved words checker for Laravel migrations on PhpStorm

4
Comments
1 min read
Loose Typings in GraphQL for Dynamic Grouping and Aggregation Queries

Loose Typings in GraphQL for Dynamic Grouping and Aggregation Queries

10
Comments
6 min read
Query optimization: from a few weeks to 24 hours

Query optimization: from a few weeks to 24 hours

16
Comments
4 min read
Use Sequelize to Manipulate Databases

Use Sequelize to Manipulate Databases

12
Comments
3 min read
What the heck is Accelerated Database Recovery?

What the heck is Accelerated Database Recovery?

5
Comments
3 min read
Using PowerShell to tidy up CSV files

Using PowerShell to tidy up CSV files

7
Comments
3 min read
Testing as another user…without their password

Testing as another user…without their password

7
Comments
5 min read
How to create date buckets in T-SQL

How to create date buckets in T-SQL

7
Comments
5 min read
What the heck is the dbcreator role?

What the heck is the dbcreator role?

6
Comments
3 min read
When to put a non-clustered index on your clustering key

When to put a non-clustered index on your clustering key

6
Comments
2 min read
Data Blogger Resource Kit

Data Blogger Resource Kit

7
Comments
3 min read
Failure is always an option

Failure is always an option

9
Comments
5 min read
How does a database RESTORE affect plan cache?

How does a database RESTORE affect plan cache?

6
Comments
7 min read
I hate sp_estimate_data_compression_savings

I hate sp_estimate_data_compression_savings

5
Comments
6 min read
Configuring the distribution database in an Availability Group

Configuring the distribution database in an Availability Group

5
Comments
3 min read
Why does ALTER let me DROP?

Why does ALTER let me DROP?

6
Comments
4 min read
What the heck is downtime, anyway?

What the heck is downtime, anyway?

5
Comments
3 min read
The thrill of purging old data

The thrill of purging old data

5
Comments
4 min read
Recovery of database is 0% complete (approximately 1000000 seconds remain)

Recovery of database is 0% complete (approximately 1000000 seconds remain)

6
Comments
4 min read
Introduction to Relational Database and SQL

Introduction to Relational Database and SQL

7
Comments
1 min read
loading...