1 / 9

SQL Server On Linux: High Availability and Security

SQL Server On Linux: High Availability and Security. Mihaela Blendea Program Manager. Agenda. HADR Options for SQL Server on Linux Roadmap Security Security layers and corresponding solutions Roadmap Demo Add SQL Server instance to Linux cluster

nerina
Download Presentation

SQL Server On Linux: High Availability and Security

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server On Linux: High Availability and Security Mihaela Blendea Program Manager

  2. Agenda HADR Options for SQL Server on Linux Roadmap Security Security layers and corresponding solutions Roadmap Demo Add SQL Server instance to Linux cluster Restore encrypted database from Windows to Linux

  3. SQL Server on Linux – HADR Solutions Availability Groups* Basic Availability Groups* Log Shipping* *In Progress

  4. Mission-critical HADR MIGRATION LINUX DR WINDOWS HA Linux Clustering Linux Clustering Linux Clustering Linux Clustering Reports Backups Sync Log Synchronization Async Log Synchronization

  5. SQL Server on Linux – Security Goal: SQL Server on Linux supports the same enterprise-grade security capabilities that customers rely on with SQL Server on Windows. All built in. • Protect Data • Encryption at rest Transparent Data Encryption • Backup Encryption • Cell-Level Encryption • Encryption in transit Transport Layer Security (SSL/TLS)* • Encryption in use (client) Always Encrypted • Protect Data • Encryption at rest Transparent Data Encryption • Backup Encryption • Cell-Level Encryption • Encryption in transit Transport Layer Security (SSL/TLS) • Encryption in use (client) Always Encrypted SQL • Control Access • Database access SQL Authentication • Active Directory Authentication* • Granular Permissions • Application access Row-Level Security • Dynamic Data Masking • Control Access • Database access SQL Authentication • Active Directory Authentication • Granular Permissions • Application access Row-Level Security • Dynamic Data Masking Monitor Access Tracking activities Fine-Grained Audit *In Progress

  6. Demo Add SQL Server instance to Linux cluster Restore an encrypted database from Windows

  7. Get going! • Visit sqlserveronlinux.com • Install and Docker pull/run instructions • Getting started code samples • Sign up for updates • Join the community on Stack Overflow • Tags: sql-server, sql-server-linux • Watch the rest of this series: • SQL Server on Linux: Introduction to Linux • SQL Server on Linux: Using SQL Server Tools

More Related