Getting Started with Azure SQL Database D o t N e t S o u t h . T e - - PowerPoint PPT Presentation

getting started with azure sql database
SMART_READER_LITE
LIVE PREVIEW

Getting Started with Azure SQL Database D o t N e t S o u t h . T e - - PowerPoint PPT Presentation

Getting Started with Azure SQL Database D o t N e t S o u t h . T e c h C h a d G r e e n M a y 1 4 , 2 0 1 9 Who is Chad Green D i r e c t o r o f S o f t w a r e D e v e l o p m e n t S c h o l a r R x chadgreen@chadgreen.com


slide-1
SLIDE 1

Getting Started with Azure SQL Database

D o t N e t S o u t h . T e c h C h a d G r e e n M a y 1 4 , 2 0 1 9

slide-2
SLIDE 2

Who is Chad Green

D i r e c t o r o f S o f t w a r e D e v e l o p m e n t S c h o l a r R x

chadgreen@chadgreen.com chadgreen.com ChadGreen ChadwickEGreen

slide-3
SLIDE 3

Microsoft’s Data Platform

slide-4
SLIDE 4

Insert title

Sed ut perspiciat unde

  • mni iste natu error

volptatem acusantium rem aperiam.

Insert title

Sed ut perspiciat unde

  • mni iste natu error

volptatem acusantium rem aperiam.

Database as a Service (DaaS)

Cloud computing service model that provides users with some form of access to a database without the need for setting up physical hardware, installing software.

slide-5
SLIDE 5

What is Azure SQL Database

Azure SQL Database is a cloud-based relational database service, built on the Microsoft SQL Server engine designed to deliver predictable performance and scalability, with virtually no downtime and near-zero administration. SQL Server with out the administration headaches!

slide-6
SLIDE 6

Azure SQL Database Purchasing Models

  • Bundled measure of compute,

storage, and IO resources

  • Database Transaction Units

(DTUs)

  • Elastic Database Transaction

Units (eDTUs)

  • Simple, pre-configured

resource options

  • Independently choose

compute and storage resources

  • Azure Hybrid Benefit for SQL

Server

  • Flexibility, control, and

transparency

DTU vCore

slide-7
SLIDE 7

What are DTUs

slide-8
SLIDE 8

What are DTUs

slide-9
SLIDE 9

What are eDTUs

slide-10
SLIDE 10

How Many DTUs Do I Need?

  • Migration
  • DTU Calculator – dtucalculator.azurewebsites.net
  • Existing Azure SQL Database workloads
  • SQL Database Query Performance Insight
  • sys.dm_db_resource_stats
  • sys.resource_stats
slide-11
SLIDE 11

What about vCore?

  • Represents the logical CPU offered with an option to choose

between generations of hardware

  • Flxibitlity, control, transparency of individual resource

consumption, and straightforward way to translate on-premises workload requirements to the cloud

  • Allows you to scale compute, memory, and storage
  • Pay for
  • Compute (service tier + number of vCors + generation of

hardware)

  • Type and amount of data and log storage
  • Number of Ios
  • Backup storage (RA-GRS)
slide-12
SLIDE 12

Deployment Options

slide-13
SLIDE 13

Deployment Options

slide-14
SLIDE 14

Choose a Version of Azure SQL

SQL Server on VM

  • Full Control
  • Up to 99.95%

availability

  • Full parity with on-

premise

  • Fixed database

version

  • Easy migration
  • Private IP Address
  • Ability to host apps on

same VM

Managed Instance

  • Highly compatibility
  • 99.99% availability
  • Built-in backups,

patching, recovery

  • Latest stable version
  • Easy migration
  • Private IP address
  • Built-in advanced

intelligence and security

  • Online change of

resource

Single Database

  • Most commonly used

features

  • 99.99% availability
  • Built-in backups,

patching, recovery

  • Latest stable version
  • Ability to assign

necessary resources to individual databases

  • Online change of

resources

slide-15
SLIDE 15

Built-In Intelligence

G e t t i n g S t a r t e d w i t h A z u r e S Q L D a t a b a s e

slide-16
SLIDE 16

Built-In Intelligence

  • Automatic performance monitoring and tuning
  • Automatic Index Management
  • Automatic Plan Correction
  • Adaptive Query Processing
  • Intelligent Threat Detection
slide-17
SLIDE 17

Built-In Intelligence

  • Automatic performance monitoring and tuning
  • Automatic Index Management
  • Automatic Plan Correction
  • Adaptive Query Processing
  • Intelligent Threat Detection
slide-18
SLIDE 18

Built-In Intelligence

  • Automatic performance monitoring and tuning
  • Automatic Index Management
  • Automatic Plan Correction
  • Adaptive Query Processing
  • Intelligent Threat Detection
slide-19
SLIDE 19

Advanced Security and Compliance

G e t t i n g S t a r t e d w i t h A z u r e S Q L D a t a b a s e

slide-20
SLIDE 20

Built-In Intelligence

  • Auditing for compliance and

security

  • Data encryption at rest
  • Data encryption in motion
  • Dynamic data masking
  • Row-level security (RLS)
  • Azure Active integration and multi-

factor authentication

  • Compliance certification
slide-21
SLIDE 21

Built-In Intelligence

  • Auditing for compliance and

security

  • Data encryption at rest
  • Data encryption in motion
  • Dynamic data masking
  • Row-level security (RLS)
  • Azure Active integration and multi-

factor authentication

  • Compliance certification
slide-22
SLIDE 22

Built-In Intelligence

  • Auditing for compliance and

security

  • Data encryption at rest
  • Data encryption in motion
  • Dynamic data masking
  • Row-level security (RLS)
  • Azure Active integration and multi-

factor authentication

  • Compliance certification
slide-23
SLIDE 23

Built-In Intelligence

  • Auditing for compliance and

security

  • Data encryption at rest
  • Data encryption in motion
  • Dynamic data masking
  • Row-level security (RLS)
  • Azure Active integration and multi-

factor authentication

  • Compliance certification
slide-24
SLIDE 24

Built-In Intelligence

  • Auditing for compliance and

security

  • Data encryption at rest
  • Data encryption in motion
  • Dynamic data masking
  • Row-level security (RLS)
  • Azure Active integration and multi-

factor authentication

  • Compliance certification
slide-25
SLIDE 25

Built-In Intelligence

  • Auditing for compliance and

security

  • Data encryption at rest
  • Data encryption in motion
  • Dynamic data masking
  • Row-level security (RLS)
  • Azure Active integration and multi-

factor authentication

  • Compliance certification
slide-26
SLIDE 26

Built-In Intelligence

  • Auditing for compliance and

security

  • Data encryption at rest
  • Data encryption in motion
  • Dynamic data masking
  • Row-level security (RLS)
  • Azure Active integration and multi-

factor authentication

  • Compliance certification
slide-27
SLIDE 27

Microsoft Azure Compliance Offerings

slide-28
SLIDE 28

Demos

G e t t i n g S t a r t e d w i t h A z u r e S Q L D a t a b a s e

slide-29
SLIDE 29

c h a d g r e e n @ c h a d g r e e n . c o m c h a d g r e e n . c o m C h a d G r e e n C h a d w i c k E G r e e n

Thank You