SQL Azure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Cloud Computing » SQL Azure - Administration » SQL Azure

SQL Azure

Rate Topic

Display Mode

Topic Options

Author

Message

Dugi

Posted Tuesday, December 29, 2009 12:29 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 1:48 AM
Points: 1,252, Visits: 3,367

Microsoft SQL Azure Database is a cloud-based relational database service built on SQL Server technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. High availability and fault tolerance is built-in and no physical administration is required. SQL Azure Database supports T-SQL.

SQL Azure Database Features:

Relational Database Management Services (RDBMS)

-Creating, accessing and manipulating 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.

Benefits

-No need to install or patch software or other physical administration.
-Automatic high availability and fault tolerance.
-Simple provisioning and deployment of multiple databases.
-Scale databases up or down based on business needs.
-Multi-tenant.
-Integration with SQL Server and tooling including Visual Studio.
-Support for T-SQL based familiar relational database model.

--------------------------------------------------------------------------------

There is the article from Jacob Sebastian Getting started with SQL Azure.
Also you can search the SSC forum for all SQL Azure posts, articles etc!

Have a nice SQLAzuring...

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #839714

Ryan D.

Posted Tuesday, December 29, 2009 1:00 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 13, 2013 1:57 PM
Points: 92, Visits: 1,281

Interesting article, so from a DBA vantage point, how are our roles likely to change?
Regarding administration of an application, how database creation, modification handled?
Is there a central point of contact to get things done in Azure or is that something specifically for each company's policies.

Post #840026

« Prev Topic | Next Topic »

Permissions