Podevcast

Davide Mauri on Azure SQL for Developers - Episode 139

Azure DevOps Podcast

Episode | Podcast

Date: Mon, 03 May 2021 08:00:00 +0000

This week on the podcast, Jeffrey is joined by Davide Mauri, a Program Manager in the Azure SQL Database product group at Microsoft. Davide has been working in the IT field since 1997 and was awarded Data Platform MVP status for 12 consecutive years. He started his career as a full-stack and back-end developer, then focused on databases and data science for 15 years while still keeping alive his passion for development (mainly in C# and Python). He then moved to the Internet of Things (IoT) and big data space. Building from that experience, he joined Microsoft to help companies worldwide to leverage stream processing at scale. In his current role within the Azure SQL Database product group, Davide works to make sure that Azure SQL Database is — and will be — the best database option for developers. In their conversation, Davide speaks about the developer’s journey into using Azure SQL Database; the key differences between Serverless and Hyperscape; important concepts you need to be aware of as a developer using Azure SQL Database; his recommendations on which version you should use (SQL Developer Edition, Express, or LocalDB); and guidance around deploying and database deployment tools, monitoring and telemetry tools, and the autoscale feature. Topics of Discussion: [:38] Be sure to visit <a href="http://azuredevops.show/">AzureDevOps.Show</a> for past episodes and show notes. [:50] About The Azure DevOps Podcast, Clear Measure, the new podcast Architect Tips, and Jeffrey’s offer to speak at virtual user groups. [1:21] About today’s episode with Davide Mauri. [1:47] Jeffrey welcomes Davide Mauri to the podcast. [1:54] Davide shares about his career journey and how he came to work at Microsoft. [3:27] The state of Azure SQL. [5:59] Why did Davide decide to write his book, Practical Azure SQL Database for Modern Developers? What does the book cover? [9:18] Davide highlights some general rules-of-thumb and important concepts around Azure SQL Database. [13:02] What is a Database Transaction Unit (DTU)? How do you figure out what your DTU is? And how do you make a database in Azure not cost as much? [18:08] For the local developer workstation, what are Davide’s recommendations on using either SQL Developer Edition, Express, or LocalDB? [20:13] A word from Azure DevOps Podcast’s sponsor: Clear Measure. [20:44] Davide’s guidance for developers around deploying and database deployment tools. [26:34] The monitoring and telemetry tools you need to be aware of as a developer to know exactly what is going on with your database. [28:59] One of the big selling points of Azure SQL is the autoscale feature. Davide shares some of his key insights for developers when traffic is ramping up and it’s stressing the database. Davide also compares Serverless and Hyperscale. [32:58] About the recent release of Microsoft.Data.SqlClient 3.0. [35:14] Jeffrey thanks Davide for joining the podcast and Davide shares where to get a hold of his new book, Practical Azure SQL Database for Modern Developers. Mentioned in this Episode: <a href="http://architecttips.clearmeasure.com/"> Architect Tips</a> — New video podcast! <a href="https://azure.microsoft.com/en-ca/services/devops/?&OCID=AID736756_SEM_7eul5uID"> Azure DevOps</a> <a href="https://www.clear-measure.com/">Clear Measure</a> (Sponsor) <a href="https://www.amazon.com/NET-DevOps-Azure-Developers-Architecture/dp/1484253426"> .NET DevOps for Azure: A Developer's Guide to DevOps Architecture the Right Way, by Jeffrey Palermo</a> — Available on Amazon! <a href="http://www.lulu.com/shop/jeffrey-palermo/net-devops-for-azure-ebook-edition/ebook/product-24094762.html"> bit.ly/dotnetdevopsebook</a> — Click here to download the .NET DevOps for Azure ebook! <a href="https://www.youtube.com/channel/UC-ROXy08zc-qTA0-3GAQDLw"> Jeffrey Palermo’s Youtube</a> <a href="https://twitter.com/jeffreypalermo?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor"> Jeffrey Palermo’s Twitter</a> — Follow to stay informed about future events! <a href="https://blog.stevensanderson.com/">The Azure DevOps Podcast’s Twitter: @AzureDevOpsShow</a> <a href="https://www.amazon.com/Practical-Azure-Database-Modern-Developers/dp/1484263693/ref=sr_1_1?dchild=1&keywords=davide+mauri&qid=1619726231&sr=8-1"> Practical Azure SQL Database for Modern Developers: Building Applications in the Microsoft Cloud, by Davide Mauri, Silvano Coriani, Anna Hoffman, Sanjay Mishra, Jovan Popovic</a> <a href="https://docs.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-frequently-asked-questions-faq"> Azure SQL Database Hyperscale</a> <a href="https://www.amazon.com/Practical-Issues-Database-Management-Practitioner/dp/0201485559/ref=sr_1_1?dchild=1&keywords=Practical+Issues+in+Database+Management%3A+A+Reference+for+the+Thinking+Practitioner&qid=1619733146&sr=8-1"> Practical Issues in Database Management: A Reference for the Thinking Practitioner, by Fabian Pascal and Stacie Parillo</a> <a href="https://octopus.com/">Octopus Deploy</a> <a href="https://azure.microsoft.com/en-us/updates/azure-monitor-sql-insights-for-azure-sql-in-public-preview/"> Azure Monitor SQL Insights</a> <a href="https://techcommunity.microsoft.com/t5/sql-server/released-microsoft-data-sqlclient-3-0-preview-1/ba-p/2175876"> Microsoft.Data.SqlClient 3.0</a> Want to Learn More? Visit <a href="http://azuredevopspodcast.clear-measure.com/">AzureDevOps.Show</a> for show notes and additional episodes.