Security features of Azure SQL

When it comes to Azure SQL features, there are multiple different options you can use to make your solution secure. Things such as firewalls, full operation auditing, and data encryption are the common capabilities of this service and are available even for the Basic tier. In this section, we will focus on learning the aforementioned capabilities so that your instance is secured and immune to most threats.

Firewall

When browsing your SQL database, you probably noticed the Set server firewall button that is available on the Overview blade, as shown here:

Figure 17.17 – Set server firewall button available on Overview blade of SQL database

This is the easiest way to set a firewall rule that allows traffic to Azure SQL.

Note

In Azure SQL, all traffic is initially rejected—you must whitelist all Internet Protocol addresses (IPs) of computers that should...