TechBubbles Microsoft Technology BLOG

SQL Azure vs SQL Server

 

This post discusses the differences between SQL Azure and SQL Server in the context of security

                              

image image
Supports SQL(native) and Windows authentication. Supports SQL(native) only, no windows authentication.
Authorization is based on database users and roles. Authorization is based on database users and roles.
SQL Server has fixed server roles such as serveradmin, securityadmin and dbcreator. There are no fixed server roles such as in sql server but it has loginmanager and dbmanager roles in Master DB to simulate  relevant server roles.
Accessing SQL Server over wire is via Tabular Data Stream (TDS) plus SSL on port TCP 1433. Using SSL is optional. Accessing SQL Azure over wire is same as SQL server using TDS but SSL is mandatory
Firewall and IP blocking is using hosted firewall. SQL Azure has built-in firewall which blocks all external IP’s until you specify to allow.
SQL Server supports native encryption at page level using transparent data current. TDC SQL Azure does not supports the native encryption.
   

More detailed comparison can be found here

Share this post :

About the author

Kalyan Bandarupalli

My name is kalyan, I am a software architect and builds the applications using Microsoft .NET technologies. Here I am trying to share what I feel and what I think with whoever comes along wandering to Internet home of mine.I hope that this page and its contents will speak for me and that is the reason I am not going to say anything specially about my self here.

Add Comment

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud