When we couldn’t confirm a guest speaker by recording time, Eugene, Kevin, Amanda, and I decided the show must go on, so we went into the ideas vault and pulled out a couple of listener questions we hadn’t answered. In this episode, we talk about how to create your own documentation, SSMS installs, SOS_Scheduler_Yield and Eugene gives us an update on SQL Bits and the conference crud he picked up along the way.
The show notes and video for today's episode can be found at https://sqldatapartners.com/2023/03/29/episode-263-sql-server-this-n-that. Have fun on the SQL Trail!
Learning new technology can be difficult—especially when it’s a technology in an area you are not familiar with. In this episode, Eugene walks us through some of the challenges he has faced getting started with Azure Synapse. We hope that this episode might be helpful to those trying to learn new features.
The show notes and video for today's episode can be found at https://sqldatapartners.com/2023/03/15/episode-262-learning-azure-synapse-pt-1. Have fun on the SQL Trail!
It would appear Microsoft has run out of words to use for new features/products, so they are just going to recycle existing words for a bit of fun at our expense. In this episode we explore the Azure Data Lakehouse—which is not a data lake, nor a traditional data warehouse and Books Online (BOL) refers to it as Databricks Lakehouse. Luke Moloney walks us through how combining the flexibility of data lake storage with some ACID transaction and data governance gives organizations looking to analyze their data a new option. The hope is the cost to build, store, and analyze data will be easier and more approachable for organizations who don’t want to go with the traditional data warehouse model. This still feels like an Enterprise feature to me but let me know if your organization would be interested in this approach. As always, special thanks to Luke and the folks at Microsoft for making themselves available to us.
The show notes and video for today's episode can be found at https://sqldatapartners.com/2023/03/01/episode-261-the-data-lakehouse. Have fun on the SQL Trail!