Thursday, May 26, 2011

The Next Generation Cloud Database

Microsoft SQL Azure
SQL Azure is a highly available, and scalable cloud database service built on SQL Server technologies. With SQL Azure, developers do not have to install, setup, patch or manage any software. High availability and fault tolerance is built-in and no physical administration is required. Additionally, developers can get productive on SQL Azure quickly by using the same familiar T-SQL based relational model and the same powerful development and management tools used for on-premises databases.

Use SQL Azure Database to:

·         Extend business opportunities and reach new markets by building Software-as-a-Service (SaaS) applications quickly and efficiently
·         Build custom enterprise and web applications that benefit from scale-out database capabilities
·         Extend reach of data assets and consolidate data sources in the cloud to facilitate greater collaboration between partners, branch offices, remote workers and mobile devices
·         Streamline resources by consolidating existing departmental databases in the cloud and quickly provision new databases
·         Develop solutions that provide new insight into business performance and processes by integrating multiple data sources with existing analysis tools

Top Benefits of SQL Azure

·         No physical administration required – software installation and patching is included, as this is a platform as a service (PAAS)
·         High availability and fault tolerance are built in
·         Simple provisioning and deployment of multiple databases
·         Scale databases up or down based on business needs
·         Multitenant
·         Integration with SQL Server and tooling including Visual Studio®
·         Support for T-SQL-based familiar relational database model
·         Option for pay-as-you-go pricing

Top Features

Relational Database Management Services (RDBMS)
·         Create, access, and manipulate tables, views, indexes, roles, stored procedures, triggers, and functions
·         Execute complex queries and joins across multiple tables
·         Insert, Update, and Delete
·         Constraints
·         Transactions
·         Temp tables
·         Basic functions (aggregates, math, string, date/time)
·         A subset of the existing SQL Server built-in stored procedures and system views
·         Support for tracking billable metrics in real time and for historical analysis
·         Managed ADO.NET data access
·         Native ODBC
·         Support for PHP
·         JDBC Support
·         Provision logical servers and databases through the SQL Azure Database account portal, which includes a lightweight web-based database manager.
·         SQL Server Management Studio: an integrated environment with graphics tools for accessing and configuring SQL Server and SQL Azure databases: 32-bit | 64 bit
·         Visual Studio 2010 supports building applications with data connections to SQL Azure, enabling developers to design queries, manipulate data and perform data binding operations in their applications from the Visual Studio environment.
·         In addition to the above, a number of tools support SQL Azure for activities such as moving and migrating data, as well as command line deployment and administration.