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 Anatomy of a Slow Database Query: How to Diagnose, Deconstruct, and Fix It
mindinu profile

The Anatomy of a Slow Database Query: How to Diagnose, Deconstruct, and Fix It

#backend #database #performance #sql
10
Comments 1
5 min read
Nobody Warns You the Data Engineering Interview Isn't About Data Engineering
rahmanfrr profile

Nobody Warns You the Data Engineering Interview Isn't About Data Engineering

#dataengineering #interview #career #sql
Comments 3
2 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
Every text-to-SQL benchmark score you've seen was measured without access control
ashish_sinha_5241c7673d93 profile

Every text-to-SQL benchmark score you've seen was measured without access control

#ai #database #security #sql
1
Comments 15
5 min read
SQL Is Surviving, Franklin: When One Query Isn't Enough
ms_njenga profile

SQL Is Surviving, Franklin: When One Query Isn't Enough

#beginners #database #sql #tutorial
3
Comments
13 min read
ANALYZING HOTEL BOOKING DATA: A TEMBO HOTEL SQL + POWER BI CASE STUDY
super_b8c82b4153dee9fab1c profile

ANALYZING HOTEL BOOKING DATA: A TEMBO HOTEL SQL + POWER BI CASE STUDY

#analytics #data #database #sql
1
Comments
2 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
Spider 2.0 deleted a claim I made this morning
ashish_sinha_5241c7673d93 profile

Spider 2.0 deleted a claim I made this morning

#sql #ai #database #python
Comments 3
5 min read
LeetCode Problem Statements Be Testing My English More Than SQL
saamiabbaskhan profile

LeetCode Problem Statements Be Testing My English More Than SQL

#discuss #leetcode #sql #programming
7
Comments 1
1 min read
Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

Interactive simulators let you break systems first
devopsdaily profile

Database Scaling, Explained by Breaking Things: Indexing, Replication, Caching

#database #systemdesign #sql #caching
15
Comments 5
5 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
MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade
dkelxldk profile

MariaDB 12 Broke Our Concurrent Updates: Debugging ERROR 1020 After an Upgrade

#database #debugging #sql
Comments 2
2 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.