The Spoken Nerd

The Spoken Nerd

Musings on technology from long time database professional. Some times we can't dedicate 100% of our attention to blog posts, or videos, or webinars, so whether you are working, or just working out. you can enjoy these podcasts alongside the daily grind

Episodes

March 27, 2024 34 mins

A common theme in my 30 years of using Oracle technology is that people love to label any and all things Oracle as "cool tech but way too expensive". But this argument is a reflection of a very dated view of Oracle, because times have changed. Nowadays there is a plethora of tools, platforms and initiatives provided by Oracle that are 100% free to take advantage of. In the same way that I don't run ads on this podcast :-) here is p...

Mark as Played

A common theme in my 30 years of using Oracle technology is that people love to label any and all things Oracle as "cool tech but way too expensive". But this argument is a reflection of a very dated view of Oracle, because times have changed. Nowadays there is a plethora of tools, platforms and initiatives provided by Oracle that are 100% free to take advantage of. In the same way that I don't run ads on this podcast :-), here's a...

Mark as Played

Login to a customer's Oracle Database and there are all sorts of permutations of how tablespaces are being used. Sometimes there is one giant tablespace for everything. Other times there are multiple tablespaces for different schemas, or different object types. The thinking on how tablespaces should be used has evolved over many years, and in this episode we'll take a look at the history of tablespaces and why this had such an impa...

Mark as Played
October 4, 2023 26 mins

There's a reason we don't just lump all of our data into Excel, Word and other such tools. Databases exist to give rigour to our data. They are the "statement of record" - the proof that our applications are meeting any business and/or regulatory requirements. The data stored in the database is typically the evidence that we provide to auditors and legal representatives that we are not breaking any rules. 

But are you sure that you...

Mark as Played

If you are the only person using a PC, then the concept of having to lock information is totally foreign, because all of the data is yours and yours alone. But databases were built for the multi-user world, where concurrent access to the data is the norm. To handle this, we sometimes need to lock the data to ensure it is controlled and updated in a way that guarantees integrity and correctness. In this episode, we discuss the "Opti...

Mark as Played

Known for many years as "the optimizer lady", there are very few people that can throw down with tech ubergeeks in the Oracle community whilst at the same time nonchalantly stroll into a meeting with Larry Ellision, but Maria Colgan is one of the select people that can do so.

Maria has nearly 3 decades of experience with the Oracle Database, covering SQL, performance, and the optimizer and even OS/2. In this episode, Maria and I ta...

Mark as Played
March 23, 2023 24 mins

Known for many years as "the optimizer lady", there are very few people that can throw down with tech ubergeeks in the Oracle community whilst at the same time nonchalantly stroll into a meeting with Larry Ellision, but Maria Colgan is one of the select people that can do so.

Maria has nearly 3 decades of experience with the Oracle Database, covering SQL, performance, and the optimizer and even OS/2. In this episode, Maria and I ta...

Mark as Played
February 22, 2023 25 mins

Known for many years as "the optimizer lady", there are very few people that can throw down with tech ubergeeks in the Oracle community whilst at the same time nonchalantly stroll into a meeting with Larry Ellision, but Maria Colgan is one of the select people that can do so.

Maria has nearly 3 decades of experience with Oracle, covering performance, the optimizer and even OS/2. In this episode, Maria and I talk about how she lande...

Mark as Played
February 8, 2023 23 mins

Known for many years as "the optimizer lady", there are very few people that can throw down with tech ubergeeks in the Oracle community whilst at the same time nonchalantly stroll into a meeting with Larry Ellision, but Maria Colgan is one of the select people that can do so.

Maria has nearly 3 decades of experience with Oracle, covering performance, the optimizer and even OS/2. In this episode, Maria and I talk about the beginning...

Mark as Played
January 12, 2023 36 mins

In the high energy world of modern IT, it has become commonplace to float between companies on a regular cadence, which can result in diluting your skillset across an ever broadening landscape. But occasionally you'll have the good fortune to encounter someone who has expanded their breadth of skills almost entirely within a single organisation, giving them a incredibly in-depth knowledge of the product, a strong mentoring focus, a...

Mark as Played
December 8, 2022 26 mins

In the high energy world of modern IT, it has become commonplace to float between companies on a regular cadence, which can result in diluting your skillset across an ever broadening landscape. But occasionally you'll have the good fortune to encounter someone who has expanded their breadth of skills almost entirely within a single organisation, giving them a incredibly in-depth knowledge of the product, a strong mentoring focus, a...

Mark as Played
November 23, 2022 26 mins

In the high energy world of modern IT, it has become commonplace to float between companies on a regular cadence, which can result in diluting your skillset across an ever broadening landscape. But occasionally you'll have the good fortune to encounter someone who has expanded their breadth of skills almost entirely within a single organisation, giving them a incredibly in-depth knowledge of the product, a strong mentoring focus, a...

Mark as Played

Databases are incredibly sophisticated pieces of software, and hence as they mature, the algorithms and logic behind what at first glance would seem to be trivial functionality are often amazing in their cleverness and cunning. In this episode we'll explore the complexity and sophistication around what would seem to be the simplest of questions: When I want to insert a row into a table, where should the database store that row? For...

Mark as Played

It is easy to be "too close" to things that you are familiar with, and thus become jaded and disenchanted with all of the minor frustrations one encounters over a long period of time. Frequent travellers revel in grumbling about the delayed take-off, the size of the plane seat, the annoying passenger, the slow arrival of baggage etc, at the same time losing sight of the wonder of flight. In the information technology industry, we c...

Mark as Played

It is easy to be "too close" to things that you are familiar with, and thus become jaded and disenchanted with all of the minor frustrations one encounters over a long period of time. Frequent travellers revel in grumbling about the delayed take-off, the size of the plane seat, the annoying passenger, the slow arrival of baggage etc, at the same time losing sight of the wonder of flight. In the information technology industry, we c...

Mark as Played

It is easy to be "too close" to things that you are familiar with, and thus become jaded and disenchanted with all of the minor frustrations one encounters over a long period of time. Frequent travellers revel in grumbling about the delayed take-off, the size of the plane seat, the annoying passenger, the slow arrival of baggage etc, at the same time losing sight of the wonder of flight. In the information technology industry, we c...

Mark as Played
July 4, 2022 22 mins

I first met Jackie McIlroy a few years back where she was an attendee at a pre-covid conference. Since then she has gone from strength to strength in the Oracle community, being a much-sought after speaker, an Oracle Ace, ODTUG committee member and chair for the Kscope APEX program. I caught up with her at the Kscope22 conference in Dallas Texas to chat about the impact of APEX and Community on her career.

If you like this episode,...

Mark as Played

Databases are incredibly complex pieces of software, which can come as a surprise given that anyone can throw together a few lines of C code to read and write data from a file. What differentiates a database from simple file read/write is how databases handle concurrent access to the data. For many years, the feature that has set Oracle Database apart from all others is its "read consistency" implementation or Multi Version Concurr...

Mark as Played

Parsing is the act of preparing to execute a SQL statement on your database.  It would seem to be a necessary activity - after all, that is what databases are designed to do - execute SQL.  But the topic of parsing requires a more nuanced look, because a high transaction frequency database typically succeeds or fails based the amount of SQL parsing it does.

In this episode, I'll take you on a trip down memory lane on how slow serve...

Mark as Played

No topic quite gets emotions rolling as much as the Oracle Query Optimizer. Thus you might expect that one of the least enviable jobs in the database world would be being the public face of the database optimizer. But since 2014, Nigel Bayliss has regularly fronted the community and shared the depth and breadth of his optimizer knowledge, whilst entertaining us with his sardonic wit on the challenges of databases and database optim...

Mark as Played

Popular Podcasts

    Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations.

    Math & Magic: Stories from the Frontiers of Marketing with Bob Pittman

    How do the smartest marketers and business entrepreneurs cut through the noise? And how do they manage to do it again and again? It's a combination of math—the strategy and analytics—and magic, the creative spark. Join iHeartMedia Chairman and CEO Bob Pittman as he analyzes the Math and Magic of marketing—sitting down with today's most gifted disruptors and compelling storytellers.

    Crime Junkie

    If you can never get enough true crime... Congratulations, you’ve found your people.

    Stuff You Should Know

    If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.

    New Heights with Jason and Travis Kelce

    Football’s funniest family duo — Jason Kelce from the Philadelphia Eagles and Travis Kelce from the Kansas City Chiefs — team up to provide next-level access to life in the league as it unfolds. The two brothers and Super Bowl champions drop weekly insights about their games and share unique perspectives on trending NFL news and sports headlines. Plus, entertaining stories from a combined 21 years in the league, off-field interests, and engaging conversations with special guests. Watch and listen to new episodes every Wednesday during the NFL season & check us out on Instagram, Twitter and Tiktok for all the best moments from the show.

Advertise With Us
Music, radio and podcasts, all free. Listen online or download the iHeart App.

Connect

© 2024 iHeartMedia, Inc.