Scott Stroz
MySQL Developer Advocate
Charles Town, West Virginia, United States
Actions
Scott has been a full-stack developer for longer than the term "full-stack developer" has been around. In that time, MySQL was the only constant in his development stack. He is passionate about sharing what he has learned on his coding journey so others may learn from his mistakes.
Area of Expertise
Topics
Shell Yeah! Unlocking MySQL Shell’s Best-Kept Secrets
Think MySQL Shell is just another command-line tool? Think again! MySQL Shell is packed with powerful, modern features that can take your database game to the next level—and it’s so much more than just a way to connect to MySQL.
In this action-packed session, we’re going to uncover some of MySQL Shell’s coolest (and most underrated!) features. Watch in real-time as we spin up sandbox instances for safe and speedy testing, master MySQL replication like a pro, and zap data to and from cloud storage buckets with ease. These tricks will save you time, simplify your workflow, and unlock a whole new world of possibilities inside MySQL Shell.
Ready to go beyond the basics? Buckle up and get ready to supercharge your MySQL experience!
Everything You Need to Know About MySQL Primary Keys - But Didn't Know to Ask
We all know that you should use primary keys in database tables, but, did you know the data type can have a huge impact of performance? In this session, we will discuss how decisions regarding primary key definitions (or lack thereof) can affect things such as disk I/O, indexes, and replication. We will also demonstrate some strategies you can implement in MySQL to mitigate these issues.
Scaling Up Without Stress: Demystifying MySQL Architecture
Have you suddenly found yourself stepping into a DBA role? Need to scale your MySQL setup but aren’t sure where to start? Or maybe you’re just fascinated by the inner workings of MySQL architecture? If any of this sounds like you—or even if you’re just MySQL-curious—then this session is made for you!
Join us as we dive into the world of MySQL architectures! We’ll explore everything from read replicas and clustering to cluster replication and more. You’ll learn when and why to choose each approach, and discover the handy tools that help you test-drive your architectures before you even think about production.
Feeling a bit overwhelmed by all the jargon? Don’t worry! With clear, simple examples (and a healthy dose of humor), we’ll break down complex topics and give you the confidence to architect your very own MySQL empire. Come ready to learn, laugh, and leave empowered!
HeatWave GenAI Unleashed: From Vector Stores to Retrieval-Augmented Magic
Get ready to discover the exciting world of HeatWave in Oracle Cloud! In this session, we’ll dive into the powerful new features of HeatWave GenAI. You’ll learn how easy it is to get started— from creating your own vector stores to harnessing the power of in-database large language models (LLMs). Together, we’ll walk through building a Retrieval Augmented Generation (RAG) client and unlock new possibilities for your data. Don’t miss this chance to see how HeatWave GenAI can take your projects to the next level!
The Top 10 Things You Didn't Know MySQL Shell Can Do
MySQL Shell is a new command line interface for connecting to and managing MySQL database instances - but you can do much more than run SQL queries. In this session, we will discuss some of the most helpful features of MySQL Shell that you might not know about.
Stored Functions, Supercharged: When JavaScript Meets MySQL
Get ready to supercharge your MySQL skills—JavaScript style! Did you know you can now write stored functions and procedures for MySQL using JavaScript? In this session, we’ll show you how to bring the power and flexibility of JavaScript right into your database.
We’ll uncover the unique benefits of using JavaScript for your stored logic, unravel the magic behind how your code gets translated for MySQL, and dive into hands-on examples you can start using right away. Plus, you’ll pick up some nifty debugging techniques to make development a breeze. Don’t miss this chance to level up your MySQL game with your favorite language!
Saving Lives, Squashing Bugs: My Journey from Paramedic to Programmer
Switched Careers? Unlock Your Hidden Coding Superpowers!
Ever taken a detour on your path to becoming a developer? Maybe you started out in teaching, marketing, design, retail—or, like me, as a paramedic. Surprise: those experiences are your secret weapons!
In this energizing keynote, I’ll share how my journey from the fast-paced world of emergency medicine to the dynamic landscape of software development revealed a treasure trove of transferable skills—like problem-solving under pressure, rapid decision-making, teamwork, and clear communication. We’ll explore how the unique talents you picked up in your previous careers can make you a more creative, effective, and resilient developer.
Whether you came from the ambulance, the classroom, or the boardroom, you already have a toolkit full of valuable experience—now it’s time to put it to work! Join me and discover how to uncover, embrace, and maximize your non-traditional background to supercharge your developer journey.
Break Up With Flaky Tests: Node.js + Testcontainers = Testing Bliss
Testing code that talks to your database doesn’t have to be a headache! With Testcontainers, you can take the pain out of database testing and supercharge your development workflow. In this action-packed session, we’ll show you how to leverage Testcontainers to spin up a fresh, reliable MySQL environment every time you run your tests—no more messy, leftover data to worry about! You’ll discover the key benefits of using Testcontainers, and get practical tips on seamlessly integrating them into your Node.js projects. Walk away ready to write efficient, effective, and rock-solid tests for all your database-driven code!
MySQL, Java, & Testcontainers - Testing Done Right
Writing tests for code that interacts with a database can be challenging. Testcontainers can help make it less of a challenge. In this session, we will talk about the advantages of using Testcontainers, how to use a MySQL container to have a clean database every time you run your tests, and how to incorporate each to effectively and efficiently test your Java code.
Using MySQL Document Store with Java
MySQL Document Store offers developers the best features of NoSQL and relational, SQL-based databases. In this session, we will discuss how we can use Java to access a MySQL Document Store, create/remove collections, create/update/remove documents, retrieve, filter, & sort document lists, and leverage raw SQL to retrieve aggregate data for reporting purposes.
Berry Big Data: Running and Replicating MySQL on Raspberry Pi
Ever dreamed of turning a Raspberry Pi into a pocket-sized powerhouse for your MySQL database—and then seamlessly syncing your data with the cloud? Now you can!
In this electrifying session, we’ll show you how easy (and fun!) it is to run MySQL on a Raspberry Pi. We’ll walk through the installation step by step, show you just how simple it is to start storing and managing data on your mini-server, and even demo an eye-catching application to visualize your data in real time. But that’s not all—prepare to be amazed as we crank things up and replicate your Raspberry Pi data straight to the cloud, opening a whole new world of remote access and backup possibilities.
Whether you’re a Pi enthusiast, a database aficionado, or just curious about creative ways to connect the physical and digital worlds, this session will inspire you to get hands-on and take your projects to the next level!
Using MySQL Document Store with SpringBoot
traditional SQL-based database. In this session, we will discuss how we can use SpringBoot to access a MySQL Document Store, create/remove collections, create/update/remove documents, retrieve, filter, & sort document lists, and leverage raw SQL to retrieve aggregate data for reporting purposes.
NoSQL + SQL = MySQL - An Introduction to MySQL Document Store
MySQL Document Store offers developers the best features of both a NoSQL database and a relational database. In this session, we will discuss how we can access a MySQL Document Store, create/remove collections, create/update/remove documents, retrieve, filter, & sort document lists, and leverage raw SQL to retrieve aggregate data for reporting purposes.
Using Window Functions in MySQL
Window functions in MySQL allow you to return aggregate data for a subset of your results in a single query. In this session, we will define what window functions are, and discuss use cases for when window functions might be appropriate. We will also break down the syntax of window functions and talk about the different clauses that can be used and demonstrate the functionality of window functions and how the different clauses can return different results.
NoSQL? Yes SQL! Rocking MySQL Document Store with Node.js
Ready to experience the best of both worlds—NoSQL freedom and SQL power—all inside MySQL? With MySQL Document Store, you can!
Join us for an action-packed session where we’ll show you how to harness the flexibility of document-based storage and the muscle of traditional SQL, right from your Node.js applications. You’ll learn how to effortlessly create and manage collections, add or update documents, and retrieve, filter, and sort your data just the way you want it. Want to go one step further? We’ll show you how to supercharge your reporting by combining document store wizardry with raw SQL for powerful data aggregation!
Whether you’re a NoSQL aficionado, a SQL fan, or just curious about what’s possible when you blend the two, this session will spark your creativity and give you practical skills to build smarter, more flexible apps. Don’t miss out on discovering a whole new dimension of MySQL!
JSON in MySQL: Old Tricks, New Superpowers!
Did you know that storing JSON in relational databases isn’t just a new trend—it’s a classic trick that’s been powering creative applications for years? And now, thanks to the modern JSON data type in MySQL, working with JSON is easier, faster, and more flexible than ever before!
Join us for a deep dive into the awesome possibilities of storing, updating, and querying JSON in your MySQL databases. We’ll kick things off by exploring why JSON might be the perfect way to store your data and discuss how it stacks up against other storage options. Next, we’ll unpack the powerful JSON functions MySQL offers, and walk through real-world examples of storing, retrieving, filtering, and sorting data—all while keeping it in that friendly JSON format. Plus, we’ll show you how to validate your JSON schema right inside your tables!
Whether you’re a seasoned pro or just curious about JSON in MySQL, this session is packed with practical tips and inspiring ideas to help you level up your database game. Don’t miss out!
UtahJS Conf 2023 Sessionize Event
JavaScript & Friends 2023 Sessionize Event
KCDC 2023 Sessionize Event
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top