December 29, 2009 at 12:29 am
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...
December 29, 2009 at 1:00 pm
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