explore | Grilled Cheese

Imagine at a job interview, I could market myself as an expert in #SQL, #Python, #Tableau, #Excel, and R.

Or I can say I’ve developed expertise in #BusinessAnalytics, knowing which tools to leverage at different stages of the analytical process.

The second one better reflects the value I bring.

Hey all

Finally, I think we landed on a great design with handling both reference (and seed) data in retrofit.

This week we demo managing reference data as part of the schema.

retrofit.sh/demos/refere...

#postgreSQL #SQL

A green test suite that fails in CI is usually not a CI problem. If a query sorts on a non-unique timestamp, Postgres can return ties in any order it likes.

#sql #postgres #testing

🔹 El cambio de motor a #Rust o los nuevos artefactos basados en #Parquet son algunas de las novedades que aportan mayor velocidad y escalabilidad
🔹 DBT 2.0 deja de ser solo un orquestador #SQL para convertirse en un motor de compilación robusto

#dbt #databuildtool #BigData

JumpServer V5 unifies SSH, RDP, Kubernetes, database and web access in one client, adds AI to SSH sessions, scripts, SQL and file operations. Will this unified client approach win over operations teams?
#JumpServer #SQL #AI #SSH #Kubernetes #database
pythonlibraries.substack.com/p/open-sourc...

FabCon and SQLCon 2026 in Barcelona: Building the data foundation for Microsoft Copilot and agents
azure.microsoft.com/en-us/blog/f...

#Fabric
#SQL
#Data
#Copilot
#agents

The industry keeps asking for index hints in the SQL standard. Codd named indexing dependence as a defect to be cured, in 1970, in the paper that introduced the relational model.

A hint puts it back.

thegresqlpost.org/articles/a-h...

#PostgreSQL #SQL #Databases #datasky

🔦 Speaker Spotlight: Amy Abel

Join Amy Abel at Boston Data and AI Saturday for "Creative GitHub Strategies for the Modern Database Professional".

📅 dayofdata.org/2026-10-03-d...

#BostonDataAISaturday #SpeakerSpotlight #GitHub #DatabaseProfessional #DevOps #SQL #DataCommunity

Recently updated:
hashcat is currently the only viable tool for auditing SQL Server 2025 login passwords.

#PBKDF2 slows down brute-force attacks both inside and outside of SQL Server compared to the pre-2025 hashing algorithm.
#sqlserver #sqldba #hashcat #cybersecurity #infosec #sql

https://bit.ly/4im5XDQ #PowerShell for SQL Server Administration

Join over 15k learners as they join @mrdenny.com in a journey though #PoSH for #SQL #Server #Administration and how PowerShell can be used to make administration of your SQL environment easier and faster.

#LinkedIn #Learing

CL versus #SQL: Which is better for creating a list of users with *ALLOBJ authority?

www.rpgpgm.com/2026/07/maki...

#IBMi #rpgpgm #IBMChampion

NULL indicates the absence of a value in #SQL

It's used for many reasons, so you need to learn its quirks

@winand.at covers

Comparisons
Mapping to and from null
Expressions propagation
Aggregate functions
Grouping
Sorting
Unique constraints

buff.ly/V6S9wAL

Analista de Transformação Digital Industrial — portal
Brazil

https://hiring.lat/job/analista-de-transformacao-digital-industrial-portal/277203

#python #aiml #sql

This is a hands-on role combining #ERP, #SQL, #PowerBI and business process expertise, with the opportunity to make a real impact across the business.

www.proactive.it/job/business...

A gdy wkurza cię tworzenie ręcznie bazy danych i wklepywanie zapytań można użyć mojego graficznego kreatora bazy. Działa z #sql #Postgre #mysql. I wygodnie i przyjemnie .https://forum.lothar-team.pl/viewtopic.php?t=1119. #golang . A układ ten sam co GUI buildera ...

What good is a best-effort exclusive lock, anyway?

gaultier.github.io/blog/what_go...

#optimization #sql #cockroachdb

Vector similarity search is getting closer to the database.

Percona Server for MySQL 9.7.2-2 adds DISTANCE() and VECTOR_DISTANCE(), so developers can score, rank and filter embeddings directly in SQL.

https://bit.ly/3TnSCTK

#MySQL #VectorSearch #AI #SQL #OpenSource