Azure SQL Database connections are encrypted using TLS/SSL for the Tabular Data Stream (TDS) transfer of data. When connection with Latest version of ADO.Net (4.6), JDBC (4.2) Azure SQL Database V12 now supports the strongest version for the TLS (Transport Layer Security) 1.2 Connections.
Support for ODBC on Linux, PHP and node.js coming soon.
Microsoft provides as a valid certificate for the TLS connection for Azure SQL Database. We can implement increased security and eliminate the possibility of “man-on-the-middle” attacks, by implementing below changes to each the different drivers.
On below connection String Setting Encrypt=True will assure that the client is using a connection that is encrypted. Setting TrustServerCertificate=False ensures that the client will verify the certificate before accepting the connection.
SQL Skills 