what is new in sql azure

What’s New in SQL Azure:

What’s New in SQL Azure Eduardo Castro ecastro@mswindowscr.org http://comunidadwindows.org http://ecastrom.blogspot.com

Agenda :

Agenda SQL Azure Database Overview What’s New? SQL Azure Developer Portal Web-Based Database Administration Tools SQL Azure Data Sync - CTP2 SQL Azure Reporting – Public CTP New Usage Scenarios Roadmap Resources & Getting Started

Windows Azure Platform :

Windows Azure Platform Developer Experience Use existing skills and tools Compute Storage Management Connectivity Access control Flexible APIs Information Marketplace Reporting Relational data Management Data Sync Reporting & BI Billing & Payments Flexible APIs Information Marketplace

Windows Azure Platform :

Windows Azure Platform Developer Experience Use existing skills and tools Source: Chappell & Associates

What’s New In SQL Azure Enhancements:

What’s New In SQL Azure Enhancements SQL Azure Database SQL Azure Reporting CTP Reporting and BI on SQL Azure databases Based on SQL Server Reporting Services SQL Azure Data Sync CTP2 Synchronize SQL Azure databases Synchronize SQL Azure with on-premises SQL Server Windows Azure Platform – Developer Portal Enhanced user experience and reporting Database manager for SQL Azure

SQL Azure Database :

SQL Azure Database - Based on SQL Server 2008 R2 engine Use same tools and data access frameworks Six global datacenters High Availability & Redundancy Reads are completed at the primary Writes are replicated to a quorum of secondaries Replica 1 Replica 2 Replica 3 DB Single Logical Database Multiple Physical Replicas Single Primary Multiple Secondaries

What’s New In SQL Azure Enhancements:

What’s New In SQL Azure Enhancements SQL Azure Database SQL Azure Reporting CTP Reporting and BI on SQL Azure databases Based on SQL Server Reporting Services SQL Azure Data Sync CTP2 Synchronize SQL Azure databases Synchronize SQL Azure with on-premises SQL Server Windows Azure Platform – Developer Portal Enhanced user experience and reporting Database manager for SQL Azure

What’s New In SQL Azure Enhancements:

What’s New In SQL Azure Enhancements SQL Azure Database SQL Azure Reporting CTP Reporting and BI on SQL Azure databases Based on SQL Server Reporting Services SQL Azure Data Sync CTP2 Synchronize SQL Azure databases Synchronize SQL Azure with on-premises SQL Server Windows Azure Platform – Developer Portal Enhanced user experience and reporting Database management

SQL Azure Reporting CTP :

SQL Azure Reporting CTP “Introduction to SQL Azure Reporting” Web Role Reporting Features: Based on SQL Server Reporting Services Interactive and tabular reporting Data visualizations: charts, graphs, mapping, gauges SQL Azure Database data sources Utilizes BI Developer Studio (free) to author reports Export to Excel, PDF, CSV formats Core scenarios: Operational reporting on SQL Azure data Embed reports into Windows Azure or on-premises applications

What’s New In SQL Azure Enhancements:

What’s New In SQL Azure Enhancements SQL Azure Database SQL Azure Reporting CTP Reporting and BI on SQL Azure databases Based on SQL Server Reporting Services SQL Azure Data Sync CTP2 Synchronize SQL Azure databases Synchronize SQL Azure with on-premises SQL Server Windows Azure Platform – Developer Portal Enhanced user experience and reporting Database management

SQL Azure Data Sync CTP2 :

SQL Azure Data Sync CTP2 Elastic Scale Service scales as resources requirements grow No-Code Sync Configuration Easily define data to be synchronized Schedule Sync Choose how often data is synchronized Conflict Handling Handle issues where same data is changed in multiple locations Logging and Monitoring Administration capabilities for tracking data and monitoring potential issues “Introduction to SQL Azure Data Sync” CTP 1 CTP 2

Slide 12:

On Premises Windows Azure Data Sync Service SQL Azure TDS SQL Server Local Agent SQL Server Sync Provider SQL Server Proxy Provider Sync Orchestrator SQL Server Provider Sync Orchestrator HTTPS SQL Azure Data Sync – A Closer Look CTP 2

SQL Azure Data Sync – Example Use Cases:

SQL Azure Data Sync – Example Use Cases Move workloads in stages preserving existing infrastructure Move part of the application and sync its data Meet compliance and regulations Control data synchronized off-premises Enable scale-out read or read/write Multiple synchronized databases for scalability Preserve data – geo replication of data Enable new scenarios Spanning enterprise , cloud and remote offices/retail stores

SQL Azure Data Sync – Roadmap:

SQL Azure Data Sync – Roadmap On-Premises (Headquarters) Sync Sync Remote Offices Data Sync Service For SQL Azure Retail Stores Sync Sync Sync SQL Azure Database Sync Sync Now CTP2 – End of CY10

New SQL Azure Usage Scenarios :

New SQL Azure Usage Scenarios Web Role Reporting Data Sync Fully featured Windows Azure Platform Application

New SQL Azure Usage Scenarios :

New SQL Azure Usage Scenarios Web Role Reporting Data Sync Fully featured Windows Azure Platform Application Data Sync Synchronize multiple on-premises SQL Server databases in different locations Datacenter Corporate Office Branch Office or Retail Geo-replication of data across Windows Azure Platform datacenters Globally available, c loud & on-premises d ata synchronization

Roadmap :

Roadmap Now Visit www.microsoft.com/sqlazure to register for upcoming CTP access 2010 New Windows Azure Developer Portal; Database Manager Limited CTPs of Data Sync CTP2, Reporting CTP Watch for PDC Announcements; visit the SQL Azure blog and website 2011 Backup & Restore SQL Azure Reporting SQL Azure Data Sync

Presentation Sources Resources:

Presentation Sources Resources SQL Azure website: http://www.microsoft.com/sqlazure Blog: http://blogs.msdn.com/sqlazure Dev Center: http://msdn.microsoft.com/windowsazure/sqlazure Frameworks: http://msdn.microsoft.com/data

Slide 19:

© 2009 Microsoft Corporation. All rights reserved. Microsoft, MSDN, the MSDN logo, and [list other trademarks referenced] are trademarks of the Microsoft group of companies. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation.  Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED, OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.