loader from loading.io

Episode 205: Data Modeling for Power BI

SQL Data Partners Podcast

Release Date: 09/03/2020

Episode 229: Data Migration Assistant show art Episode 229: Data Migration Assistant

SQL Data Partners Podcast

The scary part of upgrading SQL Server is finding out you have a problem AFTER the fact. In this episode, Mariano Kovo joins us to discuss the Data Migration Assistant tool from Microsoft. While the name can be a bit misleading, (What? Microsoft have confusing names—that's a first), the major benefit to the tool is the assessment feature to alert you of potential issues when you upgrade.

info_outline
Episode 228: Predicting Application Problems with Database Metrics show art Episode 228: Predicting Application Problems with Database Metrics

SQL Data Partners Podcast

As data practitioners, we want to get ahead of any problems that might come up and share those insights with others on our team. In this episode, Edward Pollack gives us a few scenarios we might consider as we attempt to prevent application issues. These techniques also go into the security space and could help prevent data loss. As we collect this information and make it available to others, we can also demonstrate the ROI we provide to the organization.

info_outline
Episode 227: SSDT Methodologies for DB DevOps show art Episode 227: SSDT Methodologies for DB DevOps

SQL Data Partners Podcast

Organizations look to constantly improve and offer better services and the application tooling has been built to accommodate the process. Database tooling has been a bit slower to develop; however, in this episode Eitan Blumin, a co-host at sqlserverradio.com, brings us up to speed on the latest features of SQL Server Data Tools with some thoughts on how to get started with continual deployment or ‘devops’.

info_outline
Episode 226: SQL Server IaaS Agent Extension show art Episode 226: SQL Server IaaS Agent Extension

SQL Data Partners Podcast

Let’s say you have completed a lift and shift VM hosting to the cloud. Great—you now use Iaas services. While you don’t have to worry about the hardware, managing the software can be problematic. The SQL Server IaaS Agent Extension can offer some PaaS-like services and make it easier to manage the database environment. In this episode we chat with Ameena Lalani from Microsoft about this feature, why you might want to enable it, the prerequisites, and the downsides.

info_outline
Episode 225: Dashboard Design Principles show art Episode 225: Dashboard Design Principles

SQL Data Partners Podcast

Have you ever created a report in a visualization tool, spent all this time and energy creating something that looked really cool, went through more edits than you could remember only to deliver the report and have the recipient go “What am I looking at?” I don’t think I am the only one and, in this episode, we explore some of the rookie mistakes IT pros make when creating visualizations.

info_outline
Episode 224: The Standup Meeting show art Episode 224: The Standup Meeting

SQL Data Partners Podcast

Carlos, Kevin, and Eugene reconnect after some time away with a new streaming time.  Long form conversation on a single topic is also the place we want to get back to in our podcast. 

info_outline
Episode 223: Podcast Update show art Episode 223: Podcast Update

SQL Data Partners Podcast

With both Kevin and Eugene busy this week, Carlos went solo to share a few changes to the podcast, including the Twitch livestream moving to Tuesday, how you can support the podcast, and podcast episodes going back to being published every other Wednesday. If you have a subject that you’d like to chat about on the podcast with us, we’d love to schedule a time with you…go to sqldatapartners.com/podcast to sign up.

info_outline
Episode 222: Azure Arc-enabled Data Services show art Episode 222: Azure Arc-enabled Data Services

SQL Data Partners Podcast

Azure Arc-enabled data services provide powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from the Azure cloud. Since Eugene suggested our previous attempt at Azure Arc was insufficient, we invited Ben Weissman and Anthony Nocentino, authors of the book Azure Arc-Enabled Data Services Revealed, to the podcast to discuss how this technology came about and why the future looks very exciting.

info_outline
Episode 221: SQL Trail March 2021 Retrospective show art Episode 221: SQL Trail March 2021 Retrospective

SQL Data Partners Podcast

Virtual conferences are just not the same as the conferences we are used to, but we’re still determined to provide a good learning and networking environment for our friends. We very much miss having conferences in person and look forward to that happening again. In the meantime, we have discovered Airmeet and we had a great event: our first of the year. Carlos and Kevin sit down and dissect the good, the bad and the indifferent that was SQL Trail March 2021.

info_outline
Episode 220: Microsoft Ignite Recap show art Episode 220: Microsoft Ignite Recap

SQL Data Partners Podcast

As we prepare for SQL Trail on March 18th, we peek back at Microsoft Ignite and review the announcements made there—filtering out the pieces our compañeros will enjoy hearing about. Did we miss something you think we should talk about? Let us know!

info_outline
 
More Episodes

Power BI is founded on the idea of self-service BI and Excel is the most common data source in the world. While Power BI can import that information with ease, the data may not be in the best format. In this episode, we discuss areas report creators should consider when building Power BI reports so their reports can perform to their satisfaction and maintenance of the reports will be easier over the long run.

The show notes for today's episode can be found at https://sqldatapartners.com/2020/09/03/episode-205-data-modeling-for-power-bi. Have fun on the SQL Trail!