THE VIDEO https://youtu.be/Kqzc3DE7mJc THE SYNOPSIS In this video, I explain the history behind the APPLY operator in T-SQL. I also demonstrate one use case for it: executing table-valued functions. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems all across the…
SQL Saturday Raleigh 2025 Is Coming up Soon!
SQL Saturday Raleigh 2025 is going to take place on Saturday, May 17th. This is our first event since 2019, so it's been a long time coming. The Details What: SQL Saturday Raleigh 2025 Where: Duke Health, 14 Moore Drive, Durham, NC 27703 When: Saturday, May 17th from 8 AM until 5 PM. Who: Hopefully…
Video: The Azure ML SDK v1 Is Going Away in 2026
THE VIDEO https://youtu.be/uJ30R57Y1v4 THE SYNOPSIS In this video, I cover some news from Microsoft around the deprecation of the Azure Machine Learning SDK v1. We'll take a look at the upgrade guide and see what it will take to perform this upgrade. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services,…
Video: Comprehensions in Python
THE VIDEO https://youtu.be/ta1A7UZfwG0 THE SYNOPSIS In this video, I show how to use comprehensions in Python to generate lists, dictionaries, and sets. I also run a quick performance test, comparing a list comprehension to an equivalent for loop. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company…
The Monty Hall Problem
THE VIDEO https://youtu.be/rUgaZKZAX7U THE SYNOPSIS In this video, I explain the classic Monty Hall problem, based on the concept of the show Let's Make a Deal. I explain the paradox behind the problem and demonstrate that it's better to switch doors. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC,…
Video: The Basics of Bayes’ Theorem
THE VIDEO https://youtu.be/P8K5FHpoCdI THE SYNOPSIS In this video, I provide an introduction to Bayes' theorem, explaining the key concepts and terms, as well as solving a totally realistic problem via Bayesian analysis. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems…
Video: The Power of Virtual Environments in Python
THE VIDEO https://youtu.be/Th9Noj_078A THE SYNOPSIS In this video, I explain why virtual environments are such an important concept in Python and why you should generally be using them. I also talk about virtual environments versus Docker containers and how these are not mutually exclusive. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf…
Video: CONVERT/CAST and MAX–Order Matters!
THE VIDEO https://youtu.be/NxKuBw_IRS4 THE SYNOPSIS In this video, I demonstrate how order of operations matters when it comes to casting or converting a data type and performing an aggregation on that result. I'll use the specific example of converting binary data to a number and show where the fast version might lead you astray. LINKS…
Video: Avidity KPIs in T-SQL
THE VIDEO https://youtu.be/YNIKGDIsqgA THE SYNOPSIS In this video, we will take a look at two KPIs for measuring avidity. We will also show off how to use ranking window functions to order groups of customers. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help…
Video: Sales KPIs in T-SQL
THE VIDEO https://youtu.be/Mp6fQfVWdEs THE SYNOPSIS In this video, we will take a look at several useful KPIs for measuring sales. We will also demonstrate the utility of the APPLY operator, the WINDOW clause, and the APPROX_PERCENTILE_CONT() function. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where…
36 Chambers - The Legendary Journeys: Execution to the max! 