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.
sqlcmd 'Scripting Variable Not Defined': Why $( Breaks Your Script and How to Fix It

sqlcmd 'Scripting Variable Not Defined': Why $( Breaks Your Script and How to Fix It

Comments
8 min read
Advanced Data Cleaning for Salesforce to SQL Migrations

Advanced Data Cleaning for Salesforce to SQL Migrations

Comments
7 min read
Why SQL NOT IN returns no rows when the column has NULL

Why SQL NOT IN returns no rows when the column has NULL

Comments
4 min read
SQL BASICS

SQL BASICS

Comments 1
2 min read
How to Integrate SQL Databases with Fabric Lakehouses

How to Integrate SQL Databases with Fabric Lakehouses

2
Comments
4 min read
We counted 13,000 SQL answers from 99 learners. The hardest lesson was SELECT.

We counted 13,000 SQL answers from 99 learners. The hardest lesson was SELECT.

Comments
3 min read
Stop Indexing Boolean Columns in PostgreSQL. Do This Instead.

Stop Indexing Boolean Columns in PostgreSQL. Do This Instead.

7
Comments 2
3 min read
How to check your AI's data answers: evals for each stage

How to check your AI's data answers: evals for each stage

Comments
7 min read
SQL Operators Made Simple: Learn with Practical Examples

SQL Operators Made Simple: Learn with Practical Examples

Comments
3 min read
Your database says "saved" before it touches the table. Here's why that's safe.

Your database says "saved" before it touches the table. Here's why that's safe.

1
Comments 1
5 min read
SQL for Beginners

SQL for Beginners

Comments
4 min read
Databricks Runtime Introduces NEAREST BY: Native SQL Vector Search at Scale

Databricks Runtime Introduces NEAREST BY: Native SQL Vector Search at Scale

Comments
4 min read
Supabase 42501 permission denied is a grant problem, not RLS

Supabase 42501 permission denied is a grant problem, not RLS

Comments
4 min read
Querying Parquet on S3 with DuckDB: secrets, speed and the settings that matter

Querying Parquet on S3 with DuckDB: secrets, speed and the settings that matter

Comments
3 min read
Your UUID Column Is 9x Bigger Than It Needs to Be

Your UUID Column Is 9x Bigger Than It Needs to Be

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.