Episode 189: Power BI Common Data Model
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!
23 Jan 202019min
Episode 188: Databricks
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!
16 Jan 202030min
Episode 187: Power BI Performance Tuning
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!
8 Jan 202027min
Episode 185: DBATools in a Month of Lunches
Why write a book, when you already have a site full of documentation? In this episode we chat with Rob Sewell about his project to write a book, DBATools in a Month of Lunches. He gives us some insights on what the book is about, how it is different than documentation, and how the process of making the book available in pieces has helped the creative process. The show notes for today's episode can be found at http://sqldatapartners.com/2019/12/19/episode-185-dbatools-in-a-month-of-lunches. Have fun on the SQL Trail!
19 Dec 201953min
Episode 184: Where do people get stuck with Power BI?
You've seen the visualizations and want to dive in--perhaps you were assigned the task. However you started with Power BI, chances are you might get stuck at some point. In this episode, we chat about strategies you can employee to help ensure success. Have a take on this? Hit us up on social media. We'd love to hear from you. The show notes for today's episode can be found at http://sqldatapartners.com/2019/12/11/episode-184-where-do-people-get-stuck-with-power-bi. Have fun on the SQL Trail.
12 Dec 201921min
Episode 183: SQL Server Big Data Clusters
SQL Server 2019 is out and one of the most interesting additions is SQL Server 2019 Big Data Clusters. In this episode, Kevin Feasel covers the marriage of SQL Server and Apache Spark. We discuss what Big Data Clusters are (and how it's not a SQL Server feature or an edition of SQL Server, but a thing in itself), cover some of the architecture behind the solution, and explain how we can use them. The show notes for today's episode can be found at http://sqldatapartners.com/2019/12/04/episode-183-sql-server-big-data-clusters. Have fun on the SQL Trail!
4 Dec 201933min
Episode 182: XEvents
The very first podcast episode I recorded was about Extended Events. We've had several new versions of SQL Server since that time, so I thought it was time to bring up the subject again. We are joined by MVP Jason Brimhall and he shares his insights on Extended Events, what has changed, and how to get started.
21 Nov 201938min
