Moving up the ranks in the holy technology wars is the medallion architecture, and boy are we interested in getting your thoughts. Not since the 2008 Olympics and Michael Phelps' tenth of a second win over Milorad Cavic has there been so much controversy around bronze, silver, and gold. This episode of the podcast has a genesis with Databricks and the methodology of getting data into a workable form for all the reporting pieces businesses love so much. We discuss our thoughts on the various layers of a medallion architecture and the implementation in Azure delta lake environments. Have a diffe ..read more

In this Episode, Carlos talks about managed services and shares some of the benefits of working with an MSP, as well as potential cons.  The term manage services refers to the practice of outsourcing business administration or management responsibilities to the third party. Why would you ever want to outsource these pieces? Listen in to learn more and see if hiring an MSP would be a good decision for your company. The show notes for today's episode can be found at Episode 269: Why Do I Need a Managed Service Provider? Have fun on the SQL Trail ..read more

We love hearing from our listeners!!! In this episode, a long-time listener asked about the future of AI in the data platform space. We thought this was a very interesting topic as Microsoft has been including Artificial Intelligence or AI in more and more of its marketing material. In this episode we'll dive into the definition of AI, what features are currently available, how we can leverage those technologies, and where we think this might go in the future. One of the challenges we currently face is all the buzz and excitement around AI. From a data platform vantage point, we started with a ..read more

All your data, all your teams—in one place. What am I? If you said Microsoft Fabric, you win! When I interned with Cisco Systems in 2000, I supported a platform called Unified Messaging. At that time, we were talking about getting your email, voice mail, and faxes all in one place. My, how the times have changed. To a certain extent, the Microsoft Fabric is an extension, or wrapper, of some of the tools we have talked about in other episodes. The central idea is the ability to store your information in a data lake, and then having multiple tools at your disposal to use that data as required by ..read more

We're kicking off Season 7 with containers! Spinning up a VM may not be such a big deal anymore; however, most of us still have to request from another group one and wait. Even waiting on an Azure VM can be somewhat painful. Wouldn't it be nice to forget about setting up another development environment just to test something that isn't going to stick around? Our guest today is Chuck Bryan, and he talks to us about how he is using containers to support his environments and the flexibility it provides to him in his development. While the Linux containers used to get lots of love, there haven't b ..read more

Compañeros! In May, SQL Data Partners was acquired by Marathon Consulting.  There were many moving parts to get this done and we are excited to finally bring this news to the podcast.  In this episode we introduce the principles of Marathon Consulting, and we discuss the future of the podcast.  Make sure your speakers are adjusted properly when you listen to this episode.  If you have any questions or comments, please let us know via LinkedIn—we always look forward to hearing from you.  The show notes for today's episode can be found at Episode 265: WHY and What's Next ..read more

A backup is only helpful when you can restore the backup. This should not prove to be overly shocking; however, normally we get the satisfaction of taking a backup and feel like all is well. Ideally, we should be testing our backups on some cadence—and it should be more frequent than the annual disaster recovery test. In this episode of the SQL Data Partners Podcast we talk with Chris Marshall, owner of Verified Backups, about how he has solved this problem and how it can benefit your organization. We discuss some of the requirements you’ll need to address in your own testing, and we give some ..read more

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 ..read more

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 ..read more

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 ..read more