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 186: Analytics & Security: Find Pain Points, Make a Plan
2020 dawns a first for our podcast. This episode is dedicated entirely to a listener question. We've had questions before; however, this episode the team tackles two questions from longtime listener Trent Adams. The context of his questions surround the concepts of IT having the ability to provide new functionality to the business and the business appearing to be uninterested in moving forward. While we don't know the entire situation, we discuss the best way to identify pain points and ways to introduce new technology without imposing new rules/processes on the business. We would very much like to have more listener inspired episodes this year. If you have something you want to share with us, head over to sqldatapartners.com/podcast and submit your question and we'll try to help you on the SQL Trail! The show notes for today's episode can be found at http://sqldatapartners.com/2020/01/01/episode-186-analytics-security-find-pain-points-make-a-plan. Have fun on the SQL Trail!
27 Dec 201938min
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
