{"id":62072,"date":"2021-08-03T06:00:39","date_gmt":"2021-08-03T14:00:39","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/devops\/?p=62072"},"modified":"2021-07-29T07:07:07","modified_gmt":"2021-07-29T15:07:07","slug":"azurefunbytes-episode-49-intro-to-azure-sql-with-stevenmurawski","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/azurefunbytes-episode-49-intro-to-azure-sql-with-stevenmurawski\/","title":{"rendered":"AzureFunBytes Episode 49 &#8211; Intro to @Azure SQL with @StevenMurawski"},"content":{"rendered":"<p>AzureFunBytes is a weekly opportunity to learn more about the fundamentals and foundations that make up Azure. It&#8217;s a chance for me to understand more about what people across the Azure organization do and how they do it. Every week we get together at 11 AM Pacific on <a href=\"https:\/\/cda.ms\/226\">Microsoft LearnTV<\/a> and learn more about Azure.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/res.cloudinary.com\/practicaldev\/image\/fetch\/s--Z7BxBMz1--\/c_limit%2Cf_auto%2Cfl_progressive%2Cq_66%2Cw_880\/https:\/\/dev-to-uploads.s3.amazonaws.com\/uploads\/articles\/j2xzw2g664tj31jij13t.gif\" alt=\"AzureFunBytes animation\" \/><\/p>\n<p>At the heart of most applications is a database.  This database could provide critical information about customers, patients, store inventory, or even help us find a cure for diseases.  How we create, modify, and consume these databases is important to learn in order to be successful with our applications.  This week we&#8217;ll focus on Azure SQL and the benefits of using your database in the cloud.<\/p>\n<p>I&#8217;ve asked Microsoft Principal Cloud Advocate Manager <a href=\"https:\/\/twitter.com\/StevenMurawski\">Steven Murawski<\/a> to help us take an introductory look into the <a href=\"https:\/\/cda.ms\/2cF\">Azure SQL<\/a> service. We take a dive into <a href=\"https:\/\/cda.ms\/2cF\">what Azure SQL is<\/a>, what makes up this service, how it&#8217;s implemented, when you should select an VM over a Cloud Service, and more.  We look at things like DTU&#8217;s, vCore, and other billing and service tiers that impact your deployment of Azure SQL.<\/p>\n<p>Our agenda:<\/p>\n<ul>\n<li><a href=\"https:\/\/cda.ms\/2cF\">What is Azure SQL?<\/a><br><\/li>\n<li><a href=\"https:\/\/cda.ms\/2cQ\">What are my Azure SQL options?<\/a><br><\/li>\n<li><a href=\"https:\/\/cda.ms\/2cR\">Creating an Azure SQL Database<\/a><br><\/li>\n<li><a href=\"https:\/\/cda.ms\/2cS\">Administering an Azure SQL Database<\/a><br><\/li>\n<li><a href=\"https:\/\/cda.ms\/2cT\">Querying Azure SQL Databases (and the tools to use)<\/a><br><\/li>\n<li><a href=\"https:\/\/cda.ms\/2cV\">Networking and access control<\/a><br><\/li>\n<li><a href=\"https:\/\/cda.ms\/2cW\">Some new and interesting stuff like elastic queries<\/a><br><\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"AzureFunBytes Episode 49 - Intro to Azure SQL with @StevenMurawski\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/0U3R_yt489M?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p><a href=\"https:\/\/youtu.be\/ZGPigXfbOzo?t=191\">00:03:11 &#8211; Intro<\/a><br>\n<a href=\"https:\/\/youtu.be\/ZGPigXfbOzo?t=524\">00:08:44 &#8211; What is Azure SQL?<\/a><br>\n<a href=\"https:\/\/youtu.be\/ZGPigXfbOzo?t=1365\">00:22:45 &#8211; Create an Azure SQL Instance from the portal<\/a><br>\n<a href=\"https:\/\/youtu.be\/ZGPigXfbOzo?t=1808\">00:30:08 &#8211; Sample data at creation time<\/a><br>\n<a href=\"https:\/\/youtu.be\/ZGPigXfbOzo?t=1808\">00:36:31 &#8211; Available hardware configs<\/a><br>\n<a href=\"https:\/\/youtu.be\/ZGPigXfbOzo?t=2492\">00:41:32 &#8211; Automatic tuning<\/a><br>\n<a href=\"https:\/\/youtu.be\/ZGPigXfbOzo?t=2654\">00:44:15 &#8211; Management tools for SQL<\/a><br>\n<a href=\"https:\/\/youtu.be\/ZGPigXfbOzo?t=3337\">00:55:37 &#8211; Network access to databases<\/a><br><\/p>\n<p>From the <a href=\"https:\/\/cda.ms\/2cz\">Azure SQL product page<\/a>:<\/p>\n<p>Get a consistent, unified experience across your entire SQL portfolio and a full range of deployment options from edge to cloud. Intelligent and secure Azure SQL database services make it easy to:<\/p>\n<ul>\n<li>Migrate your SQL workloads with SQL Server on Azure Virtual Machines.<\/li>\n<li>Modernize your existing applications with Azure SQL Managed Instance.<\/li>\n<li>Support modern cloud applications with Azure SQL Database.<\/li>\n<li>Use your existing SQL skills in the cloud on the same SQL Server engine.<\/li>\n<li>Extend your applications to IoT edge gateways and devices with Azure SQL Edge.<\/li>\n<li>Keep making the most of your current license investments.<\/li>\n<li>Run Azure SQL on-premises and in multicloud environments with <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/azure-arc\/hybrid-data-services\/\">Azure Arc-enabled data services<\/a>.<\/li>\n<li>Learn more about saving time and money on your <a href=\"https:\/\/azure.microsoft.com\/en-us\/migration\/\">migration<\/a>.<\/li>\n<\/ul>\n<hr \/>\n<p>Learn about Azure fundamentals with me!<\/p>\n<p>Live stream is normally found on Twitch, YouTube, and LearnTV at 11 AM PT \/ 2 PM ET Thursday. You can also find the recordings here as well:<\/p>\n<p><a href=\"https:\/\/twitch.tv\/azurefunbytes\">AzureFunBytes on Twitch<\/a><br>\n<a href=\"https:\/\/aka.ms\/jaygordononyoutube\">AzureFunBytes on YouTube<\/a><br>\n<a href=\"https:\/\/www.youtube.com\/channel\/UC-ikyViYMM69joIAv7dlMsA\">Azure DevOps YouTube Channel<\/a><br>\n<a href=\"https:\/\/twitter.com\/azurefunbytes\">Follow AzureFunBytes on Twitter<\/a><br><\/p>\n<p>Useful Docs:<\/p>\n<p><a href=\"https:\/\/cda.ms\/219\">Get $200 in free Azure Credit<\/a><br>\n<a href=\"https:\/\/cda.ms\/243\">Microsoft Learn: Introduction to Azure fundamentals<\/a><br>\n<a href=\"https:\/\/www.zdnet.com\/video\/ray-ozzie-announces-windows-azure\/\">Ray Ozzie announces Windows Azure (2008)<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cz\">Azure SQL<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cB\">Azure SQL documentation<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cC\">Azure SQL Edge documentation<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cD\">Microsoft Learn: Azure SQL fundamentals<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cG\">Video Series: Azure SQL for beginners<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cF\">What is Azure SQL?<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cH\">What is Azure SQL Database?<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cJ\">Tutorial: Design a relational database in Azure SQL Database C# and ADO.NET<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cK\">Quickstart: Create an Azure SQL Database single database<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cM\">On-Prem To The Cloud (episode 7): Migrating to Azure SQL<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cN\">Azure SQL Database and Azure Synapse Analytics connectivity architecture<\/a><br>\n<a href=\"https:\/\/cda.ms\/2cP\">Monitoring and performance tuning in Azure SQL Database and Azure SQL Managed Instance<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>At the heart of most applications is a database. This database could provide critical information about customers, patients, store inventory, or even help us find a cure for diseases. How we create, modify, and consume these databases is important to learn in order to be successful with our applications. <\/p>\n","protected":false},"author":39313,"featured_media":62073,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[224],"tags":[],"class_list":["post-62072","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure"],"acf":[],"blog_post_summary":"<p>At the heart of most applications is a database. This database could provide critical information about customers, patients, store inventory, or even help us find a cure for diseases. How we create, modify, and consume these databases is important to learn in order to be successful with our applications. <\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/62072","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/39313"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=62072"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/62072\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/62073"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=62072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=62072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=62072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}