SQL Azure

  • 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[/url].

    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/[/url]

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply