Understanding Azure SQL Database security features
Some security features related to Azure SQL Database were mentioned in Chapter 6, Data Security, where we discussed data security. However, there are additional features we can use to increase security.
The first feature and line of defense when it comes to Azure SQL Database is a firewall. This built-in tool, by default, blocks access to the database from any IP address that is not preauthorized (whitelisted). It's important to mention that firewall settings are on the Azure SQL Server level and will be inherited by all databases on the server. If we need to allow a single IP address to access a single database, we may want to reconsider our resource strategy. Allowing an IP address to access a single database will enable access to all databases on the same server. Because of this, we need to consider putting only databases used by the same applications or the same group of users on a single server.
Allowing a new IP address...