Professional azure SQL database administration equip yourself with the skills you need to manage and maintain your SQL databases on the microsoft cloud
Discover how you can migrate a traditional on-premise SQL server database to a cloud-based solution with Microsoft Azure. Built with database administrators in mind, this book emulates different scenarios you might come across while working with large, complex SQL database migrations and provides so...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham ; Mumbai :
Packt
2018.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630529006719 |
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 Model
- Selecting 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 Studio
- SQL 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-ups
- Summary
- 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 Database
- Azure 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
- Scale Up or Scale Down Service Tiers
- Using T-SQL to Change the Service Tier
- Vertical Partitioning
- Horizontal Scaling
- Shard Map Manager
- Data Dependent Routing
- Multi-Tenant Data Models
- Single Tenant (database-per-tenant)
- Shared Database - Sharded
- Activity: Creating Alerts
- Activity: Creating Shards
- Activity: Split Data between Shard
- Activity: Using Elastic Queries
- Summary
- Elastic Pools
- Introducing Elastic Pools
- When Should You Consider Elastic Pools?
- Sizing an Elastic Pool
- Comparing the Pricing
- Sizing Best Practices.
- Create an Elastic Pool and Add Toystore Store Shards to the Elastic Pool
- Elastic Jobs
- Use Cases
- Architecture
- Elastic Job Workflow
- Create an Elastic Job using the Azure Portal
- Activity: Exploring Elastic Pools
- Summary
- High Availability and Disaster Recovery
- High Availability
- Disaster Recovery
- Standard Geo-Replication
- Database Failover
- Active Geo-Replication
- Database Failover
- Synchronous Replication
- Auto-Failover Groups
- Auto-Failover Group Terms
- Configuring Active Geo-Replication and Performing a Manual Failover
- Configuring the Auto-Failover Group
- Activity: Configure Active Geo-Replication
- Activity: Configure Auto-Failover Groups
- Summary
- Monitoring and Tuning Azure SQL Database
- Monitoring an Azure SQL Database using the Azure Portal
- Monitoring Database Metrics
- Alert Rules, Database Size, and Diagnostic Settings
- Alert Rules
- Database Size
- Diagnostic Settings
- Query Performance Insight
- Monitor Queries using the Query Performance Insight Blade
- Monitoring an Azure SQL Database using DMVs
- Monitoring Database Metrics
- Monitoring Connections
- Monitoring Query Performance
- Monitoring Blocking
- Extended Events
- Examining Queries
- Tuning an Azure SQL Database
- Automatic Tuning
- Create Index
- Drop Indexes
- Force Last Good Plan
- In-Memory Technologies
- In-Memory OLTP
- Columnstore Indexes
- Activity: Explore the In-Memory OLTP Feature
- Summary
- Index.
