Do you think IIT Guwahati certified course can help you in your career?
No
Introduction
In this blog, we are going to discuss about Azure SQL Server in detail. Using the SQL Server database engine in the Azure cloud, Azure SQL offers a suite of managed, secure, and intelligent offerings. Azure SQL Database provides smart, managed database services with serverless computing to support contemporary cloud applications. Azure SQL Managed Instance delivers nearly 100% feature parity with the SQL Server database engine. This intelligent, fully managed instance as a service will modernize your current SQL Server applications at scale. Best for the majority of cloud migrations. Azure VMs running SQL Server lift and relocate your SQL Server workloads with ease, maintaining full OS-level access and SQL Server compatibility.
Create and manage servers
The Azure portal, the Azure CLI, PowerShell, REST API, and Transact-SQL can be used to set up and administer servers and single databases in Azure SQL Database.
The Azure portal
The resource group for Azure SQL Database can be made either in advance or at the same time as the server.
Create a server
Create a new server resource from the Azure Marketplace to create a server using the Azure portal. The server can also be created when you deploy an Azure SQL Database.
Select the Azure SQL Database to resource from the Azure Marketplace to create a single Azure SQL Database using the Azure portal. The resource group and server can be set up beforehand or concurrently with generating the single database. One has the option to create a sample database based on Adventure Works LT or a blank database.
You can access a server to administer it in a number of ways, such as via the All resources page, the SQL servers page, or a specific database page. Go to the SQL databases page and choose the database you want to administer to manage an existing database. The following screenshot from a database's Overview page demonstrates how to start configuring a server-level firewall for a database.
Use the following PowerShell cmdlets to construct and manage servers, single and pooled databases, and server-level firewalls using Azure PowerShell. Install the Azure PowerShell module to run these commands.
Azure CLI
Use the Azure CLI commands given below to create and manage servers, databases, and firewalls. Azure CLI can be installed on macOS, Linux, or Windows or run in your browser via the Cloud Shell.
Transact-SQL (T-SQL)
Use the following T-SQL commands to construct and administer servers, databases, and firewalls using Transact-SQL. The Azure portal, SQL Server Management Studio, Visual Studio Code, or any other application that can connect to a server in the SQL Database and pass Transact-SQL commands can be used to give these commands. Transact-SQL cannot build or remove a server.
REST API
Use these REST API queries to set up and maintain servers, databases, and firewalls.
Microsoft's cloud services and resources can be accessed and managed through the cloud computing platform and web interface known as Azure.
What is Blob Storage? Can we cache content from publicly available Azure Storage Blobs?
Blob storage in Azure is a service that allows you to store huge amounts of unstructured object data, such as text or binary data. Yes, you can cache content from publicly available storage blobs.
What is waiting time? What is the relation between waiting time and performance?
The waiting time refers to the amount of time it takes for content to be delivered from the CDN to the requesting node. The lesser the waiting time, the better the performance.