SQL Database in Azure

Azure SQL Database

Azure SQL Database is a fully managed service, a relational database as a service in the cloud, with mission critical capabilities.

Azure SQL Database is 

a managed relational database service. 

It supports structures such as relational data and 

unstructured formats such as spatial and XML data. 

SQL database provides online transaction processing, 

OLTP, that can scale on demand(scale up and down based on the OLTP systems on-demand)

Benefits for organizations -

Take the advantage of 

Azure security and availability features.

Avoid the risks of 

capital expenditures and of increasing 

operational spending on complex on-premises systems. 

SQL database can be more flexible than on-premises 

SQL server solution because it 

can provision and configure it in minutes and backed up by Azure SLA(Service Level Agreement)

 

SQL database delivers predictable performance 

for multiple resource types, 

service tiers, and compute sizes. 

Requires almost no administration, 

it provides dynamic scalability with no downtime, 

built in intelligent optimization, 

global scalability and availability, 

and advanced security options. 

Focus 

only on rapid app development and on 

speeding up time to market, no need to worry about

 managing 

virtual machines and infrastructure. 

Data Ingestion is possible through programming languages including .Net, 

Python, Java, and Node.js. 

Beyond applications, also ingest via 

Transact-SQL, 

T-SQL techniques or using the benefits of  Azure Data Factory. 

 

Azure SQL Database helps

 application meet security and 

compliance requirements with a range of 

built-in features such as advanced threat protection, 

SQL database auditing, data encryption, 

Azure Active Directory authentication, 

Multi-Factor authentication, 

and compliance certification.