![Page 1: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/1.jpg)
Rod Colledge Technical Director (Business Intelligence), StrataDB
@rodcolledge | www.rodcolledge.com | [email protected]
A Lap Around
![Page 2: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/2.jpg)
About Rod Colledge • SQL Server MVP • Technical Director (Business Intelligence) at StrataDB
• BI/DB Architect Background (C# in emergencies only)
• Working with Microsoft on SQL 2012 Exams
• RodColledge.com • @rodcolledge
![Page 3: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/3.jpg)
Agenda Azure Overview – Windows Azure & SQL Azure
SQL Azure Cost Provisioning a SQL Azure Instance
Inside SQL Azure – Architecture & Security
DBA Management
Demos – Creating / Populating Azure DB & Azure Reporting Sharding/Federations & Data Sync (high level overview)
Azure Stats
![Page 4: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/4.jpg)
What is SQL Azure?
![Page 5: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/5.jpg)
M O N D A Y
![Page 6: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/6.jpg)
T U E S D A Y
![Page 7: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/7.jpg)
W E D N E S D A Y
![Page 8: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/8.jpg)
• SQL Server in the Cloud
• 99.9 % Uptime SLA • 3 copies of database – H/A
• Auto load balanced/ throttled
• License included in subscription
• Frequent Updates
Azure in 60 Seconds …
![Page 9: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/9.jpg)
Windows Authentication
Replication
Log Shipping
Database Mirroring
TDE
Full-text Search
CLR
Data Compression
Not Supported … yet
![Page 10: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/10.jpg)
All or Nothing
Distributed/Hybrid
![Page 11: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/11.jpg)
“X”aaS
SaaS Software as a Service
IaaS Infrastructure as a Service
PaaS Platform as a Service
![Page 12: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/12.jpg)
Control & Responsibility
![Page 13: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/13.jpg)
Why Azure?
![Page 14: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/14.jpg)
Elasticity
$500,000
$20,000
X 2 – Test Environment
![Page 15: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/15.jpg)
Why Azure?
Cost/Usage Based Architectures
Partner/Customer Integration HA/DR Extensions
Agility esp. for Start Up Ventures
![Page 16: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/16.jpg)
Why NOT Azure?
![Page 17: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/17.jpg)
Windows Authentication
Replication
Log Shipping
Database Mirroring
TDE
Full-text Search
CLR
Data Compression
![Page 18: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/18.jpg)
Other Considerations
Frequent drops vs. 3-5 year release cycles Geo-Political Considerations
Security
![Page 19: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/19.jpg)
Azure Cost
Azure Components • SQL Azure (Database)
• Compute Instance
• Virtual Machines
• Storage
• Data Transfers
WindowsAzure.com/Pricing
![Page 20: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/20.jpg)
Azure Data Transfer Costs
Free Inbound
Free Within
Charges for Outbound • North America & Europe: 12 cents / GB
• Asia Pacific: 19 cents / GB
![Page 21: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/21.jpg)
Azure – Free Options
3 Month Free Trial
![Page 22: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/22.jpg)
Azure – Free Options
MSDN
![Page 23: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/23.jpg)
Provisioning a SQL Azure Instance
![Page 24: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/24.jpg)
![Page 25: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/25.jpg)
![Page 26: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/26.jpg)
![Page 27: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/27.jpg)
![Page 28: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/28.jpg)
![Page 29: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/29.jpg)
![Page 30: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/30.jpg)
![Page 31: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/31.jpg)
Inside SQL Azure (Logical DBs)
3 x Copies of each DB High Availability Baked In 99.9 Uptime target Load Balanced Traffic Auto-Throttled Transparent to Apps/Users
Special Azure Sauce
![Page 32: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/32.jpg)
Inside SQL Azure (Security) SQL Authentication
• All logons created explicitly
• No SA/Administrator etc …
• Strong Passwords
IP Restrictions
• Prevents D.O.S Attacks
• Automatic Kill Switch for repeated logon attempts
All Communications are SSL
![Page 33: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/33.jpg)
DBA Management Backups (and Restores)
DBCC
Indexing
File Management
Version Upgrades
Data Management
![Page 34: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/34.jpg)
Backup/Restore
No Transaction Log (that you would recognize)
Third-Party Tools / CodePlex
CREATE DATABASE DB2 AS COPY OF DB1
Import/Export
![Page 35: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/35.jpg)
![Page 36: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/36.jpg)
![Page 37: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/37.jpg)
![Page 38: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/38.jpg)
![Page 39: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/39.jpg)
No DBCC Support
![Page 40: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/40.jpg)
Indexing
Indexes ARE supported
Every Table MUST have a Clustered Index
No Support for Some Options such as;
- MAXDOP
- FILLFACTOR
![Page 41: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/41.jpg)
File Management
There are no files!
![Page 42: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/42.jpg)
![Page 43: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/43.jpg)
![Page 44: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/44.jpg)
![Page 45: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/45.jpg)
What is a SQL Azure DBA?
Logical – YES • Schema Management
• Security
• Query Performance Tuning
• Index Management
• Backup Strategy (from a user error perspective, not H/A)
Physical – NO • File Placement & Management
• Clustering, Mirroring and other H/A Architectures
• Software upgrades, patch management & Hardware Tuning
![Page 46: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/46.jpg)
Demos
![Page 47: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/47.jpg)
Federations & Sharding
150 GB Limit (up from 50GB)
What if we need 10TB?
Sharding (Horizontal Partitioning)
Azure Federations
Sharding logic in App!
What to shard on?
![Page 48: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/48.jpg)
Data Movement Getting Schema & Data In/Out
DACPAC/BACPAC
DDL & DML Scripts
BCP – S tcp: servername.database.windows.net
SSIS
3rd party tools & Codeplex
![Page 49: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/49.jpg)
• Bi-Directional
• To Hub or From Hub
• Agent for On-Prem
• Sync Schedule
• Conflict Resolution
![Page 50: A Lap Around · • SQL Server MVP • Technical Director (Business Intelligence) ... Distributed/Hybrid “X”aaS SaaS Software as a Service IaaS Infrastructure as a Service](https://reader034.vdocuments.us/reader034/viewer/2022042308/5ed509903394b6616e09bb80/html5/thumbnails/50.jpg)
Azure Stats
Largest (Sharded) Azure Database?
Largest Number of Database for 1 App?
Most users for 1 application?
Most IOPS (2K Block Read – 8 Node End Point)?
# beers consumed while making this slide deck?
20 TB
500
3M
34,000
?