1 / 30

Forthcoming SQL Azure Services: SQL Azure Data Sync & SQL Azure Reporting

Forthcoming SQL Azure Services: SQL Azure Data Sync & SQL Azure Reporting. Mark Scurrell Lead Program Manager Microsoft. Agenda. Windows Azure Platform Overview SQL Azure Data Sync SQL Azure Reporting Roadmap Quick poll. Cloud Services. INFRASTRUCTURE. PLATFORM. SOFTWARE. CUSTOMER &

unity-palmer
Download Presentation

Forthcoming SQL Azure Services: SQL Azure Data Sync & SQL Azure Reporting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Forthcoming SQL Azure Services:SQL Azure Data Sync & SQL Azure Reporting Mark Scurrell Lead Program Manager Microsoft

  2. Agenda • Windows Azure Platform Overview • SQL Azure Data Sync • SQL Azure Reporting • Roadmap • Quick poll

  3. Cloud Services INFRASTRUCTURE PLATFORM SOFTWARE CUSTOMER & PARTNER APPS AS A SERVICE AS A SERVICE AS A SERVICE Microsoft Online Services

  4. Windows Azure Platform • General Purpose Programing Languages • Windows Azure Platform App Fabric Compute Management Relational database Data Sync Storage CDN Marketplace

  5. SQL Azure Data Sync

  6. SQL Azure Data Sync Scenarios On-Premises Cloud HQ Sync Sync SQL Azure Data Sync Sync Branch Offices SQL Azure Database Sync Sync Sync Sync Sync Retail Stores Sync

  7. Import/Export or Sync? Scenarios Tools One-Off • BCP • SSMS Generate script wizard • SQL Server Import& Export Data • SSIS • SQL Azure Database Copy • SQL Azure Migration Wizard • DAC • DAC Logical Import/Export • Migration to/from SQL Server • Transfer between SQL Azure servers/databases All Data On-Going • Publish to cloud • Share between on-prem and cloud apps • Some SQL Azure scale-out cases • Geo-locality of data • One-way or two-way Deltas • SQL Azure Data Sync • Sync Framework

  8. Sync On-Premises with the Cloud Share with Cloud: • Two-way Publish to Cloud: • One-way upload Share with & via Cloud: • Upload and download from multiple locations • Branch/retail office Aggregation / Consolidation: • Multiple one-way uploads Share with Clouds: • One or Two-way • Same or different data centers

  9. Sync within the Cloud • Read scale-out via multiple copies: • E.g. reporting • E.g. web site reference data • Read/write scale-out via multiple copies: • E.g. geo-located web applications – data and applications close to users • Same or different data centers

  10. SQL Azure Data Sync

  11. SQL Azure Data Sync Components Service Data E.g. Configuration, Logs & Diagnostics Win Azure Tables Win Azure Blob Admin UI Windows Azure SQL Azure Data Sync SQL Azure Sync Agent HTTPS Sync Framework User Databases + Change Tracking + Sync meta-data User Databases + Change Tracking + Sync meta-data

  12. SQL Azure Data Sync – Behavior & Overhead • Sync Provisioning: • Change tracking via triggers and side-tables • Minimal DML overhead • No change to user tables • Stored procs and meta-data tables • Snapshot isolation enabled for SQL Server database • Batching: • Data change split into batches for transfer • Transactional Consistency: • Batches split into transactions to apply • PK/FK ordering preserved • Transaction boundaries at source not preserved • E.g. Could get new Order applied in separate transaction to associated new OrderDetails

  13. Key Features • No-Code Sync Configuration • Easily define data to be synchronized and locations • Choose how often data is synchronized • Full Data Synchronization Capabilities • Two-way sync of same data, as well as one-way sync • Conflict Handling • Detect and resolve conflicts caused by the same data being changed in multiple locations • Logging and Monitoring • Administration capabilities for tracking usage • Scale • Service scales as resources requirements grow

  14. V1 Planned UI

  15. Planned V1 Features not in CTP2 • Improved UI & Windows Azure portal integration • Column filtering – allow selection of columns • Row filtering – filter specification per table • Specify conflict resolution policy • Specify sync direction per member pair • More robust database schema provisioning • Cater for schema updates and/or schema sync • Billing

  16. SQL Azure Reporting

  17. SQL Azure Reporting V1 Scenarios Operational Reports Embedded Reports SQL Azure Reporting Windows Azure Application BI Developer Studio SQL Azure Database RDL File

  18. SQL Azure Reporting Value • Who: • Developers, System Integrators, Consultants and IT Departments • Benefits: • Elasticity, scalability and reliability of Cloud Computing • Accessibility • Cost effective: • Decrease Capital expenditure and time-to-solution • Symmetrical: • Design, develop and deploy your BI solutions using the tools and expertise you already have

  19. SQL Azure Reporting V1 Features • Author report using Business Intelligence Development Studio • Support SQL Azure as report Data Source • Rich Data Visualizations: Charts, Maps and Tablix • Render to variety of formats (Excel, Word, XML, PDF) • URL Access to directly view reports in browser • Developer use Report Viewer control to embed a report in application in connected mode • SOAP APIs enable developers to build own applications for reporting

  20. Features not in V1 • OData, Dallas, on-premises data sources • Subscriptions and scheduled delivery of Reports • Developer extensibility such as custom data sources, custom assemblies, etc. • Native Report Manager experience • Users connect to SQL Azure Reporting with their company’s domain credentials • SharePoint Integration • Creation of report models (SMDL)

  21. SQL Azure Reporting

  22. V1 Updates • User & permission management: • Add & remove users who can access reports • Assign roles per user per report • Performance improvements • Billing!

  23. Summary

  24. Roadmap • SQL Azure Data Sync • Limited CTP2: Now • Public CTP3: Summer 2011 • V1: Fall 2011 • SQL Azure Reporting Services • Limited CTP: Now • Public CTP: Summer 2011 • V1: Fall 2011

  25. References • Get further information: • Overview information: • http://www.microsoft.com/windowsazure/ • http://www.microsoft.com/en-us/SQLAzure/datasync.aspx • http://www.microsoft.com/en-us/sqlazure/reporting.aspx • SQL Azure Forum: • http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/threads • SQL Azure Blog: • http://blogs.msdn.com/b/sqlazure/ • Feature voting: • http://www.mygreatwindowsazureidea.com/ • Contact information / CTP access: • Mark.Scurrell@microsoft.com

  26. Get Started with Windows Azure For Free Today! • MSDN Subscriber • Activate Your Free Included MSDN Benefits via http://tinyurl.com/activatemsdnazurebenefits • Individual: • Get a Free Azure Introductory via http://tinyurl.com/freeintroazureoffer • Free Computation hours and Storage • Get 30 Days Free Windows Azure via http://www.windowsazurepass.com • Select Belgium and enter Promo code: AZP001 • Partner • Get free monthly access to Azure with Partner Cloud Essentials via http://www.microsoftcloudpartner.com/ 

  27. Start Developing on the Windows Azure Platform • Activate your Benefits (see previous slide) • Get the Tools via http://tinyurl.com/toolsforazure • First learn how to create an application via http://tinyurl.com/deployazureapplication

  28. Stay up to date with MSDN Belux • Register for our newsletters and stay up to date:http://www.msdn-newsletters.be • Technical updates • Event announcements and registration • Top downloads • Follow our bloghttp://blogs.msdn.com/belux • Join us on Facebookhttp://www.facebook.com/msdnbehttp://www.facebook.com/msdnbelux • LinkedIn: http://linkd.in/msdnbelux/ • Twitter: @msdnbelux DownloadMSDN/TechNet Desktop Gadgethttp://bit.ly/msdntngadget

  29. TechDays 2011 On-Demand • Watchthis session on-demand via Channel9http://channel9.msdn.com/belux • Download to your favorite MP3 or video player • Get access to slides and recommended resources by the speakers

  30. THANK YOU

More Related