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.
Making SSMS Smarter: Building a Productive T-SQL Workflow with Snippets and Code Analysis
databaseinsights profile

Making SSMS Smarter: Building a Productive T-SQL Workflow with Snippets and Code Analysis

#sql #database #sqlserver #productivity
3
Comments 2
6 min read
SQL Joins Made Simple
alex_murithi profile

SQL Joins Made Simple

#sql #database #datascience
1
Comments 1
3 min read
Why the index I added made my query slower
_66d02d0cc1ece7d1137c5f profile

Why the index I added made my query slower

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