Being a DBA in the Future: Global Azure Bootcamp 2015

Being a DBA in the Future
A World of On-Premises
and Cloud

Get in touch Grant Fritchey
scarydba.com
grant@scarydba.com
@gfritchey

Windows Azure Data Management
— Overview

Options for Relational Data
Services in the Cloud

SQL Server in a Windows Azure
Virtual Machine

Windows Azure Virtual Network
Build virtual networks that scale
Traditional, familiar approach to build
extension to datacenter
Complete control over network configuration
Define your own IP addresses
Enables complex hybrid scenarios
And compliance scenarios for sensitive data
Apps on Azure VMs can securely Access
on-premise Databases
Including Domain-Attach Azure VMs to
on-premise AD

SQL SERVER AZURE VM
DEMO & LAB

How It Works
Client Layer – Used by application to communicate
directly with SQL Database.
Services Layer – Gateway between Client layer and
Platform layer.
Platform Layer – Includes physical servicers and services
that support the Services layer.
Infrastructure Layer – IT administration of the physical
HW and OS.

Optimization
18
Traditional: Query Tuning, Indexes, Database Design
Windows SQL Azure Database Premium
Scale Out Through Sharding

What’s Old is New
Transactions as short as possible
Only move the data you need to move
Only move the data when you need to move
it
Tune the queries

Data Movement
20
Import/Export through DACPAC
Manage data movement through DataSync
Standard mechanism with SSIS

Additional Reading
 Data Partitioning
 Retry Guidance
 Scalability Checklist

Being a DBA in the Future: Global Azure Bootcamp 2015

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Similar to Being a DBA in the Future: Global Azure Bootcamp 2015

Similar to Being a DBA in the Future: Global Azure Bootcamp 2015 (20)

More from Grant Fritchey

More from Grant Fritchey (20)

Recently uploaded

Recently uploaded (20)

Being a DBA in the Future: Global Azure Bootcamp 2015