loader from loading.io

Episode 225: Dashboard Design Principles

SQL Data Partners Podcast

Release Date: 05/26/2021

Episode 238: Getting Started with Power BI - Part 2 show art Episode 238: Getting Started with Power BI - Part 2

SQL Data Partners Podcast

Power BI has been described as a “self-service” BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address before turning users loose with Power BI. In this conversation, Brandon Michals helps us take a look at three areas of consideration: your company, your people, and your data.

info_outline
Episode 237: Getting Started with Power BI - Part 1 show art Episode 237: Getting Started with Power BI - Part 1

SQL Data Partners Podcast

Power BI has been described as a “self-service” BI platform. While that may bring to mind an image of easy-peasy, plug-and-play, there are a few things most organizations will want to address before turning users loose with Power BI. In this conversation, Brandon Michals helps us take a look at three areas of consideration: your company, your people, and your data.

info_outline
Episode 236: Database Monitoring with SQL Sentry show art Episode 236: Database Monitoring with SQL Sentry

SQL Data Partners Podcast

Building your own scripts to monitor SQL Server seems like a very reasonable thing to do. We’re smart folks and SQL Server is what we do for a living—we should be able to figure this out. Upon further inspection, we found it was easier for us to focus on what we do—database administration, and let the developers focus on what they do—build software. This episode explores our choice of SolarWinds SQL Sentry as the monitoring standard for SQL Data Partners.

info_outline
Episode 235: SQL Trail 2021 In-person Q&A show art Episode 235: SQL Trail 2021 In-person Q&A

SQL Data Partners Podcast

Live Podcast! We decided it was time to try and get together in person and reconnect. As we did, we pulled out the microphone and started recording. As a result, we break the single topic mode this week and opened it up for a Q&A session. We touch on database monitoring, memory grants, what we miss about being in an office, and even SharePoint (Gasp!).

info_outline
Episode 234: Communication Tips for the IT Pro show art Episode 234: Communication Tips for the IT Pro

SQL Data Partners Podcast

As a data pro, you are negotiating and problem-solving all the time, often without knowing it. Your success as a professional as your company evolves its Data Platform depends on how well you can communicate and influence. It’s a scary thought, but your ability to negotiate with the business directly often determines if your projects get funded. In this episode, we chat with Blythe Morrow about strategies you can incorporate to better communicate with those around you.

info_outline
Episode 233: ScriptDOM show art Episode 233: ScriptDOM

SQL Data Partners Podcast

Never heard of ScriptDOM? Neither had we…okay, except Kevin, who obviously knows all. Apparently, the documentation is scarce. Mala Mahadevan uses it, loves it, and graciously offered to come back to the podcast to educate us and our listeners on a product that can help us parse, process and format our SQL queries.

info_outline
Episode 232: Giving Technical Presentations show art Episode 232: Giving Technical Presentations

SQL Data Partners Podcast

Public speaking is not fun for most; however, it can be very rewarding. Chris Seferlis chats with us about a few tips he has on being a speaker. Most of the tactical advice we defer to a toastmasters or public speaking group, so we give some thoughts on preparation, soliciting feedback, audience engagement, and handling criticism. I should point out that public speaking is WAY different from recording videos. We hope you find the information useful. Did we miss anything? Let us know!

info_outline
Episode 231: Mental Health and Wellness in IT show art Episode 231: Mental Health and Wellness in IT

SQL Data Partners Podcast

Everyone has bad days; however, how those bad days develop are unique to each of us. In a special episode, we chat with Tracy Boggiano about her experiences with Mental Health, how she has dealt with it, how each of us can work on our own mental health, and phrases we should avoid saying to those with mental health issues. Our own Eugene Meidinger shares a story on negative thinking and how damaging it can be.

info_outline
Episode 230: RTO & RPO show art Episode 230: RTO & RPO

SQL Data Partners Podcast

No one wants to lose data when disaster strikes; however, we need to plan for some data loss and putting all the pieces in place can be tricky. There are two metrics commonly used to measure data loss and availability when it comes to planning for disasters—Recovery Point Objective and Recovery Time Objective. In this episode, we touch on how you might come up with these metrics, how to consider the implementation cost, and how you might go about walking through a disaster situation to test your plan. 

info_outline
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
 
More Episodes

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.

The show notes and video for this episode can be found at https://sqldatapartners.com/2021/05/26/episode-225-dashboard-design-principles. Have fun on the SQL Trail!