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 I Recovered Deleted SQL Server Rows Without Ever Enabling CDC or Audit
caiderek profile

How I Recovered Deleted SQL Server Rows Without Ever Enabling CDC or Audit

#backend #database #sql #tools
1
Comments
3 min read
SQL Fundamentals: DDL and DML Commands with Practical Examples
melvinkip profile

SQL Fundamentals: DDL and DML Commands with Practical Examples

#database #sql #tutorial
1
Comments 1
7 min read
Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 1)
zgl20053779 profile

Open-source tool: Practical experience in converting large quantities of SQL code syntax : 'PIVOT' function rewrite (Case 1)

#automation #database #opensource #sql
Comments
5 min read
The hardest label in our dataset is the one where nothing happened
inve_money_e95961f8489d28 profile

The hardest label in our dataset is the one where nothing happened

#datascience #dataengineering #analytics #sql
Comments
14 min read
DDL & DML: The Two Halves of SQL
fidel_okumu profile

DDL & DML: The Two Halves of SQL

#beginners #database #sql #tutorial
1
Comments 1
2 min read
Modeling Your Warehouse So AI Can Actually Use It
vaishnavprabhu profile

Modeling Your Warehouse So AI Can Actually Use It

#dataengineering #ai #sql #analytics
1
Comments 1
2 min read
Open-source tool: Simple example of syntax conversion for batch SQL code: 'ORACLE START WITH CONNECT' syntax conversion
zgl20053779 profile

Open-source tool: Simple example of syntax conversion for batch SQL code: 'ORACLE START WITH CONNECT' syntax conversion

#automation #database #opensource #sql
1
Comments 1
2 min read
Recursive CTEs, explained from first principles
sophiemwangi profile

Recursive CTEs, explained from first principles

#sql #cte #dataengineering #datascience
3
Comments 2
5 min read
The Unique Index That Makes Your Endpoint Retry-Safe
_66d02d0cc1ece7d1137c5f profile

The Unique Index That Makes Your Endpoint Retry-Safe

#idempotency #sql #testing #postgres
Comments 2
3 min read
The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems
amasen profile

The Transactional Outbox Pattern: Dual-Write Consistency in Distributed Systems

#sql #postgres #distributedsystems #architecture
Comments
3 min read
SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)
arpitmbangre profile

SQL DATEDIFF Internals: Why 2 Seconds Can Equal 1 Full Day (Boundary Traps)

#sql #database #dataengineering #beginners
Comments
2 min read
How to return top-N from each group with GROUP_CONCAT()
sanikolaev profile

How to return top-N from each group with GROUP_CONCAT()

#database #sql #opensource #tutorial
Comments
6 min read
Three ways your dashboard can be correct and still lie
sprettball profile

Three ways your dashboard can be correct and still lie

#data #sql #webdev #analytics
Comments
3 min read
SQLazy: Get the Latest Closed Before ConfirmationStarted
esproc_spl profile
Judy

SQLazy: Get the Latest Closed Before ConfirmationStarted

#backend #database #sql
5
Comments
3 min read
🚨 3 PostgreSQL Anti-Patterns That Are Silently Killing Your App's Performance
mindinu profile

🚨 3 PostgreSQL Anti-Patterns That Are Silently Killing Your App's Performance

#ai #webdev #productivity #sql
10
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.