what's new in sql azure
TRANSCRIPT
Lynn LangitSr. Developer EvangelistMicrosoft CorporationBlogs.msdn.com/SoCalDevGal
What’s New in Microsoft SQL Azure
SESSION CODE: DAT209
2
Developer ExperienceUse existing skills and tools
The Windows Azure Platform
platformAppFabric
Compute Storage Management Relational data Management Connectivity Access control Reporting & BI
Billing & Payments
Flexible APIs
Information Marketplace
3
SQL Azure DatabaseThe first and only true relational database as a service
Elastic Scale Developer Agility
Self-managed
• Database utility; pay as you grow
• Flexible load balancing• Business-ready SLAs• Enable multi-tenant
solutions• World-wide presence
• Easy provisioning and deployment
• Auto high-availability and fault tolerance
• Self-maintaining infrastructure; self-healing
• No need for server or VM administration
• Build cloud-based database solutions on consistent relational model
• Leverage existing skills through existing ecosystem of developer and management tools
• Explore new data application patterns
4
Customer Scenario - Events, Promotions, Product Launches
Solution
Elastic scale – database as a servicePay as you grow and shrinkEasy to provision and manage databaseNo hardware, no manual database administration required
Promotions, events, ticket selling businesses are “bursts – bound” by natureCapacity constraints limit business agilityHigh costs of entry into new businessDifficult to roll out extra capacity quicklyIdle capacity “off-bursts” is cost prohibitive
Capa
city
Time
“Capacity Bursting“
Average Usage
Average Usage Com
pute
#
of H
r’s
“Without SQL Azure, we wouldn’t be
able to do this. And that means we
couldn't do it on any
cloud platform other than Windows Azure.
SQL Azure is really a cloud -optimized Database.
Chris Auid, Director of Strategy and Innovation,
Challenges Today
5
SQL Azure High Level ArchitectureApplicat
ionInterne
tAzure Cloud
LBTDS (tcp)
TDS (tcp)
TDS (tcp)
Applications use standard SQL client libraries: ODBC, ADO.Net, PHP, …
Load balancer forwards ‘sticky’ sessions to TDS protocol tier
Security Boundary
Gateway
Gateway
Gateway
Gateway
Gateway
Gateway
Scalability and Availability: Fabric, Failover, Replication, and Load balancing
SQL SQL SQL SQL SQLSQL
Gateway: TDS protocol gateway, enforces AUTHN/AUTHZ policy; proxy to backend SQL
6
Service Provisioning ModelEach account has zero or more servers
Azure wide, provisioned in a common portalEstablished a Billing instrument
Each server has one or more databasesLogical concept equal to a master DBContains metadata about database & usageUnit of authentication, geo-location, billing, reportingGenerated DNS-based name
Each database has standard SQL objectsUsers, Tables, Views, Indices, etcUnit of consistency
Account
Server
Database
7
The Journey So Far…
…On To The New Stuff!
20102009Q1 Q2 Q3 Q4 Q1 Q2
PDC 2008Initial CTPSQL Server
Data Services
MIX 2009Announce
Relational Database as a
Service
July 20091st Production Deployment
MS Internal Property
PDC 2009Service
Launch
Windows Azure
Platform
Feb 2010Commercial Availability Windows Azure
Platform
Post LaunchNew Countries
New Service Updates
New Data Centers
8
50GB Database Support
You create a Web or Business Edition databaseYou specify (or modify) MAXSIZE
Web: MAXSIZE = 1 GB| 5 GBBusiness: MAXSIZE = 10 | 20 | … | 50This is the size we will not let you grow beyond
You will only be charged for the actual (peak) size of your database (in any one day)
Up to 50 GB10 GB increments
Business Edition
Up to 5 GBEither 1 GB or 5
GB
Web Edition
9
Geo-Spatial DataType Support2D Vector Data:
Geography – Round-Earth dataGeometry – Flat-Earth data
Support for Point, Line, Area (Polygon) objectsOver 70 T-SQL spatial methodsHigh-performance spatial indicesSpatial industry standard supportSymmetry w/ SQL Server 2008
10
Best Integration – Mgmt / Dev Tools -
SQL Server Reporting ServiceSQL Server Integration Service
11
Houston Client - DEMO
http://sqlazurelabs.com/houston.aspx
12
SQL Azure Web Management - DEMOProject Houston - https://www.sqlazurelabs.com
13
Houston Tool
14
New Tools for Data Migration - DEMO
Copy Database commandCREATE DATABASE DB2A AS COPY OF Server1.DB1A
SQL Azure Migration Wizard (CodePlex) - hereMigration Assistant for Access or for MySQL – here or herehttps://www.sqlazurelabs.com
DataSync (CTP)OData (CTP)
More at ‘Migrate SQL Azure’ session tomorrow at 8:30am in room A5
15
Getting Data Where You Need ItSQL Azure Data Sync Service
Benefits• Scale-out read or
read/write• Geo replication of data• Edge network data
distribution• Content delivery
networks
Sync Grou
p
SQL Azure
SQL Azure
SQL Azure
16
SQL Azure Data Sync – Overview
Offline-Capable Cached Mode Applications
On-Premises
Applications
SyncGroup
SQL Azure
SQL Azure
SQL Azure
Data Sync
Data Sync
Remote Offices & Retail Stores
Data Sync
SQL Azure Data Sync
http://azure.com
SQL Azure Data Sync Service
http://sqlazurelabs.com
17
Broad Reach – OData Support (Labs)
JSONATOM
PUBHTTP
Sign up and send us your feedback!
https://www.sqlazurelabs.com
Open Data Protocol
18
Best Integration – Office 2010 - DEMO
PowerPivot Report Builder
19
Added new Dynamic Management Views (DMVs)
Allows return of state information for health monitoring & performance tuningsys.dm_exec_connections , _requests , _sessions, _tran_database_transactions, _active_transactions, _partition_stats
Added ability to move between Web or Business edition
ALTER DATABASE database_name { MODIFY (MAXSIZE = {1 | 10} GB) }
Increased idle session conn timeout (from 5 to 30 minutes)
Improves experience while using connection pooling and other interactive tools
Improved long running transaction algorithm Allows import and export of much larger amounts of data without having to chunk your data
Added - Feb 2010
20
Added availability in 20 more countries (now 41 total)
Complete list here Started with 21 countries, now doubled
Added support for MARSSimplifies the design process
Added support for ALTER (rename) DatabaseAdds features found in RDMS to SQL Azure
Included support in Visual Studio 2010 to manage SQL Azure
Allows direct management of SQL Azure databases via Server ExplorerAlso found in SQL Server Management Studio
Added new labs feature - sandboxhttps://www.sqlazurelabs.com/
Added - April 2010
21
Added upper size limit of 50 GBAvailable June 28, 2010Initial discount on upgrading maximum size
Added support for Spatial Data TypesSupport for Geography & Geometry data types and queriesSupport for HierarchyID data types (tree-like database structures)
Added support DataSync Service for SQL Azure
Initially available in CTP via sqlazurelabs.com
Announced SQL Server Web Manager Web-based SQL Azure management toolInitially available as CTP in summer 2010
Added Access 10 support for SQL AzureSupport from Office 2010 to SQL Azure
Added - June 2010
22
Added Database copy capabilitiesSame server or cross serverCREATE DATABASE DB2A AS COPY OF Server1.DB1A Monitor via sys.dm_database_copies
Increased MSDN documentation for common programming scenarios (with code examples)Enhanced Project Houston
Supported in multiple data centersView and StoredProc designers added
Added - August 2010
23
SQL Web Management and Administration (SWA)Partitioning UtilityProfiler-like traces / deadlock graphsGeo-location and geo-redundancyDistributed querySecurity w/AD, WLID, etcSupport for multiple levels of hardware and software isolationBI features – SSRS, etc…
Opportunities and Futures
24
Related ContentBreakout Sessions
AZP301 – A Lap Around the Azure PlatformAZP302 – Using Visual Studio 2010 to Build Applications that run on AzureDAT207 – What’s New in Microsoft SQL AzureAZP303 – Migrating Applications to Microsoft SQL Azure
25
Track ResourcesTeam Blog – http://blogs.msdn.com/sqlazure
MSDN Dev Center – http://msdn.microsoft.com/azure/sqlazure
Read my article in MSDN Magazine (November 2010) – “SQL Azure for Developers”
Windows Azure Platform Training Kit - http://bit.ly/dgvMv0
SQL Azure Labs – http://www.sqlazurelabs.com
Follow us on Twitter - @sqlazure
26
Resources
www.microsoft.com/teched
Sessions On-Demand & Community Microsoft Certification & Training Resources
Resources for IT Professionals Resources for Developers
www.microsoft.com/learning
http://microsoft.com/technet http://microsoft.com/msdn
Learning
27
TeachingKidsProgramming.org
• Do a Recipe Teach a Kid• Free Courseware (recipes)• Ages 10 ++• Microsoft SmallBasic
© 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.
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.