THE VIDEO https://youtu.be/Ya46CXulTtA THE SYNOPSIS In this video, we will learn why Venn diagrams are not good for describing join behavior. From there, we'll learn exactly what Venn diagrams describe quite well: set operations. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where I help customers…
Video: The Big Drop: Microsoft Fabric is Here
THE VIDEO https://youtu.be/8UI_vjaAY80 THE SYNOPSIS This video provides an overview for Microsoft Fabric, the Software-as-a-Service solution for data warehousing, data engineering, data science, real-time analytics, and more. We see where it fits with respect to Azure Synapse Analytics and get an idea of how the product is organized. LINKS AND ADDITIONAL INFORMATION All of these…
Video: The Second Query is Actually Harder
THE VIDEO https://youtu.be/2OGMFeIs2jA THE SYNOPSIS In this video, we are going to build on the basic components of a T-SQL SELECT query and introduce the notion of joins. 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…
Video: The First Query is Always the Hardest
THE VIDEO https://youtu.be/Liq4Mb02afw THE SYNOPSIS In this video, we are going to take a gentle walk through some T-SQL syntax and build up a few queries to understand how some of the key clauses in T-SQL work. LINKS AND ADDITIONAL INFORMATION All of these videos are on behalf of Catallaxy Services, LLC, my consulting company where…
Video: Let’s Get a Database!
THE VIDEO https://youtu.be/4dH118V-8jc THE SYNOPSIS In this video, we will talk about and restore three demo databases to a SQL Server instance. 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 platform space. Links AdventureWorks database WideWorldImporters…
Video: The Top 5 Client Tools for SQL Server
THE VIDEO https://youtu.be/sUrboK5wvXA THE SYNOPSIS In this video, we will talk about five Microsoft-created (or sponsored) tools for connecting to SQL Server. We talk all the time about SQL Server Management Studio and Azure Data Studio, but they aren’t the only kids in this family. LINKS AND ADDITIONAL INFORMATION All of these videos are on…
Video: Top 5 Add-Ins for SQL Server
THE VIDEO https://youtu.be/3nAc8o5aJgI THE SYNOPSIS What are the five best third-party, T-SQL-based solutions for SQL Server? Ground Rules The product is not included with SQL Server itself. The product must be built around T-SQL and 'internal' to SQL Server, not external scripts which hit a SQL Server. That is why, for example, the excellent dbatools…
Video: Configuring a SQL Server Instance
THE VIDEO https://youtu.be/-rLwXEWk2a8 THE SYNOPSIS We’ve installed SQL Server…but what next? Learn about important configuration options for that new SQL Server instance. 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 platform space. Links Rough guidance on…
Video: Installing SQL Server in a Container
THE VIDEO https://youtu.be/7cgIpreXRag THE SYNOPSIS Want to try out SQL Server without explicitly installing (or needing to uninstall) it? Here's how to run SQL Server on Linux in a container. 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…
Installing SQL Server on Linux
THE VIDEO https://youtu.be/GBboALYvvuE THE SYNOPSIS In this video, we will show how to install SQL Server on a machine running Linux. We'll see how the Linux installation process differs from the Windows process and leave a bit of respect at Linux Mandrake's door (RIP Mandrake). LINKS AND ADDITIONAL INFORMATION All of these videos are on…
36 Chambers - The Legendary Journeys: Execution to the max! 