Are you interested in learning some basic to advanced things about Azure SQL Database?
Here on this page, you will find in-depth, step-by-step tutorials on Azure SQL Database, often accompanied by a video tutorial.
Getting Started With Azure SQL Database
In this section, learn an introduction to Azure SQL Database.
| Name | Description |
| Azure SQL Database Tutorial | Learn What Azure SQL Database is, its features, history, flavors, Advantages, etc. |
| Azure SQL Database managed instance Tutorial | Learn what is Azure SQL Database managed instance, its features, service tiers, authentication options, Limitations, etc. |
| Azure SQL Edge | Check out What Is Azure SQL Edge, its features, Azure SQL Edge editions, deployment models, Azure SQL Edge pricing, and How to create and deploy Azure SQL edge using Azure Portal. |
| Azure SQL Database service tiers | Learn different Azure SQL database pricing tiers and how to Choose the Right Service Tier for you. |
| Azure SQL Database Pricing | Check out the details of how much Azure SQL Database Costs if you wish to use it. |
| Azure SQL Database Serverless | Learn Azure SQL Database Serverless feature that can help you to save a lot when the database is not in use. |
| Azure SQL Database Limitations | Check out the lists of Azure SQL limitations. |
Create Azure SQL Database
Assuming you know about Azure SQL Database from the above section, Let’s create different types of Azure SQL Databases.
| Name | Description |
| Create Azure SQL database | Learn how to create an Azure SQL Database using Azure Portal and PowerShell with a step-by-step Video tutorial. |
| Create SQL-managed instance in Azure. | Check out the steps to Create an SQL-managed instance in Azure using Azure Portal. |
How to connect Azure SQL Database
Let’s learn to connect to the Azure SQL database to perform some activity.
| Name | Description |
| Connect To Azure SQL Database | Learn how To Connect To Azure SQL Database from SSMS, Visual Studio, using ADO.Net, how to connect Programmatically using C#, etc. |
| Connect Power BI to Azure SQL database. | Check out the quick steps to connect Power BI to Azure SQL. |
Backup and Restore Azure SQL Database
Let us learn how to back up and restore the SQL Azure database.
| Name | Description |
| Backup Azure SQL database | Learn the quick steps to backup the Azure SQL database locally, and backup Azure SQL database to blob storage. using SSMS, Azure Portal, SQL script, etc. |
| Replicate Azure SQL Database to Local | Check the quick steps to replicate Azure SQL Database to Local using SSMS. |
| Export Azure SQL Database | Learn how to export data from Azure SQL database using SSMS, Azure Portal, PowerShell, SQLPackage utility, etc. |
Deploy SQL Database to Azure
Let’s discuss how to deploy an SQL database to Azure.
| Name | Description |
| Deploy SQL Database To Azure | Learn the quick steps to deploy SQL database to Azure using ssms. |
| Upload SQL Database To Azure | Check out the quick steps to restore the Azure SQL database using Azure Portal, Azure CLI, and PowerShell. |
| Revert SQL Azure Database | Check out the quick steps to restore Azure SQL database using Azure Portal, Azure CLI, and PowerShell. |
Let us perform some operations in our Azure SQL Database
| Name | Description |
| Rename Azure SQL database | Learn how to change user passwords in Azure SQL database, including User ID using Azure Portal, Azure CLI, PowerShell, etc |
| Create table in Azure SQL database | Check out the quick steps to create a table in the Azure SQL database using SSMS. |
| Change Azure SQL Pricing Tier using SQL Query & Azure Portal | Learn how to change or modify the Azure SQL pricing tier of your existing Azure SQL database using Azure Portal and SQL Query. |
| Change User Id And Password For Azure SQL Server Database | Learn how to change user passwords in Azure SQL database, including User ID using Azure Portal, Azure CLI, PowerShell, etc. |
| Azure SQL Database Auditing | Learn how to change user password in Azure SQL database, including User ID using Azure Portal, Azure CLI, PowerShell, etc. |
| Azure SQL database connection string | Learn Azure SQL database connection string and how to get it using Azure Portal. |
| Azure SQL Database IP Address | Learn how to get Azure SQL Database IP Address using Azure Portal. |
How is Azure SQL different from others?
| Name | Description |
| Azure SQL Edge VS SQL Server | Learn the key differences between Azure SQL Edge and SQL Server. |
| Azure SQL Database Vs. SQL Server | Learn the difference between sql server and Azure SQL database |
| Set an Azure Active Directory user or group as an Azure SQL Administrator. | Learn to set up an Azure Active Directory user or group as an Azure SQL Database administrator using Azure Portal. |
| DMV Collector In Azure SQL Database | Learn what is DMV collector service in Azure SQL database. |
Azure SQL PowerShell Commands
Let’s discuss a few key lists of Powershell Commands in Azure SQL
| Name | Description |
| Get-AzSqlServer | Get-AzSqlServer can help you get your Azure SQL Database server details. Learn the syntax and how to use this command with multiple examples. |
| Set-AzSqlServer | Set-AzSqlServer can help you modify your Azure SQL Database server. Learn the syntax and how to use this particular command with multiple examples. |
| Get-AzSqlDatabase | Get-AzSqlDatabase can help you get your Azure SQL Database details. Learn the syntax and usage of this command with certain examples. |
How to stop SQL database in Azure
Let us discuss how to stop your Azure SQL data while not in use so that you can save a lot.
| Name | Description |
| Stop Azure SQL Database | Learn to stop your Azure SQL database using Azure Portal and Azure CLI. |
Azure SQL Errors and Solutions
Let’s learn a few key Azure SQL database errors and the solutions you might encounter while working with Azure SQL.
| Name | Description |
| Cannot Open Server Requested By The Login Azure SQL | Learn the easy steps to fix the error Cannot Open Server Requested By The Login Azure SQL. |
| An error happened while reading data from the provider: While connecting to Azure SQL Database from Power BI | Check out the quick steps to fix the error “An error happened while reading data from the provider: While connecting to Azure SQL Database from Power BI”. |
| The Server Was Not Found Or Was Not Accessible | Learn how to fix the error “The Server Was Not Found Or Was Not Accessible”. |
Conclusion
We discussed working with Azure SQL Database in this comprehensive Azure SQL tutorial from the basic to the advanced level.
We started with an introduction to Azure SQL, Service tier, Pricing, Limitations, Different types of Azure SQL Database, and then how to create and deploy Azure SQL with complete steps, required screenshots, and Video tutorials for a better understanding.
Then we discussed backup Azure SQL, Azure SQL PowerShell Commands, comparison with Azure SQL, and How to stop Azure SQL to save cost.
We discussed potential errors and warnings and the solutions related to Azure SQL Database to ensure you are good to go with Azure SQL. Thanks for taking the time to read this article !!!