Ian Carpenter's Avatar

Ian Carpenter

@iancarpenter.dev.bsky.social

Down this road...

45 Followers  |  190 Following  |  21 Posts  |  Joined: 14.11.2024  |  1.9467

Latest posts by iancarpenter.dev on Bluesky

Preview
Why does my call to json_table return null for a column despite it not being empty? I recently worked on a fun project involving JSON and Oracle Database 23ai. I had to store rather large JSON documents, individual field lengths exceeding what I usually see. No problem with that, …

πŸ” Seeing NULL from JSON_TABLE in Oracle even when the JSON field you query isn't null? It might be due to very long text values.

Here's how to debug & fix it πŸ‘‰ martincarstenbach.com/2025/08/07/w... #OracleDB #JSON #SQLTips

08.08.2025 09:50 β€” πŸ‘ 3    πŸ” 2    πŸ’¬ 1    πŸ“Œ 0
Preview
How is AlmaLinux OS is community-driven? with benny Vasquez In this episode, Scott Hanselman sits down with benny Vasquez, Chair of the AlmaLinux OS Foundation, to explore the project's journey since the shift away from CentOS. benny shares insights into how A...

Thanks @scott.hanselman.com and @bennyvasquez.bsky.social for this superb and accessible show on #AlmaLinuxOS I leant a lot from your conversation πŸ™Œ

hanselminutes.com/1008/how-is-...

07.08.2025 08:07 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
Statue plan to honour 19th Century computing pioneer in Hinckley Project organisers hope to highlight the mathematician's childhood links to the town.

www.bbc.co.uk/news/article...

07.08.2025 07:46 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Preview
Using Claude to β€˜fix’ my table comments via our MCP Server Using our new Oracle Database MCP Server with Claude desktop to improve some TABLE comments in my schema. With and without good columns names!

New post: using our MCP Server to allow our LLM to fix our Oracle Database table comments

www.thatjeffsmith.com/archive/2025...

31.07.2025 20:19 β€” πŸ‘ 3    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0
Preview
The Art of Assembly: Exploring Low-Level Mastery with Randall Hyde In this episode of Hanselminutes, Scott Hanselman talks with Randall Hyde, renowned for his expertise in programming and assembly language. Known as the creator of the Lisa Assembler and the author of...

this one with with Randall Hyde.

Both excellent shows, thank you! πŸ™Œ

www.hanselminutes.com/1006/the-art...

31.07.2025 18:52 β€” πŸ‘ 10    πŸ” 2    πŸ’¬ 1    πŸ“Œ 0
Preview
APIs as the Execution Layer of AI with Postman's Rodric Rabbah In this episode of Hanselminutes, Scott Hanselman chats with Roderick Rabah, Head of Product at Postman Flows, about the evolution of software development, the intersection of APIs and AI, and finding...

Thanks @scott.hanselman.com for the latest couple of Hanselminute shows. Really enjoyed your conversation with Rodric Rabbah in www.hanselminutes.com/1005/apis-as... as well...

31.07.2025 18:51 β€” πŸ‘ 6    πŸ” 3    πŸ’¬ 1    πŸ“Œ 0
Tech Promised Everything. Did it deliver? | Scott Hanselman | TEDxPortland
YouTube video by TEDx Talks Tech Promised Everything. Did it deliver? | Scott Hanselman | TEDxPortland

TEDx Talk - Tech promised everything, but did it deliver? youtu.be/dVG8W-0p6vg?...

31.07.2025 07:35 β€” πŸ‘ 120    πŸ” 21    πŸ’¬ 8    πŸ“Œ 3
Tech Promised Everything. Did it deliver? | Scott Hanselman | TEDxPortland
YouTube video by TEDx Talks Tech Promised Everything. Did it deliver? | Scott Hanselman | TEDxPortland

I just wanted to say, I’m probably more proud of this Ted talk than just about anything I’ve ever done so I’m gonna be absolutely useless for the next couple of weeks as I promote the shit out of this because I want you to watch it because it matters in the moment we are in youtu.be/dVG8W-0p6vg

17.07.2025 20:37 β€” πŸ‘ 982    πŸ” 270    πŸ’¬ 83    πŸ“Œ 91

It's super inefficient (and expensive) to have an LLM work on your data and files (CSV, markdown, whatever) directly. Have it create a script for you instead. I made a video about "compiling" markdown to one of @adamwathan.com's new Tailwind templates this way:

thenext.dev/blog/creatin...

26.07.2025 06:05 β€” πŸ‘ 8    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0

Scott and I have a great time in our latest podcast episode vibe coding a web site that analyzes our podcast recordings to show us who talks more...my suspicions were confirmed! www.youtube.com/watch?v=4tST...

24.07.2025 16:52 β€” πŸ‘ 28    πŸ” 2    πŸ’¬ 4    πŸ“Œ 0
Post image

Dynamic Statistics for PL/SQL Functions in Oracle Database 23ai

oracle-base.com/articles/23/...

@OracleDatabase #database #23ai

25.07.2025 06:30 β€” πŸ‘ 5    πŸ” 3    πŸ’¬ 0    πŸ“Œ 0
Preview
.NET Rocks! .NET Rocks! is a weekly talk show for anyone interested in programming on the Microsoft .NET platform. The shows range from introductory information to hardcore geekiness.

Do you have AI concerns? So does Mark Seemann!

Mark talks on .NET Rocks at www.dotnetrocks.com/details/1960 about his view on the impact that large language models are having on the development community!

24.07.2025 15:02 β€” πŸ‘ 4    πŸ” 1    πŸ’¬ 0    πŸ“Œ 0
Tech Promised Everything. Did it deliver? | Scott Hanselman | TEDxPortland
YouTube video by TEDx Talks Tech Promised Everything. Did it deliver? | Scott Hanselman | TEDxPortland

Hey friends! I did a TEDx talk and it's now up on the TED Conferences YouTube. It's possibly the best and most important talk I've ever done.

I would ask that you watch it, and please SHARE it broadly and widely. Thank you! youtu.be/dVG8W-0p6vg #AI #Tech #TED

17.07.2025 17:37 β€” πŸ‘ 560    πŸ” 229    πŸ’¬ 47    πŸ“Œ 45

Looking forward to watching this as I’ve enjoyed your chats with @markrussinovich.bsky.social on several episodes of Scott and Mark learn to… where you talked about the build up, coaching etc.

17.07.2025 18:06 β€” πŸ‘ 0    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
EPISODE 20 - Scott and Mark Learn To… Vibe Coding and Being Productive
YouTube video by Scott Hanselman EPISODE 20 - Scott and Mark Learn To… Vibe Coding and Being Productive

Thanks @scott.hanselman.com and @markrussinovich.bsky.social for another superb episode of Scott and Mark learn to...

"Mark cd" looks amazing, πŸ€―πŸ™Œ

youtu.be/UmXW8nGG9ZE?...

09.07.2025 20:38 β€” πŸ‘ 10    πŸ” 5    πŸ’¬ 0    πŸ“Œ 0
Oracle Developer Coaching: July News Edition
YouTube video by Oracle Developers Oracle Developer Coaching: July News Edition

Yesterday's video record for our MCP for @OracleDatabase introduction with @krisrice

www.youtube.com/watch?v=Xnmt...

09.07.2025 15:38 β€” πŸ‘ 11    πŸ” 4    πŸ’¬ 0    πŸ“Œ 0
Preview
Scott & Mark Learn To...

I love the show @scott.hanselman.com and @markrussinovich.bsky.social learn to. Slightly embarrassingly, I thought it was only available on YouTube and not as a podcast. When Mark literally referred to it as "a podcast" I had my revelation. Here's the links:

shows.acast.com/scott-and-ma...

26.06.2025 08:16 β€” πŸ‘ 14    πŸ” 3    πŸ’¬ 0    πŸ“Œ 0
Post image

What are the latest innovations coming in Azure?

@markrussinovich.bsky.social talks on RunAs Radio at runasradio.com/Shows/Show/991 about some of the new hardware in the cloud, and how they helps with extreme optimization for specific workloads!

02.07.2025 13:01 β€” πŸ‘ 9    πŸ” 5    πŸ’¬ 0    πŸ“Œ 0
Post image

How do you get more from GitHub in your work routine?

@theaprilyoho.dev talks on RunAs Radio at runasradio.com/Shows/Show/990 about how sysadmins can take advantage of more GitHub features to make better quality scripts!

25.06.2025 13:04 β€” πŸ‘ 4    πŸ” 4    πŸ’¬ 0    πŸ“Œ 0

Having Money != Being Smart

They are not smarter than you

09.06.2025 05:58 β€” πŸ‘ 227    πŸ” 22    πŸ’¬ 10    πŸ“Œ 2
spot art.
Photo of presenter(s).
text reads: Scott and Mark Learn to...LIVE

spot art. Photo of presenter(s). text reads: Scott and Mark Learn to...LIVE

In today's Microsoft Build session replay...
Mark Russinovich and Scott Hanselman put everything they learned at Microsoft Build together into one epic demo for the ages. Tune in: πŸŽ₯ https://msft.it/63322SiCRo

04.06.2025 19:30 β€” πŸ‘ 13    πŸ” 5    πŸ’¬ 0    πŸ“Œ 0

Prompt Injection is a top risk for use of LLMs, where untrusted data can cause a system to misbehave or leak data. We're hard at work on deterministic solutions to prevent or bound the risk, and just published a paper on our innovative information flow control approach: arxiv.org/pdf/2505.23643

05.06.2025 20:34 β€” πŸ‘ 34    πŸ” 10    πŸ’¬ 11    πŸ“Œ 5

Great show as always @patrick.risky.biz and Adam. πŸ™Œ

04.06.2025 08:43 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
Risky Business Weekly (794): Psychic Panda outgunned by Fluffy Lizard and UNC56728242
YouTube video by Risky Business Media Risky Business Weekly (794): Psychic Panda outgunned by Fluffy Lizard and UNC56728242

This week's show is up!

Google, Crowdstrike, PAN and Microsoft are agreeing to end fragmented naming conventions for APTs. We think that's a good thing.

VIDEO: www.youtube.com/watch?v=tvzh...
AUDIO: risky.biz/RB794/

04.06.2025 05:17 β€” πŸ‘ 12    πŸ” 2    πŸ’¬ 4    πŸ“Œ 0

Please let this be the title of the next Scott and Mark learn to… episode

03.06.2025 19:09 β€” πŸ‘ 2    πŸ” 0    πŸ’¬ 0    πŸ“Œ 0
EPISODE 17 - Scott and Mark Learn To… Induced Hallucinations
YouTube video by Scott Hanselman EPISODE 17 - Scott and Mark Learn To… Induced Hallucinations

Thank you @scott.hanselman.com and @markrussinovich.bsky.social for the latest and one of the funniest Scott and Mark Learn To..

Hilarious from the start with bifocal mode, hidden bodies and more. Superb stuff Gents πŸ™Œ

youtu.be/IYj6tj3bhsA?...

29.05.2025 18:44 β€” πŸ‘ 10    πŸ” 3    πŸ’¬ 0    πŸ“Œ 1

Our Build closing keynote was so fun - watch to find out if we get a robot to fetch Scott his diet cokes:

24.05.2025 12:49 β€” πŸ‘ 51    πŸ” 5    πŸ’¬ 0    πŸ“Œ 1
Scott and Mark Learn to...LIVE | KEY040
YouTube video by Microsoft Developer Scott and Mark Learn to...LIVE | KEY040

Our closing locknote (keynote opens… πŸ”’) with @markrussinovich.bsky.social is up! Absolutely insane and tense series of entirely live demos! May have been our best talk ever with a nail biting finale youtu.be/KIFDVOXMNDc?...

24.05.2025 03:55 β€” πŸ‘ 94    πŸ” 16    πŸ’¬ 4    πŸ“Œ 2
Beyond The Hype: Every Day, Real World Uses for Copilot - Rob Conery - NDC London 2025
YouTube video by NDC Conferences Beyond The Hype: Every Day, Real World Uses for Copilot - Rob Conery - NDC London 2025

Thanks @robconery.com tip regarding setting github.copilot.chat.commitMessageGeneration.instructions which has supercharged an already superb timesaving feature Excellent stuff mate πŸ™Œ

21.05.2025 20:39 β€” πŸ‘ 1    πŸ” 0    πŸ’¬ 1    πŸ“Œ 0
Panel 1: all terminal programs have 1 input and 2 outputs 

they're numbered: stdin is "0", stdout is "1", stderr is "2". 


(the numbers are called "file descriptors")

panel 2: you can set them to be any file you want

person: β€œI don't want to display the output in my terminal emulator, I want to write it to a file”
person: β€œI'll have the proram read input from a file instead of typing it in"

panel 3: 3 things you can set the inputs/outputs to

1. the TTY (so output is displayed in your terminal emulator)
2. a file
3. a pipe (to write output to the input of another program)

panel 4: your shell is in charge of setting up stdin/stdout/stderr

person: β€œpython3 script.py > out.txt”

shell: β€œok, I'll set stdout to out.txt for that program”


more about the syntax on page 15

panel 5: on 2>&1

2>&1 redirects stderr to stdout

you could also do 1>&2 but I've never used this N>&M syntax for anything other redirecting stderr to stdout

panel 6: gotcha: programs often buffer stdout but not stderr

when a program writes text to stdout, it'll often

1. check if stdout is a TTY (using the isatty function)
2. if not, "buffer" the writes until there's 1KB of data to write, for performance reasons

(this is the default in libc)

Panel 1: all terminal programs have 1 input and 2 outputs they're numbered: stdin is "0", stdout is "1", stderr is "2". (the numbers are called "file descriptors") panel 2: you can set them to be any file you want person: β€œI don't want to display the output in my terminal emulator, I want to write it to a file” person: β€œI'll have the proram read input from a file instead of typing it in" panel 3: 3 things you can set the inputs/outputs to 1. the TTY (so output is displayed in your terminal emulator) 2. a file 3. a pipe (to write output to the input of another program) panel 4: your shell is in charge of setting up stdin/stdout/stderr person: β€œpython3 script.py > out.txt” shell: β€œok, I'll set stdout to out.txt for that program” more about the syntax on page 15 panel 5: on 2>&1 2>&1 redirects stderr to stdout you could also do 1>&2 but I've never used this N>&M syntax for anything other redirecting stderr to stdout panel 6: gotcha: programs often buffer stdout but not stderr when a program writes text to stdout, it'll often 1. check if stdout is a TTY (using the isatty function) 2. if not, "buffer" the writes until there's 1KB of data to write, for performance reasons (this is the default in libc)

stdin, stdout, and stderr

wizardzines.com/comics/stdin...

21.05.2025 15:08 β€” πŸ‘ 184    πŸ” 24    πŸ’¬ 8    πŸ“Œ 0

@iancarpenter.dev is following 19 prominent accounts