It is a relational database service which supports structures like spatial, XML and JSON in Azure. Dynamic scalable performance is delivered by SQL database and option such as column store indexes is provided for analytic analysis at the extreme level and reporting. Also, in-memory OLTP for transaction processing. SQL codes get seamlessly patched and updated and underlying infrastructure is managed by Microsoft.
The code base of SQL Database is shared with Microsoft SQL Server database engine. The latest capabilities of SQL server is first gets released to SQL Database and then to SQL server itself due to Microsoft cloud-first strategy. Due to this, you get the latest SQL server capability without any need for upgrading and patching.
At multiple service levels, a predictable performance is delivered by SQL Database due to which dynamic scalability is provided with no downtime. Also, we get global scalability and availability, intelligent optimization which is built-in and advanced security option. Due to this you get focused on rapid app development and accelerate marketing time. 38 data centers around the world hold SQL Database currently.
Pools and performance scalability:
The database is not connected to each other and portable, each with its own service tier with a performance level which is guaranteed. Different level of performance for different needs is provided by SQL Database. For maximum use of resources and save money, databases can be pooled.
Automated backups - Every event in the database is automatically backup.
Point in time restores - You can recover any data at any given time.
Geo-replication - You can configure 4 reliable secondary databases at any global data center of Azure.
You can reduce the cost of running and manage the database and enhance security and performance of the application using built-in intelligence. You get, Performance is monitored automatically and tuned.
- Query processing is adaptive.
- Improved detection of threat.
Security and compliance:
Built-in security and compliance features are provided with SQL Database. You can do,
- Auditing for security and compliance
- Encrypting data at rest
- Encrypting data in motion
- Masking data dynamically
- Row-level assurance of security
- Multi-factor authentication with Azure Active Directory
- Compliance certification
How to create a VM instance in Azure
In this Tutorial we are going to launch a Virtual Machine in azure.
How to install WordPress on VM instance in Azure
Before you start installing WordPress on VM instance on Azure. You must log in into the machine. You can launch a VM Instance in Azure using this tutorial. After launch of machine log in into the machine using SSH. If you do not know how to SSH in VM instance you can follow this tutorial.
How to launch a VM instances in Google Cloud
In this tutorial we are going to launch a Compute Egine instance.
How to install WordPress on VM instance in Google Cloud
Before you start installing WordPress on VM instance on Google Cloud. You must log in into the machine. You can launch a VM Instance on Google Cloud using this tutorial. After launch of machine log in into the machine using SSH. If you do not know how to SSH in VM instance you can follow this tutorial.
How To Launch EC2 Machine
In this article we are going to learn how to launch a EC2 instance. For this you need to have AWS account.
How to install WordPress on ec2 machine
Before you start installing WordPress on ec2 machine. You must log in into the machine.