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

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 • Louisville Tech Leaders Meetup Co-Organizer • Louisville Tech Ladies Committee Member • Contact Information chadgreen@chadgreen.com chadgreen.com ChadGreen ChadwickEGreen

Microsoft’s Data Platform Getting Started with Azure SQL 3 Database

Database as a Service 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

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! Getting Started with Azure SQL 5 Database

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

What are DTUs Getting Started with Azure SQL 7 Database

What are DTUs Getting Started with Azure SQL 8 Database

What are eDTUs Getting Started with Azure SQL 9 Database

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 Getting Started with Azure SQL 10 Database

What about vCore? • 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) Getting Started with Azure SQL 11 Database

Deployment Options Getting Started with Azure SQL 12 Database

Deployment Options Getting Started with Azure SQL 13 Database

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

Built-In Intelligence Getting Started with Azure SQL Database

Built-In Intelligence • Automatic performance monitoring and tuning • Automatic Index Management • Automatic Plan Correction • Adaptive Query Processing • Intelligent Threat Detection Getting Started with Azure SQL 16 Database

Built-In Intelligence • Automatic performance monitoring and tuning • Automatic Index Management • Automatic Plan Correction • Adaptive Query Processing • Intelligent Threat Detection Getting Started with Azure SQL 17 Database

Built-In Intelligence • Automatic performance monitoring and tuning • Automatic Index Management • Automatic Plan Correction • Adaptive Query Processing • Intelligent Threat Detection Getting Started with Azure SQL 18 Database

Advanced Security and Compliance Getting Started with Azure SQL Database

Advanced Security and Compliance • 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 Getting Started with Azure SQL 20 Database

Advanced Security and Compliance • 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 Getting Started with Azure SQL 21 Database

Advanced Security and Compliance • 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 Getting Started with Azure SQL 22 Database

Advanced Security and Compliance • 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 Getting Started with Azure SQL 23 Database

Advanced Security and Compliance • 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 Getting Started with Azure SQL 24 Database

Advanced Security and Compliance • 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 Getting Started with Azure SQL 25 Database

Advanced Security and Compliance • 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 Getting Started with Azure SQL 26 Database

Microsoft Azure Compliance Offerings Getting Started with Azure SQL 27 Database

Demos Getting Started with Azure SQL Database

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