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 afore mentioned capabilities, so your instance is secured and immune to most threats.
Security
Firewall
When browsing your SQL Database, you probably noticed the Set server firewall button that is available on the Overview blade:
This is the easiest way to set a firewall rule that allows traffic to Azure SQL.
In Azure SQL, initially all traffic is rejected—you have to whitelist all IPs of computers...