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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy