Transcript Emil Velinov Senior Program Manager Nicholas Dritsas Principal Program Manager Windows Azure Customer Advisory Team (AzureCAT) Microsoft Corporation.

Emil Velinov
Senior Program Manager
Nicholas Dritsas
Principal Program Manager
Windows Azure Customer Advisory Team (AzureCAT)
Microsoft Corporation
Shared
Lower cost
Hybrid Cloud
WA SQL Database
Virtualized Databases
Dedicated
Higher cost
SQL Server in WA VM
Virtualized Machines
SQL Server Private Cloud
Virtualized Machines+ Appliances
SQL Server
Physical Machines (raw iron)
High Control
Low Control
Cloud Backup
AlwaysOn Replica
in Azure
SQL Server with
Azure Storage
integration
SQL Server with
Azure IaaS
Deploy DB to
Azure VM
CREATE CREDENTIAL mystoragecred
WITH IDENTITY = ‘mystorage',
SECRET = ‘<your storage access key>
BACKUP DATABASE mydb TO URL ='https://mystorage.blob.core.windows.net/backup-container/mydb20130905.bak'
WITH CREDENTIAL = ‘mystoragecred',
FORMAT, COMPRESSION, STATS = 5,
MEDIANAME = ‘mydb backup 20130905', MEDIADESCRIPTION = 'Backup of mydb'
SQL 2008 R2 SQL 2012, SQL
2014 CTP1
•
Upload VHD
sysprep
Multiple SKUs Pay by Minute
monthly (roughly)
you patch
•
•
License Mobility
You create
patch
Create a slipstream package
with CU2
Run SQL Server Setup
 Invoke Image Preparation
 Select Features
 Generalize image
Upload to Windows Azure
Sysprep support for




Analysis Services
Integration Services
Management Tools (SSMS)
Other Shared Features
Performance Improvements
Solution
New SSMS Wizard: Deploy Database to a Windows Azure VM
Portal
Report
Deployed
Not deployed
Detailed log
Virtual Machine
Windows
Server
Blob
Microsoft Confidential
Memory
Maximum
Disk Space Allocated
data disks
for Virtual Bandwidth
(1 TB
Machines (Mbps)
each)
Maximum
IOPS (500
maximum
per disk)
ExtraSmall Shared
768 MB
20 GB
5
1
1x500
Small
1
1.75 GB
70 GB
100
2
2x500
Medium
2
3.5 GB
135 GB
200
4
4x500
Large
4
7 GB
285 GB
400
8
8x500
ExtraLarge 8
14 GB
605 GB
800
16
16x500
A6
4
28 GB
285 GB
1,000
8
8x500
A7
8
56 GB
605 GB
2,000
16
16x500
Virtual
Machine
Size
CPU Cores
http://msdn.microsoft.com/en-us/library/windowsazure/dn197896.aspx
Whitepaper http://go.microsoft.com/fwlink/?LinkId=306266
http://channel9.msdn.com/Events/TechEd/Australia/2013
http://www.microsoftvirtualacademy.com/
http://technet.microsoft.com/en-au/
http://msdn.microsoft.com/en-au/
http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx
www.windowsazure.com
http://www.windowsazure.com/en-us/documentation/services/hdinsight/?fb=en-us
www.powerbi.com