Key features

• •Install, customize, and use SQL Server 2019’s key administration and development tools
• •Manage memory, storage, clustering, virtualization, and other components
• •Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations
• •Provision SQL Server and Azure SQL databases
• •Secure SQL Server via encryption, row-level security, and data masking
• •Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing
• •Establish SQL Server IaaS network security groups and user-defined routes
• •Administer SQL Server user security and permissions
• •Efficiently design tables using keys, data types, columns, partitioning, and views
• •Utilize BLOBs and external, temporal, and memory-optimized tables
• •Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans
• •Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments