SQL Azure Aaron Stanley King 82 INDIANAPOLIS What
- Slides: 19
SQL Azure Aaron Stanley King #82 INDIANAPOLIS
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 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
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 SQL Express. • Its flexible data model supports any programming language.
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 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 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. • 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: • 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 Scalability Availability Security Simplified Multi-Tenancy Strong SLA
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 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 ‘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 / 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!
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
- Pertenant
- Csp azure plan
- Using r in azure
- Sql azure reporting
- Azure sql dtu limits
- Azure sql database benchmark
- Azure sql data warehouse loading patterns and strategies
- Azure sql sla
- Azure cosmos db: sql api deep dive online courses
- Xmltocursor
- Azure sql database scaling
- Sys.dm_pdw_exec_requests
- Azue sql server stretch monitoring
- Azure log analytics sla
- Azure database security
- Sql threat protection
- Azure sql analytics
- Mpp architecture azure
- Scaling sql server
- Microsoft sql server raspberry pi