Info

SQL Data Partners Podcast

Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.
RSS Feed Subscribe in Apple Podcasts
SQL Data Partners Podcast
2020
March
February
January


2019
December
November
October
September
July
June
May
April
March
February
January


2018
December
November
October
September
August
July
June
May
April
March
February


2017
December
November
October
September
August
July
June
May
April
March
February
January


2016
December
November
October
September
August
July
June
May
April
March
February
January


2015
December
November
October
September
August


Categories

All Episodes
Archives
Categories
Now displaying: 2020

Hosted by Carlos L Chacon, the SQL Data Partners Podcast focuses on Microsoft data platform related topics mixed with a sprinkling of professional development. Carlos and guests discuss new and familiar features and ideas and how you might apply them in your environments. Visit our website for episode show notes at sqldatapartners.com/podcast and leave a comment if you have a topic you think we should discuss. We’ll see YOU on the SQL Trail.

Mar 26, 2020

The number of new programming languages never ceases to amaze me. Technology advances continue to require new ways of allowing users to customize the way they use tools and Power BI is no different. In this episode, Ginger Grant joins us as we continue the conversation about DAX and some considerations you need to make should you want to pick up another language for the toolbelt.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/03/26/episode-195-understanding-dax. Have fun on the SQL Trail!

Mar 19, 2020

After Episode 180 on PolyBase came out, we received a few questions on use cases for PolyBaseCompañeros, when you ask, we reply! This episode we carve out 3 use cases for PolyBase and ways in which you might change workflows based on this SQL Server 2019 feature. If you want to dive much deeper into PolyBase, you can always check out Kevin's book on Apress!

The show notes for today's episode can be found at http://sqldatapartners.com/2020/03/18/episode-194-polybase-use-cases. Have fun on the SQL Trail!

Mar 12, 2020

Our regular host is down for the count with the flu; however, the podcast must go on! In this episode, we answer a listener-submitted question about Power BI Premium. Kevin and Eugene take us through Sachin Gangwar’s questions. We hope you will submit your question for a future episode!

The show notes for today's episode can be found at http://sqldatapartners.com/2020/03/11/episode-193-power-bi-premium. Have fun on the SQL Trail!

Mar 4, 2020

What is the future of the DBA and what technologies should I be focused on? In this episode, we attempt to look into the crystal ball and give our take on the future of work for the data platform professional. We focus our conversation around two listener-provided questions about the best way to stay educated in an ever-changing landscape. The DBA is dead. Long live the DBA. Join the discussion.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/03/04/episode-192-the-dba-is-dead-long-live-the-dba. Have fun on the SQL Trail!

Feb 12, 2020

Wouldn’t it be nice if you could filter the rows a user sees in Power BI? What’s that? You’ve already implemented Row-Level Security at the database level? Well, that actually won’t help you in Power BI. Yikes. In this episode we discuss ways to filter by records in Power BI and why it might be so confusing to implement what at first glance seems like a straightforward request.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/02/12/episode-191-power-bi-row-level-security. Have fun on the SQL Trail!

Feb 5, 2020
Getting released just before the end of the year, SQL Server 2019 is now available in general release. While at first glance, it appeared this release was all about Big Data Clusters, and rightfully so--it brings 'cloud first' options to on-premises scenarios; however, it is not the only big feature. We spoke about some of the Polybase changes in Episode 180 and in this episode, Javier Villegas guides us as we dive into some of the performance enhancements--and run out of time. This just means we need a few more episodes to dig into more features.
 
The show notes for today's episode can be found at http://sqldatapartners.com/2020/02/05/episode-190-sql-server-2019. Have fun on the SQL Trail!
Jan 23, 2020

Moving data is fairly straightforward; however, mapping data from one source to another can be extremely challenging. In an attempt to help self-service BI users, Microsoft has introduced a Common Data Model, and in this episode, we discuss the new model. This may not be as approachable for organizations which already have a data warehouse; however, for those who are in the Microsoft suite of tools and looking to report on that data in Power BI, the Common Data Model may be the jump start to get the model you need to get going.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/01/22/episode-189-power-bi-common-data-model. Have fun on the SQL Trail!

Jan 16, 2020

A couple of years ago, Netflix offered a reward for anyone who could improve the algorithm for choosing a movie. The team that came in second took what they learned from it and created a company -- Databricks. In this episode, we focus on Databricks; why it is popular, what it can be used for, and considerations for its use.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/01/15/episode-188-databricks. Have fun on the SQL Trail!

Jan 8, 2020

Make it go faster! Visualizations are great, but when users start complaining about the load times on reports, it can be a tough exercise to figure out the issues. In this episode, we discuss ways you can measure the speed of your Power BI reports. We also get into some of the fundamentals of data storage for Power BI.

The show notes for today's episode can be found at http://sqldatapartners.com/2020/01/08/episode-187-power-bi-performance-tuning. Have fun on the SQL Trail!

1