![azure sql server azure sql server](https://i0.wp.com/msandbu.org/wp-content/uploads/2021/01/azuresql.png)
This analyzes the queries that are executed by Azure SQL Database and determines if something needs to happen to increase performance. You can use this to make sure that your application keeps running if one region fails, and to make your application more performant across geographic regions.Īutomatic tuning. You can create as many geo-replicas as you want, but you will always have just one databases that you can write to. This replication happens live and has a maximum lag of 5 minutes, but is much faster in practice. This enables you to replicate your complete database to a database in another geographic region. This is a great feature for using production data in your test or even development environment. The data itself doesn’t change, but is obfuscated when it is retrieved by users that aren’t allowed to see it. This enables you to mask sensitive data, like credit card numbers, for certain users, on the fly. Here are some of them:ĭynamic data masking. Even with these differences, I always go for Azure SQL instead of on-premises SQL Server where I can, because Azure SQL is fully managed and easily scalable.Īdditionally, Azure SQL Database offers a lot of intelligent features. As an example, you can’t use EXECUTE AS LOGIN in Azure SQL. There are also some differences in supported T-SQL statements. For instance, Azure SQL doesn’t have a SQL agent running, as there are other services in Azure that you can use for that, like Azure Data Factory. Īzure SQL can almost do anything that on-premises SQL Server can do, with a few exceptions. T hese benefits are some of the reasons why running your app in the cloud is incredibly beneficial. You also don’t have to worry about SQL Server licenses, that is all included in the Azure SQL pricing. And because it runs in the cloud, you don’t have to worry about maintaining any infrastructure, tweaking database files, or patching operating systems. Azure SQL Database is SQL Server in the cloud.