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 chadgreen.com ChadGreen ChadwickEGreen

Microsoft’s Data Platform

Database as a Service (DaaS) Cloud computing service model that Insert title Insert title provides users with some form of access to a Sed ut perspiciat unde Sed ut perspiciat unde omni iste natu error omni iste natu error database without the need for setting up volptatem acusantium volptatem acusantium rem aperiam. rem aperiam. physical hardware, installing software.

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!

Azure SQL Database Purchasing Models DTU vCore • • Bundled measure of compute, Independently choose storage, and IO resources compute and storage • Database Transaction Units resources • (DTUs) Azure Hybrid Benefit for SQL • Elastic Database Transaction Server • Units (eDTUs) Flexibility, control, and • Simple, pre-configured transparency resource options

What are DTUs

What are DTUs

What are eDTUs

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

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)

Deployment Options

Deployment Options

Choose a Version of Azure SQL SQL Server on VM Managed Instance Single Database • • • Full Control Highly compatibility Most commonly used • • Up to 99.95% 99.99% availability features • • availability Built-in backups, 99.99% availability • • Full parity with on- patching, recovery Built-in backups, • premise Latest stable version patching, recovery • • • Fixed database Easy migration Latest stable version • • version Private IP address Ability to assign • • Easy migration Built-in advanced necessary resources • Private IP Address intelligence and to individual • Ability to host apps on security databases • • same VM Online change of Online change of resource resources

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

Built-In Intelligence • Automatic performance monitoring and tuning • Automatic Index Management • Automatic Plan Correction • Adaptive Query Processing • Intelligent Threat Detection

Built-In Intelligence • Automatic performance monitoring and tuning • Automatic Index Management • Automatic Plan Correction • Adaptive Query Processing • Intelligent Threat Detection

Built-In Intelligence • Automatic performance monitoring and tuning • Automatic Index Management • Automatic Plan Correction • Adaptive Query Processing • Intelligent Threat Detection

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

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

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

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

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

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

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

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

Microsoft Azure Compliance Offerings

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

Thank You 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