Getting Close to the end of the year. Time to get Xmas presents...

Coming in Oracle AI Database #SQL assertions These enable you to create cross row, cross table constraints with SQL standard syntax CREATE ASSERTION … CHECK ( [ NOT ] EXISTS ( <query> ) ) @toonkoppelaars.bsky.social explains at #DOAG2025

Previously on @thatjeffsmith... 23ai ‘trivia’: Domains, Annotations, & Duality Views

🎤 Don’t miss DOAG Konferenz + Ausstellung 2025 — Nov 18–21, the premier event for database technologies in the German-speaking region! Join #OracleACE experts and industry leaders for in-depth sessions on Oracle tech, modern IT trends, open source, and more. 👉 anwenderkonferenz.doag.org/de/home/

Macros in Oracle #SQL enable you to define expression templates as text At parse time the database merges these with the parent query, replacing parameters with the actual values passed Macros come in two types Scalar - use in SELECT, WHERE, ORDER BY, etc. Table - use in FROM

Wie man den Logitech Spotlight *eigentlich* benutzt.

Der „freundliche Onkel“ @robbie.databee.org erzählt uns jetzt etwas über JSON Duality Views in der #Oracle #Database #23ai #26ai #ora2know

Exciting to see Oracle ACEs featured as speakers at SOUG Day Zurich 2025 on October 23! 🇨🇭✨ Get ready for a day full of expert insights and networking with the Swiss Oracle community. Discover more: 🔗 soug.ch/event/soug-day-zurich-2025/ @helifromfinland.bsky.social @danischnider.bsky.social

Who doesn't want to be part of the 16th edition of APEX World? Showcase your expertise in APEX to the community! We are seeking presentations for all skill levels, from novices to seasoned professionals, and everything in between. 👉 Visit buff.ly/dJc3ogC to submit your abstract! Open until Dec 1

It's always an honor to talk in front of people who should know better. :) Thank you everybody who did not enjoy the warm sun, but my talk. @oracleace.bsky.social @ora2know.de @sym42.bsky.social

#ora2know heute in Frankfurt! Launige Einführung von @martinklierdba.bsky.social und schon geht’s los mit dem „Oracle AI World 2025 Follow Up“ mit @sqlmaria.com!

Join us for the Database Cloud and Developer Day on November 13th at Oracle HQ in Utrecht. A few seats are still up for grabs for DC&D! Secure yours now before they're all taken. Visit nloug.nl/en/events/au... for more information. #Database @Oracle #Developer #Cloud #DCD26

Maria Colgan zu Gast bei ora2know @ora2know.de @sqlmaria.com @oracleace.bsky.social Sie erzählt von AI Revolution von letzter Woche in Vegas.

Eindücke von der #OracleAIworld in #Frankfurt - @sqlmaria.com first on stage mit Geschichten von der Versionsänderung #23ai auf #26ai. Sind wir #verwirrt? :) @oracleace.bsky.social @sym42.bsky.social

Previously on @thatjeffsmith... SQL Developer extension for VS Code 25.3: Charts & Diagrams

Getting closer to 80%...

Es gibt noch ein paar freie Plätze. Das wird super informativ und spannend. Sehen wir uns in Frankfurt und lernen gemeinsam über die neuesten Dinge aus der Oracle Welt?

No need to use WinGet to install Nano to edit files from the terminal - Just use: edit filename in Windows Terminal

Angry ticket from developers, why did "CREATE INDEX IF EXISTS" work in test envs, but not in prod. Chill, I'm just about to patch prod to 19.28. Normally would be excited, that devs actually read database new features guide, but lets be honest, it's LLM generated statement.

Blog post for September 2025 SQL Developer isn't entirely CBO-friendly. jonathanlewis.wordpress.com/2025/09/24/s...

A small Go module for TLS endpoint monitoring/testing. In addition to what it provides over standard Go functionality, is the ability to talk some STARTTLS protocols - in this release MySQL and PostgreSQL. Was pretty fun to discover the MySQL/PostgreSQL handshake protocols github.com/ilmarkerm/go...

Previously on @thatjeffsmith... Adding Custom Snippets in VS Code for SQL Developer

Previously on @thatjeffsmith... On REST APIs and Oracle Database 23ai JSON native types

+++ Wichtiger Hinweis für alle Fußballfans: Wir haben den Ablauf der #Mondfinsternis morgen Abend so organisiert, dass die spektakulärste Phase mit dem Kernschatten rechtzeitig vor dem Anstoß stattfindet. +++ #Service

Different approaches to monitoring, according to @jasminfluri.bsky.social at #POUG2025 (The Poland version is applicable in many countries 😇)

This is the #POUG essence. You can drink beer, you can party late, but you will also show up at 9 am the next day in the venue because the sessions are that good.

Why take an outage to deploy applications when you don't need to

Previously on @thatjeffsmith... Navigating your schemas/databases in SQLDev for VS Code

Insulting the AI.

📚 A rather mixed bag of items is in this week's reading list: 🔐 #security, ⚒️ #internals, 💡 #insights, and a by many long-awaited 🎉 #announcement are all included Happy reading 🤓

How to manually configure DNS on your Windows 11 Wifi connection. youtu.be/YW6dFVwddpY

A little story of Oracle APEX (Low Code) for the win oracle-base.com/blog/2025/09... @OracleAPEX #orclapex

Get faster PL/SQL in #SQL with alter session set sql_transpiler = on => database will convert eligible functions to SQL Read my latest post for details on What can be transpiled Transpiler vs scalar macros Functional differences Impact of function-based indexes blogs.oracle.com/sql/post/fas...

Fast=true (Almost, at least 😇) Read Chris’s blog post and learn how.

Der Friseur, der Merz in nicht mal vier Monaten 12.000 Euro für DIESE Frisur abgenommen hat, sollte umgehend Finanzminister werden. Der Junge saniert Deutschland im Schlaf.

Previously on @thatjeffsmith... Organize VS Code Database Environments: Connection Folders

New video: deploy a Python MCP server (FastMCP SDK) to Azure Functions (key auth), with optional APIM in front (Entra OAuth, following MCP auth spec). Video: www.youtube.com/watch?v=PAxB... Code: github.com/Azure-Sample...

Previously on @thatjeffsmith... JSON Relational Duality view & API for an ‘EMPLOYEES’ entity

Hier kann man den Status der IT Sicherheit in Deutschland bei Tageslicht sehen. Dienstleister die wie getroffene Hunde reagieren, Gesetze die von Leuten formuliert wurden die das Problem nicht verstehen. So erreichen wir nie das #Cybersec Niveau das wir brauchen. https://heise.de/-10569034

Materialized Columns are new in #Oracle #Database 23.7 Let's take a closer look at them! ⚠️ Lots of code coming next! 🤓

Having a go with Windsurf and Cascade, to generate a new 23ai schema, complete with test data and JSON Relational Duality Views...made possible in part with our MCP Server. How did it go? www.thatjeffsmith.com/archive/2025...

Bitte denkt bei diesen Temperaturen daran, Euch gründlich eiszucremen.

Übrigens … finde ich wichtig … #noAFD 🖖

Heute ist Mariä Himmelfahrt, das heißt, alle haben frei - außer ein paar randseitigen Bundesländern, Freelancern und Franken.

With Oracle database 23.9, we can finally use GROUP BY ALL in our SQL queries, as you can read in my latest blog post: danischnider.wordpress.com/2025/08/05/o...

‼️ #Oracle #Database 23.9 brings some really cool #Developer features to the table: 😎 GROUP BY ALL 🥇 Non-positional INSERT statements - first and only database to support this 🔢 UUIDv4 And more! Definitely check it out 👇

The #SQLcl #GitHub action just received an update. There's no longer a need for the versions.txt file and you can pick up versions as long as they are live on oracle.com. However, the recommendation remains to just use "latest". github.com/marketplace/...

Do your outer join queries produce more rows than expected? In this blog post, I show a strange result when using filter predicates in the join clause. dbLinter can help you sort your join and filter criteria and spot issues like this. www.salvis.com/blog/2025/07...

Gleich geht's los beim #Oracle #Upgrade und #Migration #Workshop beim #InstitutFürNotfallmedizin mit @mikedietrichde.com Wir freuen uns auf einen tollen Tag mit Euch! @oracleugs.bsky.social @oracleace.bsky.social

Yesterday's video record for our MCP for @OracleDatabase introduction with @krisrice www.youtube.com/watch?v=Xnmt...