THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to reshape datasets, allowing us to unpivot tables and also calculate the greatest and least values for a row. LINKS A…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to remove redundancy in the SELECT clause and simplify complex calculations, all with zero performance impact. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers on problems…| 36 Chambers – The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to find records associated with a “parent” table. We look at getting the latest record, as well as any arb…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I show how we can use the APPLY operator to operate on ad hoc functions. That leads to a powerful use case: pre-aggregating data. LINKS AND ADDITIONAL INFORMAT…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO 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 data…| 36 Chambers – The Legendary Journeys: Execution to the max!
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…| 36 Chambers – The Legendary Journeys: Execution to the max!
THE VIDEO 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, LLC,…| 36 Chambers – The Legendary Journeys: Execution to the max!
THE VIDEO 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…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO 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, my…| 36 Chambers – The Legendary Journeys: Execution to the max!
THE VIDEO 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 all…| 36 Chambers – The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I show how we can integrate an Azure OpenAI GPT-4 model into our Streamlit dashboard. Along the way, I also show off how easy it is to create multiple pages an…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I extend the Streamlit app that we’ve been working on even more. We’ll convert a set of drop-down lists into a form, change the behavior of these d…| 36 Chambers - The Legendary Journeys: Execution to the max!
THE VIDEO THE SYNOPSIS In this video, I extend a Streamlit app that I created in the prior video. This extension will include retrieving data from SQL Server, caching function results, operating a …| 36 Chambers - The Legendary Journeys: Execution to the max!