windows azure sql database overview

Artemakis Artemiou

SQL Server MVP

CDNUG Lead

INETA-Europe Country Leader (CY)

http://aartemiou.blogspot.com

Windows Azure SQL

Database Overview

- May 22, 2013 -

Agenda

•Introducing Windows Azure SQL Database

•Architecture

•Key Features

•Security

•Administration

•Development

•…

•and lots and lots of demos!

“Windows Azure SQL Database Overview” by Artemakis Artemiou – 22/05/2013 – Slide 2

Introduction

•Windows Azure SQL Database

•Cloud database service from Microsoft

•Formerly SQL Azure

•*SQL Server on the Cloud

•Rich relational programming model/TDS

•Deployment with T-SQL DDL

•Windows Azure Management Portal


DEMO

Windows Azure SQL Database

Management Portal

“Windows Azure SQL Database Overview” by Artemakis Artemiou – 22/05/2013 – Demo

Architecture:

Key Features (I) •Manageability •No administrative overheads

•Provisioning

•High Availability •Build on proven Windows Server and SQL Server technologies

•Redundant copies of the data to multiple physical servers

•Data availability and business continuity.

•Automatic failover


Key Features (II) •Scalability

•Data partitioning / The service scales as the data

grows

•Pay-as-you-grow pricing model for storage

•Familiar Development Environment

•Tabular data stream (TDS) protocol

•Use the same tools and libraries to build client

applications as on-premise development


Key Features (III) •Relational Data Model

•Data is stored by using Transact-SQL

•Same data model as in SQL Server

DB Server DBs Tables, Views, Stored Procedures,

indices, etc.

•Synchronization and Support for Offline

Scenarios

•Integration with Microsoft Sync Framework

•Ability to deploy a common data hub in the cloud


Security •Same set of security principals that are

available in SQL Server with SQL Server

Authentication:

•SQL Server Logins

•Database Users

•Database Roles

•Firewall Rules

•IP Ranges


DEMO

Security


Administration (I) •Windows Azure SQL Database Firewall

•IP Ranges

•Managing Databases and Logins

•Using T-SQL

•The loginmanager Role

•The dbmanager Role


Administration (II) •Migrating to Windows Azure SQL Database

•Export DDL Script Execute on Azure

•Using Microsoft Sync Framework 2.1

•Using Data-tier Application Export and Import

•Community Tool: SQL Database Migration Wizard

•Copying a Database

-- Execute on the master database

CREATE DATABASE Database1B AS COPY OF DB1;

CREATE DATABASE Database2A AS COPY OF Server1.DB1;


Administration (III) •Backing Up a Database

•Create a Copy of the source database using

Database Copy

•Create a logical backup (BACPAC) file using SQL

Database Import/Export Service

•Create a logical backup (BACPAC) file using SQL

Server Management Studio


DEMO

Administration


Development (I) •Building and Hosting SQL Database

Applications

•Method 1:

•Host application code on-premises

•Host database in Windows Azure SQL Database

•Method 2 (minimizes network latency):

•Host application code in Windows Azure

•Host database in Windows Azure SQL Database

•Comment: It depends on the nature of your

application


Development (II) •Transact-SQL Support

•A subset of Transact-SQL for SQL Server is supported

•SQL Server Database Engine features marked

for deprecation may not be supported in

Windows Azure SQL Database

•List of Supported/Unsupported T-SQL Features

•http://msdn.microsoft.com/en-

us/library/windowsazure/ee336250.aspx “Windows Azure SQL Database Overview” by Artemakis Artemiou – 22/05/2013 – Slide 16

Development (III) •Key Tools and Utilities Supported

• The sqlcmd Utility

• SQL Server Management Studio

• The Windows Azure Platform Management Portal

• The Management Portal for SQL Database

• Data-tier Applications

•Generate and Publish Scripts Wizard

• SQL Server Integration Services

• The bcp Utility

• SQL Server Analysis/Reporting Services

• SQL Reporting

• SQL Server Management Objects (SMO)

• SQL Server Migration Assistant (SSMA)

•Microsoft Access

• PowerPivot for Excel


DEMO

Development / Reporting


Summary •Windows Azure SQL Database: •Highly Scalable

•Highly Available

•No Administrative Overheads

•Pay-as-you-grow Pricing Model

•Familiar Development Environment

•Relational Data Model

•Use your Imagination: •Hybrid applications: Extend on-premises applications

•Build data hubs

•There are many uses for this technology!


Resources •Windows Azure Official Website

•http://www.windowsazure.com

•Getting Started with Windows Azure SQL Database

•http://bit.ly/110JVL5

•CDNUG Website

•http://www.cdnug.net

•Blog

•http://aartemiou.blogspot.com

•YouTube Channel

•http://www.youtube.com/sqlserverdotnetblog

•Email: [email protected]

Thank you for attending!

Please do not forget to leave your feedback at:

http://goo.gl/YQSSt

windows azure sql database overview

Technology