Back to basics: SQL Parsing - the silent database killer

The Spoken Nerd

44:18

AI and Generative AI are transforming cybersecurity by enhancing threat detection and response. These technologies offer unmatched accuracy and efficiency, making them crucial for protecting sensitive data. As cyber threats evolve, integrating AI into security strategies is essential. This week, Dave, Esmee and Rob talk to Corence Klop, CISO at the Rabobank, about the expanding role of AI and Generative AI in cybersecurity, and how to begin integrating these technologies into your organization. TLDR 04:45 Rob is confused about wrong AI information for a hotel booking 08:20 Conversation with Corence 33:40 How can you identify the state of flow for your end-user in agile practices? 40:50 Going to the swimming pool and disco with your daughter Guest Corence Klop: https://www.linkedin.com/in/corenceklop/ Hosts Dave Chapman: https://www.linkedin.com/in/chapmandr/ Esmee van de Giessen: https://www.linkedin.com/in/esmeevandegiessen/ Rob Kernahan: https://www.linkedin.com/in/rob-kernahan/ Production Marcel van der Burg: https://www.linkedin.com/in/marcel-vd-burg/ Dave Chapman: https://www.linkedin.com/in/chapmandr/ Sound Ben Corbett: https://www.linkedin.com/in/ben-corbett-3b6a11135/ Louis Corbett: https://www.linkedin.com/in/louis-corbett-087250264/ ' Cloud Realities' is an original podcast from Capgemini…

3年之前 27:12

MP3•单集首页

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 servers used to be "Get Out Of Jail Free" card for IT practitioners, but how hardware advancements have shifted the responsibility for successful applications squarely back on the shoulders of developers. The way you handle parsing on the Oracle database could open the door to the incredible firepower of modern servers...or leave you scratching your head wondering why your CPUs are running hot but no work is getting done.

And believe it or not...if you have used a public restroom, you are well on the way to understanding how parsing relates to building scalable applications :-)

If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.

41集单集

#Tech #connormcdonald

Back to basics: SQL Parsing - the silent database killer

The Spoken Nerd

published 3年之前

MP3•单集首页

And believe it or not...if you have used a public restroom, you are well on the way to understanding how parsing relates to building scalable applications :-)

If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.

41集单集

#Tech #connormcdonald

Alle episoder

The Spoken Nerd

1
Tech chat with Martin Bach - part 3 33:13

45 weeks之前33:13

33:13

You might know Martin Bach from his current role of talking about the new JavaScript engine in Oracle Database 23ai. But long before that, Martin has been a well respected professional in the Oracle community, with many a DBA being in debt to his knowledge and assistance. In the final part of this 3 part series, Martin and I talk about working for Oracle, the latest release Oracle Database 23ai, and the role of Artificial Intelligence in general. Also, do we have any frustrations with the Oracle technology that we would like to improve? If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
Tech chat with Martin Bach - part 2 28:36

46 weeks之前28:36

28:36

You might know Martin Bach from his current role of talking about the new JavaScript engine in Oracle Database 23ai. But long before that, Martin has been a well respected professional in the Oracle community, with many a DBA being in debt to his knowledge and assistance. In this episode, Martin and I talk about the role of social media (blogs, video etc) in technical education, and cover the database books he has authored or co-authored over the years. And along similar lines to co-authorship, how Martin came to be working with Enkitec, a company renowned for having some of the best minds in the Oracle Database community. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
Tech chat with Martin Bach - part 1 25:03

47 weeks之前25:03

25:03

You might know Martin Bach from his current role of talking about the new JavaScript engine in Oracle Database 23ai. But long before that, Martin has been a well respected professional in the Oracle community, with many a DBA being in debt to his knowledge and assistance. In this episode, Martin and I talk about the beginnings of his Oracle career and how we had a lot in common with our experiences in the United Kingdom, even working for the same company at some point. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
The Best Things in Life are Free - part 2 34:27

1 year之前34:27

34:27

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 part 2 of my exploration of all of the cool Oracle stuff you can exploit without paying a cent. Links from the show Pre-Built VMs https://www.oracle.com/downloads/developer-vm/community-downloads.html Vagrant on Oracle Github https://github.com/oracle/vagrant-projects Running WordPress on Oracle Cloud https://www.youtube.com/watch?v=D_S5VI7zZSs Running MineCraft on Oracle Cloud https://recursive.codes/p/how-to-setup-and-run-a-free-minecraft-server-in-the-cloud Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions.…

The Spoken Nerd

1
The Best Things in Life are Free - part 1 21:13

1 year之前21:13

21:13

The Spoken Nerd

1
Back to Basics - Choosing a Tablespace Layout 26:14

1 year之前26:14

26:14

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 impact on how tablespace layout in databases. We'll also answer a critical question - how should you be using tablespaces today? Catch me on Twitter at https://twitter.com/connor_mc_d if you have questions. Download the original paper from Juan Loaiza here…

The Spoken Nerd

1
Back to Basics - The Burden of Proof 26:50

2 years之前26:50

26:50

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 your data will pass an audit? In this episode, I examine a real customer example - a customer that thought they were meeting all of their legal requirements, only to hit a firestorm when an audit of the database suggested otherwise. Achieving a correct ordering of transactions whilst still allowing high concurrency is an often overlooked issue. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
Back to Basics: Understanding Database Locking 31:31

2 years之前31:31

31:31

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 "Optimistic" and "Pessimistic" locking strategies, how they are used to handle the "Lost Update" problem, and what role the internet played in changing our view of database locking. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions. Blog post referred to in the episode: https://stewashton.wordpress.com/2017/06/17/avoiding-lost-updates-with-ora_rowscn/…

The Spoken Nerd

1
Catching up with Maria Colgan - part4 32:15

2 years之前32:15

32:15

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 talk about the rise of DevOps, the recent popularity of AI engines, her presentation style both in-person and on YouTube, plus some of personal passions such as going on safari and the Oscar movie cycle. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
Catching up with Maria Colgan - part3 24:23

2 years之前24:23

24:23

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 talk about what a face to face meeting with Larry Ellison is like; the cool features coming in 23c; JSON as the new data exchange standard and of course, her beloved Tesla :-) If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
Catching up with Maria Colgan - part 2 25:33

2 years之前25:33

25:33

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 landed the role of Optimizer Product Manager, whether hints should be documented, and the obsolescence of the rule optimizer. We also chat about the role of social media for the modern IT practitioner. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
Catching up with Maria Colgan - part 1 23:51

2 years之前23:51

23:51

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 beginnings of her Oracle career and how it led to Product Management, plus reminisce on our shared Irish heritage. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
The Dom Giles Sessions - part 3 36:45

2 years之前36:45

36:45

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, and a unique perspective on how Oracle has evolved over the years. Dominic Giles has 30+ years of experience with Oracle, and that makes him the perfect guest to talk about the Oracle Database. In this episode, Dom and I talk about CloudWorld, the role of the DBA in modern IT, and whether microservices is a good thing or just a giant mistake we'll never recover from. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
The Dom Giles Sessions - part 2 26:09

2 years之前26:09

26:09

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, and a unique perspective on how Oracle has evolved over the years. Dominic Giles has 30+ years of experience with Oracle, and that makes him the perfect guest to talk about the Oracle Database. In this episode, Dom and I talk about our favorite releases, how features get chosen for new releases, and how to best tackle patching your systems to keep them secure and up to date. If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.…

The Spoken Nerd

1
The Dom Giles Sessions - part 1 26:45

2 years之前26:45