配置和管理内容参考信息 - Azure SQL 数据库Configure and manage content reference - Azure SQL Database
Azure SQL 数据库
本文介绍可帮助你管理和配置 Azure SQL 数据库的各种指南、脚本和说明的内容参考信息。In this article you can find a content reference of various guides, scripts, and explanations that can help you to manage and configure your Azure SQL Database.
加载数据Load data
- 迁移到 SQL 数据库Migrate to SQL Database
- 了解如何在迁移后管理 SQL 数据库。Learn how to manage SQL Database after migration.
- 复制数据库Copy a database
- 从 BACPAC 导入 DBImport a DB from a BACPAC
- 将 DB 导出到 BACPACExport a DB to BACPAC
- 使用 BCP 加载数据Load data with BCP
- 使用 ADF 加载数据Load data with ADF
配置功能Configure features
- 配置 Azure Active Directory (Azure AD) 身份验证Configure Azure Active Directory (Azure AD) auth
- 多重 Azure AD 身份验证Multi-factor Azure AD auth
- 配置多重身份验证Configure Multi-Factor Authentication
- 配置时态保留策略Configure temporal retention policy
- 为 TDE 配置 BYOKConfigure TDE with BYOK
- 轮换 TDE BYOK 密钥Rotate TDE BYOK keys
- 删除 TDE 保护器Remove TDE protector
- 配置内存中 OLTPConfigure In-Memory OLTP
- 配置 Azure 自动化Configure Azure Automation
- 配置事务性复制以在数据库之间复制数据。Configure transactional replication to replicate your date between databases.
- 配置威胁检测来让 Azure SQL 数据库识别可疑活动,例如 SQL 注入或来自可疑位置的访问。Configure threat detection to let Azure SQL Database identify suspicious activities such as SQL Injection or access from suspicious locations.
- 配置动态数据掩码来保护敏感数据。Configure dynamic data masking to protect your sensitive data.
- 为数据库配置备份保留以在 Azure Blob 存储上保留备份。Configure backup retention for a database to keep your backups on Azure Blob Storage.
- 配置异地复制以将数据库副本保留在另一个区域中。Configure geo-replication to keep a replica of your database in another region.
- 为异地副本配置安全性。Configure security for geo-replicas.
监视和优化数据库Monitor and tune your database
- 手动优化Manual tuning
- 使用 DMV 监视性能Use DMVs to monitor performance
- 使用查询存储监视性能Use Query store to monitor performance
- 启用自动优化来让 Azure SQL 数据库优化工作负荷的性能。Enable automatic tuning to let Azure SQL Database optimize performance of your workload.
- 应用性能建议并优化数据库。Apply performance recommendations and optimize your database.
- 创建警报以从 Azure SQL 数据库获取通知。Create alerts to get notifications from Azure SQL Database.
- 排查连接问题:如果发现应用程序与数据库之间存在某些连接问题。Troubleshoot connectivity if you notice some connectivity issues between the applications and the database. 还可以使用“资源运行状况”来排查连接问题。You can also use Resource Health for connectivity issues.
- 使用智能见解排查性能问题Troubleshoot performance with Intelligent Insights
- 管理文件空间来监视数据库中的存储使用情况。Manage file space to monitor storage usage in your database.
- 使用智能见解诊断日志Use Intelligent Insights diagnostics log
- 监视内存中 OLTP 空间Monitor In-memory OLTP space
扩展的事件Extended events
- 扩展的事件Extended events
- 将扩展的事件存储到事件文件Store Extended events into event file
- 将扩展的事件存储到环形缓冲区Store Extended events into ring buffer
查询分布式数据Query distributed data
- 跨多个数据库查询垂直分区的数据。Query vertically partitioned data across multiple databases.
- 跨横向扩展的数据层进行报告。Report across scaled-out data tier.
- 在具有不同架构的表中进行查询。Query across tables with different schemas.
数据同步Data sync
- SQL 数据同步SQL Data Sync
- Data Sync AgentData Sync Agent
- 复制架构更改Replicate schema changes
- 数据同步最佳做法Best practices for Data Sync
- 数据同步故障排除Troubleshoot Data Sync
弹性数据库作业Elastic Database jobs
- 使用 PowerShell 创建和管理弹性数据库作业。Create and manage Elastic Database Jobs using PowerShell.
- 使用 Transact-SQL 创建和管理弹性数据库作业。Create and manage Elastic Database Jobs using Transact-SQL.
数据库分片Database sharding
- 升级弹性数据库客户端库。Upgrade elastic database client library.
- 创建分片应用。Create sharded app.
- 查询水平分片的数据。Query horizontally sharded data.
- 运行多分片查询。Run Multi-shard queries.
- 移动分片数据。Move sharded data.
- 在数据库分片中配置安全性。Configure security in database shards.
- 向当前的数据库分片集添加分片。Add a shard to the current set of database shards.
- 解决分片映射问题。Fix shard map problems.
- 迁移分片 DB。Migrate sharded DB.
- 创建计数器。Create counters.
- 使用实体框架查询分片的数据。Use entity framework to query sharded data.
- 使用 Dapper 框架查询分片的数据。Use Dapper framework to query sharded data.
开发应用程序Develop applications
- 连接Connectivity
- 使用 Spark 连接器Use Spark Connector
- 对应用进行身份验证Authenticate app
- 使用批处理提高性能Use batching for better performance
- 连接指南Connectivity guidance
- DNS 别名DNS aliases
- 设置 DNS 别名 PowerShellSetup DNS alias PowerShell
- 端口 - ADO.NETPorts - ADO.NET
- C 和 C ++C and C ++
- ExcelExcel
设计应用程序Design applications
后续步骤Next steps
- 详细了解 Azure SQL 托管实例操作指南Learn more about How-to guides for Azure SQL Managed Instance