Forem

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.
Thankful welcome from the.groov@gmail.com

Thankful welcome from the.groov@gmail.com

Comments
1 min read
Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server
Cover image for Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server

Identifying Stored Procedures Created or Modified Within a Date Range in SQL Server

1
Comments 2
2 min read
Stop Forcing Time Windows on Bursty User Behavior - Try This Instead
Cover image for Stop Forcing Time Windows on Bursty User Behavior - Try This Instead

Stop Forcing Time Windows on Bursty User Behavior - Try This Instead

Comments 1
4 min read
How to Access a PostgreSQL Database Remotely

How to Access a PostgreSQL Database Remotely

1
Comments
2 min read
Oracle 21c Enhancements for TTS Export/Import

Oracle 21c Enhancements for TTS Export/Import

Comments
2 min read
IoT monitoring with Kafka and Tinybird
Cover image for IoT monitoring with Kafka and Tinybird

IoT monitoring with Kafka and Tinybird

1
Comments
9 min read
The Best Tools to Design Database Schemas Visually in 2025
Cover image for The Best Tools to Design Database Schemas Visually in 2025

The Best Tools to Design Database Schemas Visually in 2025

10
Comments 3
7 min read
MySQL vs MongoDB - Visual Design with Real Data Models
Cover image for MySQL vs MongoDB - Visual Design with Real Data Models

MySQL vs MongoDB - Visual Design with Real Data Models

11
Comments 2
5 min read
New Tech Talk Proposal 😎 Just Dropped
Cover image for New Tech Talk Proposal 😎 Just Dropped

New Tech Talk Proposal 😎 Just Dropped

3
Comments 1
2 min read
Getting the Available Ranges from Two Tables — From SQL to SPL #34
Cover image for Getting the Available Ranges from Two Tables — From SQL to SPL #34

Getting the Available Ranges from Two Tables — From SQL to SPL #34

9
Comments 3
3 min read
Can ADO.NET Be Used in Modern Web Applications?

Can ADO.NET Be Used in Modern Web Applications?

Comments
3 min read
How Snowflake Copilot Inline Transformed My SQL Analysis Experience

How Snowflake Copilot Inline Transformed My SQL Analysis Experience

6
Comments 2
5 min read
🛡️ Understanding and Exploiting Blind SQL Injection
Cover image for 🛡️ Understanding and Exploiting Blind SQL Injection

🛡️ Understanding and Exploiting Blind SQL Injection

Comments 1
3 min read
EF Query vs SQL View in Entity Framework – Which One Would You Choose?

EF Query vs SQL View in Entity Framework – Which One Would You Choose?

Comments 1
3 min read
SQL Injection: All Concepts, All Payloads, All In One
Cover image for SQL Injection: All Concepts, All Payloads, All In One

SQL Injection: All Concepts, All Payloads, All In One

7
Comments 4
8 min read
I built a blazing-fast AI-Powered SQL editor ⚡️
Cover image for I built a blazing-fast AI-Powered SQL editor ⚡️

I built a blazing-fast AI-Powered SQL editor ⚡️

Comments
2 min read
SQL Tutorial for Beginners: Learn the Basics Step-by-Step

SQL Tutorial for Beginners: Learn the Basics Step-by-Step

2
Comments 1
4 min read
Is This a Refreshing Way to Understand Association?

Is This a Refreshing Way to Understand Association?

6
Comments 1
7 min read
Understanding Database Indexes: A Library Analogy
Cover image for Understanding Database Indexes: A Library Analogy

Understanding Database Indexes: A Library Analogy

Comments
4 min read
Oracle 23ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

Oracle 23ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

Comments 1
4 min read
Your PostgreSQL Command Cheat Sheet (But Way More Useful!)

Your PostgreSQL Command Cheat Sheet (But Way More Useful!)

3
Comments
6 min read
The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)

The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)

Comments
1 min read
Perbedaan Antara SOQL dan SOSL di Salesforce

Perbedaan Antara SOQL dan SOSL di Salesforce

Comments
1 min read
PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘
Cover image for PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

6
Comments
9 min read
MySQL Timeout 🐬⏰ Explained
Cover image for MySQL Timeout 🐬⏰ Explained

MySQL Timeout 🐬⏰ Explained

5
Comments
5 min read
loading...