SQL Azure
TAK! jest SQL Server w chmurze… dzięki niemu niebieska chmura umożliwia składowanie czegoś więcej niż tylko prostych blobów/pojedynczych tabel. Póki co tylko jako engine relacyjny (SQL Azure Database) ale zarówno RS jak i AS są ostro rozwijane. To co teraz można przeczytać na stronach SQL Azure skróciłem trochę i wrzuciłem poniżej, oczywiście jeśli ktoś potrzebuje więcej informacji znajdzie je witrynie projektu ;-)
“Microsoft® SQL Azure Database is a cloud-based relational database platform built on SQL Server® technologies. With SQL Azure Database, you can easily provision and deploy relational database solutions to the cloud, and take advantage of a globally distributed data center that provides enterprise-class availability, scalability, and security with the benefits of built-in data protection, self-healing and disaster recovery.
SQL Azure features:
- Creating, accessing and manipulating tables, views, indexes, roles, stored procedures, triggers, and functions
- Insert, Update and Delete
- Constraints
- Transactions
- Temp tables
- Query support
- Basic functions (aggregates, math, string, date/time)
- A subset of the existing SQL Server builtin stored procedures and system views
- All non-deprecated SQL Server 2008 data types except spatial data types
- Support for running SQL configuration scripts via SQLCMD and SQL Query Analyzer from within SQL Server Management Studio
- Support for Visual Studio and SQL Server Management Studio
- Support for SQL Server Management Studio, SQL Server Powershell and programmatic access via SQL Server Management Objects (SMO)
- Support for friction free provisioning of Logical Servers and Databases through the SQL Data Services account portal
- SDS supports the SQL authentication model
- User authenticated by standard SQL logins
- Login map to user inside the database
- Current SQL USER and ROLE mechanisms continue to work with the database. GRANT/DENY/REVOKE permissions of SQL objects to USER/ROLE
- Redundant copies of user databases for fast failover and high availability in case of failures
- Automatic load balancing for optimal resource utilization and performance
- Scale out with multiple databases and partition-aware application
- Automatic system backup for data protection
- A subset of existing SQL manageability facilities will be available
What is the difference between Windows Azure Storage Service and SQL Azure Database?
Windows Azure Storage Service is designed to be the lowest cost, most efficient solution for large scale data storage and retrieval in the cloud. It can store blobs, queues, and simple tables (non-relational). SQL Azure is designed to bring the power of relational databases into the cloud and will provide rich querying over tables.
How will SQL Azure roadmap evolve to support larger and more complex apps?
In its initial release, SQL Azure Database will support relational capabilities suitable for relational apps, including multi-tenant apps requiring large levels of scale. Future releases of SQL Azure will support advanced features like distributed queries across partitions, and auto-partition.
How does Microsoft differentiate SQL Azure from SQL Server?
SQL Azure is built on SQL Server database technologies that are used for running mission-critical applications in the enterprise as well as on the Web. Since SQL Server is a broad data platform that can handle all data types from birth to archival, there are many associated capabilities that our data platform provides. SQL Azure is exposing a large subset of these relational capabilities and extending them as services in the cloud.
These services feature built-in high scale, availability, and self-management, and are provided in a way that makes it easy for customers and partners to consume over the Internet. Although SQL Azure in its first iteration exposes only the core RDBMS capabilities of what is in the full SQL Server data platform, Microsoft expects this to increase over time, with likely future features including Reporting, Analytics, ETL and other premium services etc. SQL Server and SQL Azure share some technologies and will share some innovations bilaterally.
How is SQL Azure Database different from a dedicated hosted database in Cloud?
SQL Azure Database is a highly available, scalable, distributed database service hosted by Microsoft in the cloud. SQL Azure Database enables easy provisioning and deployment of relational database services. Developers do not have to install, setup, patch or manage any software. HA, backup and recovery, geo-distribution and disaster recovery will be built-in. With a dedicated hosted database, developers and IT Pros are still responsible for installing, setting up, updating and patching OS and database software. Additionally, hosted database solutions have to device HA, scaling out and disaster recovery solutions thus increasing total cost of administration.
SQL Azure customers will have connectivity between the database and our Internet gateway. SQL Azure will maintain a “Monthly Availability” of 99.9% during a calendar month. “Monthly Availability Percentage” for a specific customer database is the ratio of the time the database was available to customer to the total time in a month. Time is measured in 5-minute intervals in a 30-day monthly cycle. Availability is always calculated for a full month. An interval is marked as unavailable if the customer’s attempts to connect to a database are rejected by the SQL Azure gateway.
In which countries is the Windows Azure platform commercially available? In what time frame?
At commercial launch, Australia, Austria, Belgium, Canada, Denmark, Finland, France, Germany, Ireland, India, Italy, Japan, Netherlands, New Zealand, Norway, Portugal, Spain, Sweden, Switzerland, UK, and the United States. Israel is currently being evaluated for commercial availability at PDC
In the March 2010 timeframe we expect commercial availability to expand to Brazil, Chile, Colombia, Czech Republic, Greece, Hong Kong, Hungary, Israel, South Korea, Malaysia, Mexico, Poland, Puerto Rico, Romania, Singapore, and Taiwan.
What is the pricing model for the Windows Azure platform?
The Windows Azure platform will have Consumption-based pricing when they become commercially available. The details are as follows:
Windows Azure:
- Compute = $0.12 / hour
- Storage = $0.15 / GB stored / month
- Storage Transactions = $0.01 / 10K
- Bandwidth = $0.10 in / $0.15 out / GB
SQL Azure:
- Web Edition – Up to 1 GB relational database = $9.99 / month
- Business Edition – Up to 10 GB relational database = $99.99 / month
- Bandwidth = $0.10 in / $0.15 out / GB
.NET Services:
- Messages = $0.15 / 100K message operations , including Service Bus messages and Access Control tokens
- Bandwidth = $0.10 in / $0.15 out / GB
Windows Azure compute hours are charged only for when your application is deployed. When developing and testing your application, developers will want to remove the compute instances that are not being used to minimize compute hour billing.
Storage is metered in units of average daily amount of data stored (in GB) over a monthly period. E.g. if a user uploaded 30GB of data and stored it on Windows Azure for a day, her monthly billed storage would be 1 GB. If the same user uploaded 30GB of data and stored it on Windows Azure for an entire billing period, her monthly billed storage would be 30GB. Storage is also metered in terms of storage transactions used to add, update, read and delete storage data. These are billed at a rate of $0.01 for 10,000 (10k) transaction requests.
The SQL Azure Web Edition DB includes:
- Up to 1 GB of T-SQL based relational database
- Self-managed DB, auto high availability and backup
- Auto Scale with pay-as-you grow
- Best suited for Web application, Departmental custom apps
The SQL Azure Business Edition DB includes
- Up to 10 GB of T-SQL based relational database
- Self-managed DB, auto high availability and backup
- Auto Scale, Pay-as- you grow
- Additional features in the future like auto-partition, CLR, fanouts etc.
- Best suited for ISVs packaged LOB apps, Department custom apps
The SQL Azure Web Edition DB includes:
- Up to 1 GB of T-SQL based relational database
- Self-managed DB, auto high availability and backup
- Auto Scale with pay-as-you grow
- Best suited for Web application, Departmental custom apps
The SQL Azure Business Edition DB includes
- Up to 10 GB of T-SQL based relational database
- Self-managed DB, auto high availability and backup
- Auto Scale, Pay-as- you grow
- Additional features in the future like auto-partition, CLR, fanouts etc.
- Best suited for ISVs packaged LOB apps, Department custom apps
Comments are closed.