loader from loading.io

Episode 222: Azure Arc-enabled Data Services

SQL Data Partners Podcast

Release Date: 03/24/2021

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

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.

The show notes and video can be found at https://sqldatapartners.com/2021/03/24/episode-222-azure-arc-enabled-data-services. Have fun on the SQL Trail!