a lap around · • sql server mvp • technical director (business intelligence) ......
TRANSCRIPT
Rod Colledge Technical Director (Business Intelligence), StrataDB
@rodcolledge | www.rodcolledge.com | [email protected]
A Lap Around
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
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
What is SQL Azure?
M O N D A Y
T U E S D A Y
W E D N E S D A Y
• 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 …
Windows Authentication
Replication
Log Shipping
Database Mirroring
TDE
Full-text Search
CLR
Data Compression
Not Supported … yet
All or Nothing
Distributed/Hybrid
“X”aaS
SaaS Software as a Service
IaaS Infrastructure as a Service
PaaS Platform as a Service
Control & Responsibility
Why Azure?
Elasticity
$500,000
$20,000
X 2 – Test Environment
Why Azure?
Cost/Usage Based Architectures
Partner/Customer Integration HA/DR Extensions
Agility esp. for Start Up Ventures
Why NOT Azure?
Windows Authentication
Replication
Log Shipping
Database Mirroring
TDE
Full-text Search
CLR
Data Compression
Other Considerations
Frequent drops vs. 3-5 year release cycles Geo-Political Considerations
Security
Azure Cost
Azure Components • SQL Azure (Database)
• Compute Instance
• Virtual Machines
• Storage
• Data Transfers
WindowsAzure.com/Pricing
Azure Data Transfer Costs
Free Inbound
Free Within
Charges for Outbound • North America & Europe: 12 cents / GB
• Asia Pacific: 19 cents / GB
Azure – Free Options
3 Month Free Trial
Azure – Free Options
MSDN
Provisioning a SQL Azure Instance
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
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
DBA Management Backups (and Restores)
DBCC
Indexing
File Management
Version Upgrades
Data Management
Backup/Restore
No Transaction Log (that you would recognize)
Third-Party Tools / CodePlex
CREATE DATABASE DB2 AS COPY OF DB1
Import/Export
No DBCC Support
Indexing
Indexes ARE supported
Every Table MUST have a Clustered Index
No Support for Some Options such as;
- MAXDOP
- FILLFACTOR
File Management
There are no files!
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
Demos
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?
Data Movement Getting Schema & Data In/Out
DACPAC/BACPAC
DDL & DML Scripts
BCP – S tcp: servername.database.windows.net
SSIS
3rd party tools & Codeplex
• Bi-Directional
• To Hub or From Hub
• Agent for On-Prem
• Sync Schedule
• Conflict Resolution
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
?
