explore | Grilled Cheese

AI can generate SQL that runs perfectly and still returns the wrong number. The real problem may be your schema, joins and metric definitions. #sql

Hey all

We have a new retrofit demo to share:

retrofit.sh/demos/manual...

Imagine your team has been using retrofit for the past couple weeks and now every branch to be reviewed has a schema change that will require a migration in production. grin

#sql #db #postgreSQL

Ask TOM Live has been running over 8 years now!

That's nearly 100 sessions covering Oracle #SQL I've hosted - most of which included live demos

As requested by an attendee yesterday I've uploaded all my scripts for past sessions to GitHub

Get them at: github.com/ChrisSaxonOr...

Check out sqlfmt, an opinionated SQL formatter that simplifies your queries with a clean, consistent style. No config needed!

#golang #postgresql #reading-list #sql #tools

Discover how modeling state transitions as rows in Postgres unlocks rich historical queries without sacrificing performance.

#database #pattern #postgresql #reading-list #sql

𝐍𝐚𝐯𝐢𝐜𝐚𝐭 𝟏𝟖 𝐢𝐬 𝐨𝐟𝐟𝐢𝐜𝐢𝐚𝐥𝐥𝐲 𝐫𝐞𝐥𝐞𝐚𝐬𝐞𝐝! 🎉

Experience the future of database management with seamless AI integration, real-time SQL error detection, and enterprise-grade data masking.

www.navicat.com/en/navicat-1...

#Navicat #Navicat18 #Database #DevTools #SQL #TechNews #DataSecurity

This is an opportunity to join a small, ambitious Data & Insight team at an exciting point in its development.

www.proactive.it/job/data-bi-...
#PowerBI #SQL

Çok tablolu UPDATE ... JOIN hedef satırı en fazla BİR KEZ günceller. Kaç satır eşleştiği fark etmez.

SET n = n - 1, eşleşme başına değil satır başına bir düşer. Sürücü de doğru sorguyla aynı affected_rows'u verir: 3.

6 satır silindi, 3 düşüm uygulandı, hata yok:

dev.to/alestaweb

#MySQL #SQL

SQL構文は日本語で例えると理解しやすい

#SQL #初心者 #初心者向け #DB

How well do you know your data trivia? 🤓

Put your analytics knowledge to the test in this week's #poll.

Cast your vote here:
🔗 www.linkedin.com/posts/calibr...

#AnalyticsTrivia #DataFacts #SQL #GA4 #Python

Protect data at the source with Oracle Deep Data Security

This uses simple #SQL to define

End users in the app
Data roles these users have
Data grants controlling which rows and columns they can see

@anders-swanson.bsky.social explains buff.ly/MPyu01O

Normalisierung der Datenbank - warum es nur immer wieder Entwickler gibt, die meinen, so was brauche man nicht. Die haben wohl auch noch nie an so einer DB arbeiten müssen.

#mysql #mariadb #sql #developer #development #database

#DOAG2026: Christian Schwitalla sprach mit Matthias Schulz über Oracle-Datenbankentwicklung, Performance, KI, Performance-Sünden und seine Vortragshighlights auf der Oracle Anwenderkonferenz.
➡️ scomp.ly/39xmjzV

Die Konferenz: scomp.ly/9K4Vv38

#Oracle #OracleDatabase #Performance #SQL

I added an index to speed up one query and it made things worse. Here is the Postgres mechanism behind it, how I confirmed it with EXPLAIN, and what I do instead.

#postgres #sql #performance

I added an index to speed up one query and it made things worse. Here is the Postgres mechanism behind it, how I confirmed it with EXPLAIN, and what I do instead.

#postgres #sql #performance

https://dev.to/_66d02d0cc1ece7d1137c5f/why-the-index-i-added-made-my-query-slower-4k75-temp-slug-5232113

📢 Fidelity International is #hiring a Technical Data Analyst!

🌎
⏰ Generous parental leave

🔗 http://jbs.ink/cPIVhx2zB7pf

#jobalert #jobsearch #JobSeekers #4dayworkweek #python #aws #dataengineer #sql #design