SQL Data Partners Podcast

01/02/2025

Trying to decide between Data Lakehouse and Data Warehouse? In this episode we dive into the technical components and nuances between these two services and some of the decisions you'll have to make as you build out your data infrastructure.

Trying to decide on which service to choose? In this podcast episode we dive into the technical components and nuances between the Lakehouse and the Warehouse.

11/26/2024

Dive deep into OneLake as we explore Delta Lake Parquet, scenarios when "one" OneLake might not do the trick, and get some perspective on Direct Lake Mode for Power BI.

We’re discussing the Delta Lake format in OneLake, when multiple OneLake instances may be needed, and the pros and cons of Direct Lake Mode for Power BI data imports.

10/22/2024

OneLake to rule them all? In this episode, we explore OneLake as Fabric's central data hub with guest Mariano Kovo. We cover its key features, efficient data handling, and Azure integration using the Delta Parquet format, plus how Windows Explorer and shortcuts enhance data access.

We discuss OneLake as Fabric's central data hub, its Azure integration with Delta Parquet, and how Windows Explorer and shortcuts simplify seamless data access.

10/04/2024

Happy Friday Compañeros! Season 8 of the podcast begins next week 🎉 We hope you'll join us for an entertaining and educational dive into the world of Microsoft Fabric.

09/20/2024

SQL Server migrations can be daunting. We talk with Tejas Shah and Sudhir Raparla, to get their practical perspectives on approaching your SQL Server migration with confidence, and the tools and features available to make your next migration process a success.

Take a practical approach to your next SQL Server migration and learn about the newest tools and features available to help with a successful migration.

07/30/2024

Can you run SQL Server on Azure VM? Which VM is best? Is running SQL Server on a VM in Azure the right fit? Find out in this insightful episode, as Anders Pedersen talks about moving his SQL Server environment to Azure VMs, navigating the tiers and newest storage options, and how he manages upgrades.

Can you run SQL Server on Azure VM? Yes! We talk with Anders Pedersen about moving a SQL Server environment to Azure VMs, tiers, storage options, & upgrades.

07/15/2024

If you are a SQL Server DBA considering a switch to PostgreSQL, this podcast is for you. We talk with Ryan Booz, PostgreSQL Advocate at Redgate, about his experience making this transition, the terminology, tools, and tricks, as well as the community, and key aspects to consider if you are going to take a dive into the world's most popular open source database.

Switching from SQL Server to PostgreSQL? We talk with PostgreSQL Advocate Ryan Booz about the tools and tricks, the community, and key aspects to consider.

05/22/2024

Just getting started with Power BI? Join us tomorrow as Marathon's senior data solutions consultant Brian Knox presents a curated collection of practical tips and tricks designed to enhance your proficiency in Power BI and elevate your data storytelling capabilities.

https://www.meetup.com/rvapowerbiug/events/300922381/

05/21/2024

Dynamic SQL generally has a bad reputation due to it's propensity for errors and security risks such as SQL injection attacks. There are times however, when it can be used for good and that is what we are going to explore in this episode with our guest, Laura Moss.

Refreshing a subset of production data using Dynamic SQL. This use case outlines how the flexibility of this developers tool can be beneficial.

04/16/2024

What kinds of problems are organizations solving with Machine Learning? In this episode, we discuss the process of building a machine learning model designed to provide accurate rainfall data predictions for a public works department with two of Marathons data solution consultants.

We discuss the process of building a machine learning model designed to provide accurate rainfall data predictions for a public works department.

03/12/2024

Join the Richmond Power BI User Group for some pizza pie 🍕 on Pi Day, and learn about optimizing Power Query in Power BI! (That almost qualifies as a poem right?)

https://www.meetup.com/rvapowerbiug/events/299688911/

02/22/2024

If our last episode piqued your interest in the Capability Maturity Model, join us for this conversation with Andy Levy, who shares his own personal experience with CMM, in a role as the only data professional at his organization, starting at square one to influence change & improve processes.

Andy Levy shares his experience with the Capability Maturity Model (CMM) as the only data professional in his organization, starting from the ground up.

02/07/2024

If you're in the Richmond area, join Carlos and Steve at the Richmond Power BI User Group meeting for an exciting discussion on the latest updates and features of Power BI and Fabric. There will also be a Q&A session where you can ask any questions you may have and have the opportunity to network with other Power BI users and learn from their experiences.

Hey Everyone! I’m happy to announce that the Richmond Power BI User Group will be meeting again in 2024. Join us for an exciting Power BI User Group meeting on February 1

02/02/2024

Ever felt stuck in a rut, repeating the same tasks, knowing there's room for improvement? The Capability Maturity Model may be the answer. We discuss CMM with Kevin Edward Kline, how it relates to data professionals, and the path to drive change as leaders.

Data professionals can leverage the Capability Maturity Model to improve processes, contribute to company evolution, and grow their careers as leaders.

01/10/2024

Do you find yourself repeating the same actions when pulling SQL Server performance metrics? Erik Darling did. In this episode we sit down with him and discuss the scripts he built, shares, and how he uses them.

Do you find yourself repeating the same actions when pulling SQL Server performance metrics? We talk to DBA Erik Darling about the scripts he built, shares, and how he uses them.