AzureFunBytes Reminder - @Azure SQL with @StevenMurawski - 7/1/2021

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 and learn more about Azure.

When: July 1, 2021 11 AM Pacific / 2 PM Eastern
Where: Microsoft LearnTV

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 to help us this time to help us take an introductory look into the service. We'll take a dive into what Azure SQL is, what makes up this service, how it's implemented, when you should select an VM over a Cloud Service, and more. We'll take your questions and make sure you get the most out of this session.

Our agenda:

• What is Azure SQL?
• What are my Azure SQL options?
• Creating an Azure SQL Database
• Administering an Azure SQL Database
• Querying Azure SQL Databases (and the tools to use)
• Networking and access control
• Some new and interesting stuff like elastic queries

In 2008, at the Microsoft Professional Developers Conference, Microsoft Chief Software Architect at the time, Ray Ozzie, announced the new cloud computing operating system: Windows Azure. One of the five key components of the Azure Services Platform launch was Microsoft SQL Services. From the beginning, SQL has been a large part of Azure. SQL Azure was created to provide a cloud-hosted version of SQL Server. Windows Azure was later renamed to Microsoft Azure, SQL Azure was renamed to Azure SQL, and both have since dramatically expanded services.

Since 2008, SQL Server and Azure SQL have both evolved to become more available, scalable, and performant to meet the demands of any application. The database services offered have expanded from SQL Server to include open-source databases like Azure Database for PostgreSQL and Azure Database for MariaDB.

Within the umbrella of the Azure SQL platform, there are many deployment options and choices that you need to make to meet your needs. These options give you the flexibility to get and pay for exactly what you need. We'll cover some of the considerations you need to make when you choose various Azure SQL deployment options. We'll also cover some of the technical specifications for each of these options. The deployment options include SQL Server on virtual machines, Azure SQL Managed Instance, Azure SQL Database, Azure SQL Managed Instance pools, and Azure SQL Database elastic database pools.

Although SQL Server versions come out every few years, Platform as a Service or PaaS services allow Microsoft to continually update SQL databases/instances. As new features are developed, some customers are granted access to specific features before they're publicly available through private previews. These new features then become available in public previews. Public previews allow everyone to access new features, but there's typically limited support and often discount pricing.

From the Azure SQL product page:

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.
• Learn more about saving time and money on your 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:

Useful Docs: