Total Page Preview:   000000004660

Difference between Azure SQL and SQL Server

Difference Between Azure SQL and SQL Server:

Feature Azure SQL SQL Server
Hosting Azure PaaS. On-premises.
Max DB Size 4TB (in P15). Based on SQL Server license.
Licensing Not required. Requires SQL Server license.
Backup and Restore Not Support. Support.
Login Server Authentication. Windows Authentication and Server Authentication .
Azure Cost Based on Database Throughput Units* (DTU’s) consumed. None, it’s on-premises.
Analysis Services, Replication, Reporting Services, or SQL Server Service Broker Not Support. Support
Database Mirroring or Failover Clusteringstrong> Not Support. Support
Switch/Change(use) Database No. Yes
Access Linked Servers No Yes
SQL Profiler Not support Support
  In SQL Azure an idle connection goes down after 5 minutes and can go down for a lot of other reasons than timeout. You need to think about this especially if you use connection pooling. In SQL Server an idle connection almost never goes down. If it does, there is usually a serious error.
Default transaction isolation level READ_COMMITTED_SNAPSHOT. READ_COMMITTED.
SQL Server Agent Not Support . Support
  You cannot write cross-database references in SQL Azure. SQL Server you can combine data from databases in the same instance.



Brijesh Kumar

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn :





Recent Posts

How to get the alternate rows or records from table in sql server
Data Warehouse Three Tier Architecture
SQL Server - Fragmentation on azure sql database
Limitations of Azure SQL Database
PIVOT and UNPIVOT in SQL Server with Example
SQL Server - Find unused indexes on azure SQL database scripts
SQL Server - Find all index with key columns on Azure SQL Database
Find Resource usage in Azure SQL Database using script or T-SQL
How to Set client IP Address using the firewall security in Azure SQL Using Portal
What are the types of User Define Function and difference between a nested UDF and recursive UDF in SQL server?
Top 60 SQL Server Interview Questions Answers for freshers and experienced
Top 16 performance query optimization techniques in SQL Database?
What is a Trigger and type of trigger in SQL server?
How many types of dimension tables available in data warehouse?
Data warehouse Interview Questions Answers for freshers and experienced
What are the differences between OLTP and OLAP?
What is Table Variable? Explain its advantages and disadvantages?
What are the different types of Error Handling in SQL Server?
Cloud Data Engineer SQL Server Interview Questions Answers for freshers and experienced
What are characteristics and advantages of stored procedure?

Facebook User: