7-Perform administration by using T-SQL (10-15%).md

DP-300: Perform Administration by Using T-SQL (10-15%)

Examine system health

• Evaluate database health using DMVs
• Evaluate server health using DMVs
  • System Dynamic Management Views
• Perform database consistency checks by using DBCC

Monitor database configuration by using T-SQL

• Assess proper database Autogrowth configuration
• Report on database free space
• Review database configuration options

Perform backup and restore a database by using T-SQL

• Prepare databases for AlwaysOn Availability Groups
• Perform transaction log backup
• Perform Restore of user databases
  • RESTORE Statements (Transact-SQL)
• Perform database Backups with options

Manage authentication by using T-SQL

• Manage certificates
  • ALTER CERTIFICATE (Transact-SQL)
• Manage Security Principals
  • Tutorial: Managed instance security in Azure SQL Database using Azure AD server principals (logins)

Manage authorization by using T-SQL

• Configure Permissions for users to access database objects
  • Grant a Permission to a Principal
• Configure permissions by using custom roles
  • CREATE ROLE (Transact-SQL)

Return to Table of Contents