SQL Azure Aaron Stanley King 82 INDIANAPOLIS What

  • Slides: 19
Download presentation
SQL Azure Aaron Stanley King #82 INDIANAPOLIS

SQL Azure Aaron Stanley King #82 INDIANAPOLIS

What is SQL Azure? “SQL Azure is a scalable and cost-effective ondemand data storage

What is SQL Azure? “SQL Azure is a scalable and cost-effective ondemand data storage and query processing service. SQL Azure is a hosted application build on robust Microsoft SQL Server database and Windows Server technologies. ”

What is SQL Azure really? SQL Azure is your data hosted by Microsoft with

What is SQL Azure really? SQL Azure is your data hosted by Microsoft with a strong service level agreement (SLA). The SLA not only ensures high availability but also performance and protection.

Azure™ Services Platform: http: //oakleafblogspot. com/2010/11/windows-azure-and-cloud-computing-posts_19. html

Azure™ Services Platform: http: //oakleafblogspot. com/2010/11/windows-azure-and-cloud-computing-posts_19. html

Robust SQL Server Support SQL Azure is built on robust SQL Server database technologies.

Robust SQL Server Support SQL Azure is built on robust SQL Server database technologies. SQL Server is a broad data platform that can handle all types of data, from creation to archival.

Ease of Development • SQL Azure facilitates development. • Just like local development in

Ease of Development • SQL Azure facilitates development. • Just like local development in SQL Express. • Its flexible data model supports any programming language.

Scalability • The SQL Azure database fabric is flexible and scales according to business

Scalability • The SQL Azure database fabric is flexible and scales according to business needs. • The service is supported by multiple servers. • Therefore, it has the ability to provide any required storage capacity. • Also, there is no time delay due to server provisioning.

Availability • Because SQL Azure is accessible via the Internet, it ensures the availability

Availability • Because SQL Azure is accessible via the Internet, it ensures the availability of data to users in any geographic location. • Further, SQL Azure uses enterprise-grade hardware and program code, which are optimized for high throughput.

Security • SQL Azure provides organizations with secure data access and confidentiality. • It

Security • SQL Azure provides organizations with secure data access and confidentiality. • It is built on a relational database architecture that includes data protection. • Multiple copies of data that you create or modify can be stored across geographically distributed data centers.

Simplified Multi-Tenancy • SQL Azure Federations simplify multitenant databases for better cost-pertenant implementations. •

Simplified Multi-Tenancy • SQL Azure Federations simplify multitenant databases for better cost-pertenant implementations. • It’s great for ISVs creating large Saa. S solutions as well as web scale database solutions. • Repartitioning without downtime. • This isn’t production ready yet, still in CTP.

Strong Service Level Agreement SQL Azure provides you with a strong SLA that assures:

Strong Service Level Agreement SQL Azure provides you with a strong SLA that assures: • high availability • guaranteed performance • data protection • compliance • enterprise-level security features • real-time mirrored database replication

Benefits of SQL Azure • • Robust SQL Server support Ease of application development

Benefits of SQL Azure • • Robust SQL Server support Ease of application development Scalability Availability Security Simplified Multi-Tenancy Strong SLA

Features of SQL Azure • SQL Azure provides UNLIMITED data storage capacity. • SQL

Features of SQL Azure • SQL Azure provides UNLIMITED data storage capacity. • SQL Azure uses a PAY-AS-YOU-GROW pricing strategy. • SQL Azure has $0 start up cost. • SQL Azure can be located close to your users, even if you’re not.

SQL Azure vs. SQL Server SQL Azure • Anytime from Any place • Failure

SQL Azure vs. SQL Server SQL Azure • Anytime from Any place • Failure of one server will not impact performance • Unlimited amount of data SQL Server • On-premise data platform • Single point of failure • Data is restricted by software and hardware

Things to watch out for • • • Need clustered index for each table

Things to watch out for • • • Need clustered index for each table ‘ANSI_NULLS’ is not a recognized SET option. SET ANSI_PADDING OFF More than two-part column name Data types: text ntext xml image Table hint without WITH Filegroup reference and partitioning scheme’ is not supported in this version of SQL Server fn_listextendedproperty is not supported

Pricing • Web Edition: • Up to 1 GB relational database = $9. 99

Pricing • Web Edition: • Up to 1 GB relational database = $9. 99 / month • Up to 5 GB relational database = $49. 95 / month • Business Edition: • Up to 10 GB relational database = $99. 99 / month • Up to 20 GB relational database = $199. 98 / month • Up to 30 GB relational database = $299. 97 / month • Up to 40 GB relational database = $399. 96 / month • Up to 50 GB relational database = $499. 95 / month Data transfers = $0. 10 in / $0. 15 out / GB - ($0. 30 in / $0. 45 out / GB in Asia)

Demos, Demos! • How to query in SQL Azure • More Demos!

Demos, Demos! • How to query in SQL Azure • More Demos!

Recent News! • SQL Azure Diagnostics Tool • SQL Reporting CTP • SQL Azure

Recent News! • SQL Azure Diagnostics Tool • SQL Reporting CTP • SQL Azure Federation CTP

SQL Saturday #82 Indianapolis SQL Azure Aaron Stanley King (@trendoid) http: //www. aaronstanleyking. com

SQL Saturday #82 Indianapolis SQL Azure Aaron Stanley King (@trendoid) http: //www. aaronstanleyking. com