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.
Postgres and Iceberg: pg_lake, pg_duckdb and the Postgres lakehouse
mohammed_arshadansari_f2 profile

Postgres and Iceberg: pg_lake, pg_duckdb and the Postgres lakehouse

#dataengineering #database #sql #opensource
Comments
3 min read
From Check-In to Check-Out in a .NET Visitor System
umerfarooqofficial profile

From Check-In to Check-Out in a .NET Visitor System

#csharp #dotnet #sql #architecture
Comments
6 min read
SQL Server Parameter Sniffing: What It Is and How to Fix It
lingamsuyambu profile

SQL Server Parameter Sniffing: What It Is and How to Fix It

#sql #sqlserver #database #performance
Comments
4 min read
How to read PostgreSQL EXPLAIN output
kamal_g_671df6421e profile

How to read PostgreSQL EXPLAIN output

#sql #database #devops #postgres
8
Comments
5 min read
Not Every Slow Query Needs a New Index
pranay_raavi profile

Not Every Slow Query Needs a New Index

#postgres #sql #performance #database
Comments
13 min read
SQL Challenge: Why Is Your SQL Query Still Returning NULL?
kailas_warade_d2a15d1ef8a profile

SQL Challenge: Why Is Your SQL Query Still Returning NULL?

#sql #database #tutorial #analytics
Comments
2 min read
I Built SmartBase: A Free SQL-Powered Cloud Backend Platform for Developers
roosevelt_chikwende_72257 profile

I Built SmartBase: A Free SQL-Powered Cloud Backend Platform for Developers

#backend #cloud #database #sql
Comments 1
3 min read
Null rate data quality check in SQL, per column
refaeldakar profile

Null rate data quality check in SQL, per column

#sql #postgres #dataengineering #monitoring
Comments
2 min read
Measure SDR ramp from your CRM with SQL (days to first reply, meeting, target)
noelmartin profile

Measure SDR ramp from your CRM with SQL (days to first reply, meeting, target)

#sql #postgres #analytics #startup
Comments
2 min read
dbt snapshots are not an audit log
aniketsoni profile

dbt snapshots are not an audit log

#sql #analytics #dataengineering #dataquality
1
Comments
4 min read
Stop Stale Tool Calls from Overwriting Newer Changes
smtasker profile

Stop Stale Tool Calls from Overwriting Newer Changes

#mcp #sql #python #testing
Comments
7 min read
Visual Paradigm Alternative: Database Design Software Without the Modeling Suite
tbson87 profile

Visual Paradigm Alternative: Database Design Software Without the Modeling Suite

#database #sql #tooling #programming
Comments
19 min read
Renaming a column in SQL Server, and what it quietly breaks
woodfiresam profile
Sam

Renaming a column in SQL Server, and what it quietly breaks

#sql #sqlserver #database #refactoring
Comments
4 min read
Your price alert may be a store switch in disguise
dataspryva profile

Your price alert may be a store switch in disguise

#datascience #python #analytics #sql
Comments
7 min read
MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying
tbson87 profile

MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying

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