sql azure sql saturday nyc

Presented by: Aaron Stanley King

Benefits of SQL Azure Features of SQL Azure Demos, Demos, Demos! How to query in SQL Azure More Demos! Recent News SQL Azure Future Questions and Answers

Our Goals for TodayOur Goals for Today

“SQL Azure is a scalable and cost-effective on-demand 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?What is SQL Azure?

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.

What is SQL Azure really?What is SQL Azure really?

Azure™ Services Platform:Azure™ Services Platform:

http://oakleafblog.blogspot.com/2010/11/windows-azure-and-cloud-computing-posts_19.html

Benefits of SQL AzureBenefits of SQL Azure

Robust SQL Server SupportRobust 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.

SQL Azure facilitates development. Just like local development in SQL Express.

Its flexible data model supports any

programming language.

Ease of Application Ease of Application DevelopmentDevelopment

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.

ScalabilityScalability

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.

AvailabilityAvailability

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.

SecuritySecurity

SQL Azure provides you with a strong SLA that assures:high availabilityguaranteed performancedata protectioncomplianceenterprise-level security featuresreal-time mirrored database replication

Strong Service Level Strong Service Level AgreementAgreement

Robust SQL Server support Ease of application development Scalability Availability Security Strong SLA

Benefits of SQL AzureBenefits of SQL Azure

Benefits of SQL Azure Features of SQL Azure Demos, Demos, Demos! How to query in SQL Azure More Demos! Recent News SQL Azure Future Questions and Answers

Our Goals for TodayOur Goals for Today

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.

Features of SQL AzureFeatures of SQL Azure

SQL AzureAnytime from Any placeFailure of one server will not impact performanceUnlimited amount of data

SQL ServerOn-premise data platformSingle point of failureData is restricted by software and hardware

SQL Azure vs. SQL ServerSQL Azure vs. SQL Server

Benefits of SQL Azure Features of SQL Azure Demos, Demos, Demos! How to query in SQL Azure More Demos! Recent News SQL Azure Future Questions and Answers

Our Goals for TodayOur Goals for Today

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

Demos, Demos, Demos!Demos, Demos, Demos!

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

Things to watch out forThings to watch out for

Benefits of SQL Azure Features of SQL Azure Demos, Demos, Demos! How to query in SQL Azure More Demos! Recent News SQL Azure Future Questions and Answers

Our Goals for TodayOur Goals for Today

Production Level App Fabric 50 Gb SQL Azure! hierarchyid Data Sync oData Hudson Database Copy, kinda cool, will get

better.

Recent News!Recent News!

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)

PricingPricing

SQL Azure Future?SQL Azure Future?

Reference Data

Reporting

ETLData Mining

Thank you!Questions or comments?

http://www.aaronstanleyking.com

aaron@woundvision.com

@trendoid