Windows Azure–Security essentials
| This post discusses about Security essentials which technical decision maker should know in-order to protect customers applications and data in Windows Azure platform. Instead you building the server racks and datacenters, Cloud takes your traditional data centers from you and run on their premises which greatly reduces the cost and maintenance. Cloud runs as services platform follows the SAS(software as service) model. |  |
Related Posts:
1 commentSQL Azure vs SQL Server
This post discusses the differences between SQL Azure and SQL Server in the context of security
 |
 |
| 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 :
Related Posts:
No commentsCreating Firewall rules using SQL Azure
| The firewall feature in Windows Azure portal allows you to store your data securely on cloud which deny all connections by default. The new firewall feature allows you to specify list of IP addresses which can access your SQL Azure Server.You can also programmatically add connections and retrieve information for SQL Azure database. This post discusses about creating the firewall rule using the Azure portal. |  |
1. Browse the website https://windows.azure.com/ and enter your live account credentials
Related Posts:
No commentsDeploying Database with ASP.NET Web application
| Web applications can be deployed in two different ways one by using one-click publish or by using a Web deployment package. Usually we may want to deploy our database scripts that we used along with the application deployment. This post discusses the procedures to deploy the database along with web application in Visual Studio 2010. |  |
Assume there is no database exist in destination and configure the below steps for first-time database deployment
Related Posts:
1 commentCreating a database in SQL Azure
|
This post discusses about setting up a windows Azure and creating a SQL Azure database. There 3 main steps to create a main database |
 |
Step1: Visit the Windows Azure website and select the suitable offer. For testing and knowing the features there is a introductory offer which is free to use as long as you do not exceed the monthly usage hours. visit here for offer
Related Posts:
No comments
