AzureFunBytes Episode 49 - Intro to @Azure SQL with @StevenMurawski
Tags: azure, database, cloud, beginners
Published: 2021-07-01 19:09:40

AzureFunBytes is a weekly opportunity to learn more about the fundamentals and foundations that make up Azure. It'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 [Microsoft LearnTV](https://cda.ms/226) and learn more about Azure.

![AzureFunBytes animation](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)

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'll focus on Azure SQL and the benefits of using your database in the cloud.

I've asked Microsoft Principal Cloud Advocate Manager [Steven Murawski](https://twitter.com/StevenMurawski) to help us this time to help us take an introductory look into the [](https://cda.ms/2cF) service. We take a dive into [what Azure SQL is](https://cda.ms/2cF), what makes up this service, how it's implemented, when you should select an VM over a Cloud Service, and more.  We look at things like DTU's, vCore, and other billing and service tiers that impact your deployment of Azure SQL. 

Our agenda:

- [What is Azure SQL?](https://cda.ms/2cF)
- [What are my Azure SQL options?](https://cda.ms/2cQ)
- [Creating an Azure SQL Database](https://cda.ms/2cR)
- [Administering an Azure SQL Database](https://cda.ms/2cS)
- [Querying Azure SQL Databases (and the tools to use)](https://cda.ms/2cT)
- [Networking and access control](https://cda.ms/2cV)
- [Some new and interesting stuff like elastic queries](https://cda.ms/2cW)

{% youtube ZGPigXfbOzo %}

[00:03:11 - Intro](https://youtu.be/ZGPigXfbOzo?t=191)
[00:08:44 - What is Azure SQL?](https://youtu.be/ZGPigXfbOzo?t=524)
[00:22:45 - Create an Azure SQL Instance from the portal](https://youtu.be/ZGPigXfbOzo?t=1365)
[00:30:08 - Sample data at creation time](https://youtu.be/ZGPigXfbOzo?t=1808)
[00:36:31 - Available hardware configs](https://youtu.be/ZGPigXfbOzo?t=1808)
[00:41:32 - Automatic tuning](https://youtu.be/ZGPigXfbOzo?t=2492)
[00:44:15 - Management tools for SQL](https://youtu.be/ZGPigXfbOzo?t=2654)
[00:55:37 - Network access to databases](https://youtu.be/ZGPigXfbOzo?t=3337)

From the [Azure SQL product page](https://cda.ms/2cz):

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:

- Migrate your SQL workloads with SQL Server on Azure Virtual Machines.
- Modernize your existing applications with Azure SQL Managed Instance.
- Support modern cloud applications with Azure SQL Database.
- Use your existing SQL skills in the cloud on the same SQL Server engine.
- Extend your applications to IoT edge gateways and devices with Azure SQL Edge.
- Keep making the most of your current license investments.
- Run Azure SQL on-premises and in multicloud environments with [Azure Arc-enabled data services](https://azure.microsoft.com/en-us/services/azure-arc/hybrid-data-services/).
- Learn more about saving time and money on your [migration](https://azure.microsoft.com/en-us/migration/).

------

Learn about Azure fundamentals with me!

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:

[AzureFunBytes on Twitch](https://twitch.tv/azurefunbytes)
[AzureFunBytes on YouTube](https://aka.ms/jaygordononyoutube)
[Azure DevOps YouTube Channel](https://www.youtube.com/channel/UC-ikyViYMM69joIAv7dlMsA)
[Follow AzureFunBytes on Twitter](https://twitter.com/azurefunbytes)

Useful Docs:

[Get $200 in free Azure Credit](https://cda.ms/219)
[Microsoft Learn: Introduction to Azure fundamentals](https://cda.ms/243)
[Ray Ozzie announces Windows Azure (2008)](https://www.zdnet.com/video/ray-ozzie-announces-windows-azure/)
[Azure SQL](https://cda.ms/2cz)
[Azure SQL documentation](https://cda.ms/2cB)
[Azure SQL Edge documentation](https://cda.ms/2cC)
[Microsoft Learn: Azure SQL fundamentals](https://cda.ms/2cD)
[Video Series: Azure SQL for beginners](https://cda.ms/2cG)
[What is Azure SQL?](https://cda.ms/2cF)
[What is Azure SQL Database?](https://cda.ms/2cH)
[Tutorial: Design a relational database in Azure SQL Database C# and ADO.NET](https://cda.ms/2cJ)
[Quickstart: Create an Azure SQL Database single database](https://cda.ms/2cK)
[On-Prem To The Cloud (episode 7): Migrating to Azure SQL](https://cda.ms/2cM)
[Azure SQL Database and Azure Synapse Analytics connectivity architecture](https://cda.ms/2cN)
[Monitoring and performance tuning in Azure SQL Database and Azure SQL Managed Instance](https://cda.ms/2cP)