Download - Be05 introduction to sql azure
![Page 1: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/1.jpg)
Template designed by
Introduction to SQL Azure
Andrea Benedetti
[email protected] | @anbenedetti
http://blogs.technet.com/b/andrea_benedetti_blog
![Page 2: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/2.jpg)
brought to you by
![Page 3: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/3.jpg)
chi sono
SQL Server from 6.5
Architect | SQL Server & BI Regional Lead @ MCS
Alpinista (in solitaria)
http://it.linkedin.com/in/abenedetti/
https://twitter.com/anBenedetti
https://www.facebook.com/andrea.benedetti
![Page 4: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/4.jpg)
compute data services networks
W. US, East US, N Central US, S Central US, N Europe, W Europe,
E Asia, SE Asia + 24 Edge CDN Locations
Automated
Managed Resources
Elastic
Usage Based
app services
![Page 5: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/5.jpg)
Windows Azure Data Management — Overview
![Page 6: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/6.jpg)
A Continuous Offering
From Private To
Public Cloud
![Page 7: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/7.jpg)
Windows Azure SQL Database (PaaS)
7
Simplified with proven
![Page 8: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/8.jpg)
What is Azure SQL Database?
A relational database-as-a-service, fully managed by Microsoft.
Delivers predictable performance, elastic scale, business continuity and programmatic functionality.
For cloud-designed apps when near-zero administration and enterprise-grade capabilities are key.
Perfect for cloud architects and developers looking for programmatic DBA-like functionality.
?
![Page 9: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/9.jpg)
A Server Is Not A Machine
![Page 10: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/10.jpg)
How is it different from VMs?
Best for…
SQL Server in a VM Azure SQL Database
Features
Resources
![Page 11: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/11.jpg)
• Missing platform components
• Non supported T-SQL DDL constructs
• Non supported T-SQL DML commands
• Other gremlins
Unlikely that anything but the most trivial on-premises DB will be migrated without at least some changes
http://msdn.microsoft.com/en-us/library/windowsazure/ff394102.aspx
Windows Azure SQL Database != SQL Server
![Page 12: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/12.jpg)
Tables without a clustered index and/or primary key
XML Schema on XML columns, XML indexing
User defined CLR types
FILESTREAM type
Etc. …
http://msdn.microsoft.com/en-us/library/windowsazure/ee336281.aspx
Non-supported DDL Easy to identify
![Page 13: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/13.jpg)
BULK INSERT
OPENROWSET, OPENQUERY, OPENXML
Several of the Database Console Commands (DBCC)
EXECUTE AS LOGIN
Etc. …
http://msdn.microsoft.com/en-us/library/windowsazure/ee336253.aspx
Non-supported DML Harder to identify
![Page 14: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/14.jpg)
Limitations on certain user names (sa, admin, root etc…)
USE {database} is not supported for DB context switching on a
single connection
Must specify the database name in the connection string
ALTER INDEX REORGANIZE (Must REBUILD)
Etc. …
Other gremlins
![Page 15: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/15.jpg)
Architecture
![Page 16: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/16.jpg)
How It Works
![Page 17: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/17.jpg)
High Availability
Replica 1
Replica 2
Replica 3
DB
Single Database Multiple Replicas
Single Primary
Replica 4
!
![Page 18: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/18.jpg)
The basics
![Page 19: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/19.jpg)
The Basics
![Page 20: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/20.jpg)
Server Provisioning
![Page 21: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/21.jpg)
Create db
![Page 22: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/22.jpg)
Create Database…
![Page 23: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/23.jpg)
Enhanced Tooling
![Page 24: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/24.jpg)
Database Deployment
![Page 25: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/25.jpg)
Secure db
![Page 26: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/26.jpg)
There Are Two
Ways To Secure
A Database:
![Page 27: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/27.jpg)
Server Benefits
![Page 28: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/28.jpg)
Database Benefits
![Page 29: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/29.jpg)
SQL Database Firewall
![Page 30: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/30.jpg)
SQL Database Firewall
![Page 31: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/31.jpg)
Application Connectivity
1.
2.
3.
1.
2.
3.
4.
5.
6.
7.
8.
9.
<connectionStrings><addname="AdventureWorks"connectionString=
"Data Source=[server].database.windows.net;Integrated Security=False;Initial Catalog=ProductsDb;User Id=[login];Password=[password];Trusted_Connection=False;Encrypt=true;"
providerName="System.Data.SqlClient"/></connectionStrings>
![Page 32: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/32.jpg)
Monitoring
![Page 33: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/33.jpg)
Database Monitoring
Query Plans
Extended Events
DMVs
Event Table
There is no SQL Profiler – Use DMVs
![Page 34: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/34.jpg)
DMVs for Performance Monitoring
![Page 35: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/35.jpg)
News
![Page 36: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/36.jpg)
Introducing new service tiers
Elastic scale & performance: Six performance levels across three tiers for scale up and down based on throughput needs. Better resource isolation Improved billing experience.
Business continuity: A spectrum of business continuity features from light-weight to mission-critical across the tiers. Customers can dial up the control over data recovery and failover.
Familiar & Self-managed: Unprecedented efficiencies as your applications scale with a near-zero maintenance service and a variety of familiar management tools & programmatic APIs.
![Page 37: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/37.jpg)
Azure SQL Database New Service Tiers
App Scalability & Performance
Business Continuity
Developer Efficiency
Massive scale & performance
Business continuity & data protection
Familiar management tools & APIs, Self-managed
*SLAs will take effect at time of GA, Azure previews are subject to different service terms, as set forth in preview supplemental terms.
**Not all restore & disaster recovery features are available today, visit the disaster recovery documentation page to learn more.
![Page 38: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/38.jpg)
Dashboard views of metrics
Quickly understand DB resource usage via percent of resources
consumed for each resource type over time and database size Monitor
Available in the management
portal & via APIs
In contrast to a VM, no system-
related overhead—focused on
just the resources used to run
your database workload
In-depth views (DMVs) are also
available for deeper
understanding and trouble-
shooting (for example, at the
query level)
![Page 39: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/39.jpg)
Self-service restore
Auto backups, transactional logs every
5 min
Backups in Azure Storage and geo-
replicated
Creates a side-by-side database copy,
non-disruptive
REST API, PowerShell or Azure Portal
Backups retention policy:
• Basic, last known state up to 24 hrs
• Standard, up to 7 days
• Premium, up to 35 days
Programmatic “oops recovery” of data deletion or alteration
Geo- replicated
Restore from backup
SQL Database
Backups
sabcp01bl21
Azure Storage
sabcp01bl21
![Page 40: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/40.jpg)
Available in Basic, Standard and Premium
Built on self-service restore technology
Recover to any Azure region
Emergency data recovery when you need it most
Basic Recovery
Geo- replicated
SQL Database
Backups
sabcp01bl21
Azure Storage
sabcp01bl21
Restore to any
Azure region
![Page 41: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/41.jpg)
Opt-in with Standard*
Creates passive secondary
Replicate to pre-paired Azure region
Automatic data replication, asynchronous
Opt-in via REST API, PowerShell or Azure Portal
Microsoft-managed, RTO<24h, RPO<1 hr
Opt-in business continuity for greater geo-redundancies
Geo-replication
Geo- replicated
![Page 42: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/42.jpg)
Active Geo-Replication
Self-service activation in Premium
Create up to 4 readable secondaries
Replicate to any Azure region
Automatic data replication, asynchronous
REST API, PowerShell or Azure Portal
RTO<1h, RPO<5m, you choose when to failover
Mission-critical business continuity on your terms, via programmatic APIs
Up to 4secondaries
![Page 43: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/43.jpg)
Transitioning to the new tiers
![Page 44: Be05 introduction to sql azure](https://reader033.vdocuments.us/reader033/viewer/2022042714/554bd70fb4c905706a8b5178/html5/thumbnails/44.jpg)
Grazie a tutti per la partecipazione
Riceverete il link per il download a slide e demo via email nei
prossimi giorni
Per contattarmi
@anbenedetti
Grazie