Differences between SQL Server and Azure SQL Server
Following main points of SQL Server for which we don't have to take the responsibility:
Max Server Memory Settings
Max Worker Thread
Sizing data files
Setting up Tempdb
Backup and Restore Setup
Applying CU update and Patches
Basic features, Benefits and Drawbacks in comparison to SQL Server
1. The service provides a database engine
No Reporting Service, No Integration Service or No Analysis Service.
2. You can't restore a SQL Server backup directly to Azure SQL Database.
But can use import a .bacpac file, use migration tools or use SQL Server replication to restore a SQL Server database to Azure SQL database.
3. The Azure SQL Service provides its own High Availability, No Log shipping or No Database Mirroring or No Failover Cluster or No Availability Groups.
4. Linked Servers are replaced by External Table features.
5. Replication is limited to Subscriber for an Azure SQL Database.
6. There is no Error log file to open but System log viewer.
7. Database mail or Service Broker messaging are not available.
8. To track performance counter use System view that tracks the resource consumption level.
9. There's no SQL Agent Service.
10. The alerting capabilities are handled by Azure Metrics Alerts.
From Security point of view
Azure SQL Database has security feature that are new or different compared to SQL Server:
1. Transparent Data Encryption (TDE) is an Enterprise feature on SQL Server, available in all tiers on Azure SQL Database.
2. Auditing is another Enterprise feature available in all tiers of Azure SQL Database.
3. Coupled with auditing, Azure also has a threat detection service that can alert you if it detects SQL injection attempts, logins from new locations or other unusual patterns.
In Next Post, lets have a look at Azure SQL Server and compare with SQL Server.
No comments:
Post a Comment