Techbubbles

Posts Tagged ‘SQL Azure’

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 […]

SQL 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 […]

Deploying 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 […]

Creating 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 […]