Professional Azure SQL Database Administration : Equip Yourself with the Skills You Need to Manage and Maintain Your SQL Databases on the Microsoft Cloud.

Mostrar otras versiones (1)

As the cloud version of SQL Server, Azure SQL Database differs in key ways when it comes to management, maintenance, and administration. It's important to know how to administer SQL Database to fully benefit from all of the features and functionality that it provides. This book addresses import...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Osama, Ahmad
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing Ltd, 2018.
Temas:
SQL server.
SQL server
Database management.
Bases de données > Gestion.
Information technology: general issues.
Cloud computing.
Databases.
Computers > General.
Computers > Database Management > General.
Database management
Acceso en línea:Texto completo
Tabla de Contenidos:
  • Intro; Preface; Microsoft Azure SQL Database Primer; Azure SQL Database Architecture; Azure SQL Database Request Flow; Provisioning an Azure SQL Database; Connecting and Querying the SQL Database from the Azure Portal; Connecting and Querying the SQL Database from SQL Server Management Studio; Deleting Resources; Differences between Azure SQL Database and SQL Server; Unsupported Features; Activity: Provisioning Azure SQL Server and SQL Database using PowerShell; Summary; Migrating a SQL Server Database to an Azure SQL Database; Finding the Migration Benefits; Finding the Blockers.
  • Selecting a Service ModelSelecting a Service Tier; Selecting the Main and Disaster Recovery Region; Selecting a Migration Tool; Azure SQL Database Service Tiers; Basic Service Tier; Standard Service Tier; Premium Service Tier; Premium RS Service Tier; Database Transaction Units; Scaling up the Azure SQL Database Service Tier; Changing a Service Tier; Determining an Appropriate Service Tier; Azure SQL Database DTU Calculator; Finding an Initial Service Tier for the Database to be Migrated using the DTU Calculator; Determining Compatibility Issues; Data Migration Assistant.
  • SQL Server Data Tools for Visual StudioSQL Server Management Studio; SQLPackage.exe; SQL Azure Migration Wizard; Determining the Migration Method; Migrating the On-Premises SQL Server Database to Azure SQL Database; Activity: Using Data Migration Assistant; Activity: Performing Transactional Replication; Summary; Backing Up the Azure SQL Database; Automatic Backups; Backup Storage; Backup Retention Period; Configuring Long-Term Backup Retention for Azure SQL Database; Manual Backups; Backing up the Azure SQL Database using SSMS; DACPAC and BACPAC; Manual versus Automated Backups.
  • Activity: Perform Back-upsSummary; Restoring an Azure SQL Database; Restore Types; Point-In-Time Restore; Long-Term Database Restore; Restoring Deleted Databases; Geo-Restore Database; Importing a Database; Activity: Perform PITR; Activity: Perform Geo-Restore; Summary; Securing an Azure SQL Database; Access Control; Firewall Rules; Managing the Server-Level Firewall Rules using the Azure Portal; Managing the Server-Level Firewall Rules using Transact-SQL; Managing Database-Level Firewall Rules using Transact-SQL; Authentication; SQL Authentication; Azure Active Directory Authentication.
  • Using Active Directory
  • Password to Authenticate to an Azure SQL DatabaseAzure SQL Database Authentication Structure; Azure SQL Database Authentication Considerations; Authorization; Creating Contained Database Users for Azure AD Authentication; Groups and Roles; Row-Level Security; Dynamic Data Masking; Proactive Security; Auditing; Configure Auditing for Azure SQL Server; Threat Detection; Configure Threat Detection for Azure SQL Server; Activity: Implement Row-Level Security; Activity: Implement Dynamic Data Masking; Summary; Scaling Out Azure SQL Database; Vertical Scaling.

Ejemplares similares