@linuxeasy.bsky.socialDBeaver Community 26.2.2 è disponibile con miglioramenti all'assistente AI, nuove opzioni per l'autocompletamento SQL, correzioni per PostgreSQL e altri database e interventi dedicati alla stabilità su Linux. #DBeaver #Linux #Database #SQL #OpenSource www.linuxeasy.org/dbeaver-26-2...
@rwale.bsky.socialNULL does not mean zero in SQL.
It means the value is unknown or missing, so = NULL will not filter it correctly. Use IS NULL or IS NOT NULL.
Understanding missing values prevents quiet errors in reports.
#SQL
@mikhail-mikushin.bsky.social3 use cases for Materialized views in SQL #data #dataanalytics #sql #dashboardperformance #datawarehousing
@kevinbowen.hachyderm.io.ap.brid.gyI suppose I should ask a question to hopefully learn more.
Is there a better way to do this:
"SELECT datname FROM pg_database WHERE datistemplate = false AND datname != 'postgres' AND datname NOT SIMILAR TO '%test_%' ORDER BY datname;")
@kevinbowen.hachyderm.io.ap.brid.gyMy #SQL skills are, quite honestly, barbaric.
But I did finally manage to solve some backup quirks that have been bothering me for a couple of weeks with a 'NOT SIMILAR TO' clause.
So... yay for me.🎉
@leanpub.bsky.socialThe Data and AI Engineering Playbook by Ritesh Modi is the featured bundle of ebooks 📚 on Leanpub!
Four volumes.
@dwilsoncoder.bsky.socialHere's a small project I've been working on: an SQL Sandbox. To be fully transparent, I started going over notes from my Colt Steele database class and wanted a platform to practice my SQL commands.
@labrafa.bsky.socialHe creado un canal en Rumble con las partes del tutorial #PostgreSQL y el lenguaje #SQL:
https://rumble.com/c/c-4781052
Suscríbete a mi canal.
#bbdd #Programacion #SiguemeYTeSigo #Followback
Nota: imagen generada con IA.
@edwardsdna.bsky.socialChannel9 SQL and AI for Developers in Action: Come see the Microsoft team show you the latest innovations for SQL, ground to cloud to fabric, to help you build AI applications securely with your data. This will be a heavy demo-oriented session so you can see the code and the… #SQL #AI #Microsoft
@cody-programmer08.bsky.socialGuess what the attack this is
#SQL #SSRF #Clickjacking #CSRF #Cybersecurity #CybersecurityAwarenessMonth
@dcac.comhttps://bit.ly/4f8XUYj SQL Server Performance for Developers
Join the 40k+ people who have learned how to improve #performance of your #SQL #Server #database applications.
#LinkedIn #Learing #IT
@mikhail-mikushin.bsky.socialSQL Materialized views constraints #data #dataanalytics #sql #datastaleness #incrementalrefresh
@communityaws.bsky.social"Idempotency in Data Engineering: How to Make Data Pipelines Safe to Rerun" by Felipe Ferreira Pinto
@gp-pulipaka.bsky.social
@rajeshdataai.bsky.social
