Data DevOps with the SQL Team - Episode 145

This week on the show, Jeffrey Palermo is joined by two special guests, Arvind Shyamsundar and Drew Skwiers-Koballa!   Arvind Shyamsundar is a Principal Program Manager on the Azure SQL DB Product Management team at Microsoft. He works to enable customers, partners, and colleagues to excel at what they do best by harnessing the power of data, advanced analytics, and cloud services. Arvind has worked at Microsoft for the last 18 years and was previously a part of the AzureCAT/DataCAT/SQLCAT group within Azure, and prior to that, a Principal PPE with Microsoft Services.   Drew Skwiers-Koballa is a Senior Program Manager on the SQL Tools and Experience team at Microsoft. In his role, he is focused on database development experiences and tools for Azure SQL/SQL Server. Previously to working with Microsoft, Drew was the Director of Information Technology at Inside Edge Commercial Interior Services.   In this episode, Drew and Arvind discuss data DevOps and how to run your SQL server database. Every system always has a SQL server database and there has been a lot of conversations over the years around the proper way to deploy a database, modify a database schema, monitor a database, etc. Drew and Arvind break down the current state-of-the-art technology and methods for running and deploying a SQL server database, the current tooling available around migration, strategies for Azure Data Studio, monitoring and telemetry flavors, and what to be on the lookout for as a developer looking forward in this landscape.   Topics of Discussion: [:14] About The Azure DevOps Podcast, Clear Measure, the new podcast Architect Tips, and Jeffrey’s offer to speak at virtual user groups. [1:26] About today’s episode with special guests, Arvind Shyamsundar and Drew Skwiers-Koballa. [1:45] Jeffrey welcomes Arvind and Drew to the podcast! [1:49] Arvind shares about the work that they do on the Azure SQL DB Product Management team and the previous roles he has held within Microsoft. [4:11] Drew shares about the SQL Tools and Experience team and how their focus is different from the Azure SQL DB Product Management team. [5:06] Arvind speaks about the current state-of-the-art technology and methods for running and deploying a SQL server database. [8:28] Drew shares his insights on the specifics around the tooling and the options that are available. [10:52] Beyond the DACPAC, is there another tool that is aligned with the migration approach? [11:59] From Microsoft’s tooling, what is the strategy? Is it to not provide a migrations-based approach or is there one in the works? From the highest strategy level, what conversations are happening within the SQL Tools and Experience team? [13:42] A word from Azure DevOps Podcast’s sponsor: Clear Measure. [14:13] If someone uses DbUp, do they still use a Visual Studio database project? Or is that an ‘either or’ decision? [18:37] What the landscape looks like right now for tooling around managing your SQL server database. [21:21] What is the strategy around ‘Azure Data Studio?’ Is it geared towards every storage service in Azure?  [23:09] Monitoring and telemetry: the current flavors that developers should know about and how to decide how to run your SQL server database. [29:30] What is currently coming out from a tools perspective that developers should be on the lookout for. [30:35] Go-to resources that Arvind and Drew recommend listeners check out. [32:40] Jeffrey thanks Arvind and Drew for joining the podcast!   Mentioned in this Episode: Architect Tips — New video podcast! Azure DevOps Clear Measure (Sponsor) .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon! bit.ly/dotnetdevopsebook — Click here to download the .NET DevOps for Azure ebook! Jeffrey Palermo’s Youtube Jeffrey Palermo’s Twitter — Follow to stay informed about future events! The Azure DevOps Podcast’s Twitter: @AzureDevOpsShow Arvind Shyamsundar’s LinkedIn Drew Skwiers-Koballa’s LinkedIn DbUp Azure Data Studio Redgate SQL Source Control Redgate Database Migrations Azure SQL Database Hyperscale Cosmos DB Microsoft Learn Azure SQL Fundamentals | Docs.Microsoft.com   Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.