Getting Started with Azure SQL Database CodeStock April 12, 2019 - - PowerPoint PPT Presentation

▶
getting started with azure sql database
SMART_READER_LITE
LIVE PREVIEW

Getting Started with Azure SQL Database CodeStock April 12, 2019 - - PowerPoint PPT Presentation

Dec 19, 2022 377 likes •680 views

Chad Green Getting Started with Azure SQL Database CodeStock April 12, 2019 Who is Chad Green Director of Software Development at ScholarRx Community Involvement Code PaLOUsa Conference Chair Louisville .NET Meetup Organizer

slide-1
SLIDE 1

Getting Started with Azure SQL Database

CodeStock April 12, 2019

Chad Green

slide-2
SLIDE 2

Who is Chad Green

  • Director of Software Development at ScholarRx
  • Community Involvement
  • Code PaLOUsa Conference Chair
  • Louisville .NET Meetup Organizer
  • Louisville Tech Leaders Meetup Co-Organizer
  • Louisville Tech Ladies Committee Member
  • Contact Information

chadgreen@chadgreen.com chadgreen.com ChadGreen ChadwickEGreen

slide-3
SLIDE 3

Getting Started with Azure SQL Database

Microsoft’s Data Platform

3

slide-4
SLIDE 4

Database as a Service

Cloud computing service model that provides users with some form

  • f access to a database without the need for setting up physical

hardware, installing software

slide-5
SLIDE 5

Getting Started with Azure SQL Database

What is Azure SQL Database

5

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

Getting Started with Azure SQL Database

Azure SQL Database Purchasing Models

6

DTU

  • Bundled measure of compute, storage,

and IO resources

  • Database Transaction Units (DTUs)
  • Elastic Database Transaction Units

(eDTUs)

  • Simple, pre-configured resource options

vCore

  • Independently choose compute and

storage resources

  • Azure Hybrid Benefit for SQL Server
  • Flexibility, control, and transparency
slide-7
SLIDE 7

Getting Started with Azure SQL Database

What are DTUs

7

slide-8
SLIDE 8

Getting Started with Azure SQL Database

What are DTUs

8

slide-9
SLIDE 9

Getting Started with Azure SQL Database

What are eDTUs

9

slide-10
SLIDE 10

Getting Started with Azure SQL Database

How Many DTUs Do I Need?

10

  • 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

Getting Started with Azure SQL Database

What about vCore?

11

  • Represents the logical CPU offered with an option to choose between

generations of hardware

  • Flexibility, 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 vCores + generation of hardware)
  • Type and amount of data and log storage
  • Number of IOs
  • Backup storage (RA-GRS)
slide-12
SLIDE 12

Getting Started with Azure SQL Database

Deployment Options

12

slide-13
SLIDE 13

Getting Started with Azure SQL Database

Deployment Options

13

slide-14
SLIDE 14

Getting Started with Azure SQL Database

Choose a Version of Azure SQL

14

SQL Server on VM

  • Full control
  • Up to 99.95% availability
  • Full parity with on-premises
  • Fixed database version
  • Easy migration
  • Private IP Address
  • Ability to host apps on same VM
  • 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 resources

Managed Instance

  • 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

Single Database

slide-15
SLIDE 15

Built-In Intelligence

Getting Started with Azure SQL Database

slide-16
SLIDE 16

Getting Started with Azure SQL Database

Built-In Intelligence

16

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

Getting Started with Azure SQL Database

Built-In Intelligence

17

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

Getting Started with Azure SQL Database

Built-In Intelligence

18

  • 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

Getting Started with Azure SQL Database

slide-20
SLIDE 20

Getting Started with Azure SQL Database

Advanced Security and Compliance

20

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

and multi-factor authentication

  • Compliance certification
slide-21
SLIDE 21

Getting Started with Azure SQL Database

Advanced Security and Compliance

21

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

and multi-factor authentication

  • Compliance certification
slide-22
SLIDE 22

Getting Started with Azure SQL Database

Advanced Security and Compliance

22

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

and multi-factor authentication

  • Compliance certification
slide-23
SLIDE 23

Getting Started with Azure SQL Database

Advanced Security and Compliance

23

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

and multi-factor authentication

  • Compliance certification
slide-24
SLIDE 24

Getting Started with Azure SQL Database

Advanced Security and Compliance

24

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

and multi-factor authentication

  • Compliance certification
slide-25
SLIDE 25

Getting Started with Azure SQL Database

Advanced Security and Compliance

25

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

and multi-factor authentication

  • Compliance certification
slide-26
SLIDE 26

Getting Started with Azure SQL Database

Advanced Security and Compliance

26

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

and multi-factor authentication

  • Compliance certification
slide-27
SLIDE 27

Getting Started with Azure SQL Database

Microsoft Azure Compliance Offerings

27

slide-28
SLIDE 28

Demos

Getting Started with Azure SQL Database

slide-29
SLIDE 29

Questions

chadgreen@chadgreen.com chadgreen.com ChadGreen ChadwickEGreen Slides: bit.ly/CS19AzureSQL