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.
How Database Indexes Work (And Why Yours Might Be Useless)
arnavsharma2711 profile

How Database Indexes Work (And Why Yours Might Be Useless)

#database #programming #sql
Comments
6 min read
The SQL Worked Perfectly. The Data Was Wrong.
eduardo-ortega profile

The SQL Worked Perfectly. The Data Was Wrong.

#sql #database #debugging #programming
Comments 2
5 min read
Why 'WHERE x = NULL' Never Works in SQL (And What to Use Instead)
systemcraftdev profile

Why 'WHERE x = NULL' Never Works in SQL (And What to Use Instead)

#sql #database #tutorial #beginners
Comments 2
3 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 5: Where AI Actually Helped
kostyabartashevich profile

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 5: Where AI Actually Helped

#ai #database #azure #sql
Comments
6 min read
Two domains are 53% of the Databricks Data Engineer Associate exam
nicheelab profile

Two domains are 53% of the Databricks Data Engineer Associate exam

#databricks #dataengineering #certification #sql
Comments
4 min read
Shadow-Gate Your LLM-Generated SQL: A Replay Test Against a Frozen Fixture Database
dataio_4921 profile

Shadow-Gate Your LLM-Generated SQL: A Replay Test Against a Frozen Fixture Database

#sql #testing #ai #tutorial
Comments
6 min read
The Gap Between College SQL and Industry Reality When I was in college, I thought I knew databases.
rahmanfrr profile
Rahman

The Gap Between College SQL and Industry Reality When I was in college, I thought I knew databases.

#career #database #interview #sql
Comments
3 min read
A New Model Dropped. Is It Actually Good at Your SQL? A 30-Minute Smoke Test
dataio_4921 profile

A New Model Dropped. Is It Actually Good at Your SQL? A 30-Minute Smoke Test

#ai #sql #testing #opensource
Comments
4 min read
The text-to-SQL demo takes an afternoon. The other 90% is why you should buy it.
omer_hochman profile

The text-to-SQL demo takes an afternoon. The other 90% is why you should buy it.

#sql #database #ai #webdev
Comments 1
3 min read
Running the same SQL checks in a browser, CLI and pull request
milekv profile

Running the same SQL checks in a browser, CLI and pull request

#sql #github #typescript #opensource
1
Comments
3 min read
Your companies table is lying to you about when things happened
corpdigest profile

Your companies table is lying to you about when things happened

#database #sql #datascience
Comments
2 min read
SEQUENCE vs IDENTITY in SQL Server: Choosing the Right Auto-Increment
tygryso profile

SEQUENCE vs IDENTITY in SQL Server: Choosing the Right Auto-Increment

#sqlserver #database #sql #olap
1
Comments
6 min read
# 🔬 PostgreSQL Internals: What Is Actually Inside an 8 KB Page?
ahmedraza_fyntune profile

# 🔬 PostgreSQL Internals: What Is Actually Inside an 8 KB Page?

#database #webdev #postgres #sql
Comments
5 min read
From Raw Tables to Business Insights: A SQL Workflow Every SaaS Team Can Use
vivekdraxlr profile

From Raw Tables to Business Insights: A SQL Workflow Every SaaS Team Can Use

#sql #database #analytics #tutorial
Comments
5 min read
How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query
michaelnocito profile

How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query

#sql #database #tutorial #beginners
Comments
9 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.