- 8
- 1 555
kenny yu
United States
เข้าร่วมเมื่อ 1 ก.พ. 2022
This channel will focus on Azure SQL VM and SQL MI.
Configuring Database Watcher using SQL Auth
Database Watcher was released in November 2024 and is a managed monitoring solution for databases. It is currently supported only for Azure SQL Database and Azure SQL Managed Instance. The setup process for both supported products is comparable.
The training video will feature setting up Database Watcher using SQL Authentication with a system-managed identity. The demo will also show how to set up a free Azure Data Explorer cluster and configure the necessary permissions to allow communication between Database Watcher and the ADX cluster. Several prerequisites will be shown in the demo that need to be configured. Please refer to the "Create and configure a database watcher - Azure SQL Database & SQL Managed Instance" documentation on Microsoft Learn. Additionally, an Azure Key Vault is required for SQL Authentication to store the local SQL user account and password. Please note that this step is not needed if Entra authentication is used.
The training video will feature setting up Database Watcher using SQL Authentication with a system-managed identity. The demo will also show how to set up a free Azure Data Explorer cluster and configure the necessary permissions to allow communication between Database Watcher and the ADX cluster. Several prerequisites will be shown in the demo that need to be configured. Please refer to the "Create and configure a database watcher - Azure SQL Database & SQL Managed Instance" documentation on Microsoft Learn. Additionally, an Azure Key Vault is required for SQL Authentication to store the local SQL user account and password. Please note that this step is not needed if Entra authentication is used.
มุมมอง: 75
วีดีโอ
Restore SQLMI backup to SQL Server On-Perm
มุมมอง 78ปีที่แล้ว
I'll walk through how to restore SQLMI backup to SQL On-Prem. For more information visit the link techcommunity.microsoft.com/t5/azure-sql-blog/restoring-a-sql-managed-instance-database-backup-to-sql-server/ba-p/3677783
Creating Multi subnet SQL VM AG using the portal
มุมมอง 130ปีที่แล้ว
Great feature to create multi subnet SQL VM AG with clicks. learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/availability-group-azure-portal-configure?view=azuresql&tabs=azure-cli
Troubleshooting SQL Server Services on Azure VM.
มุมมอง 59ปีที่แล้ว
This is a quick video on troubleshooting SQL Service startup failures.
Azure SQL Managed Instance Link
มุมมอง 5572 ปีที่แล้ว
In this video, I'll show you how to configure Azure SQL Managed Link. learn.microsoft.com/en-us/azure/azure-sql/managed-instance/managed-instance-link-preparation?view=azuresql
Troubleshooting Azure VM limits using perfInsights
มุมมอง 1072 ปีที่แล้ว
To learn more about perf insights please visit http:\\aka.ms\perfinsights
SQL Server AlwaysOn troubleshooting using AGDiag tool
มุมมอง 4702 ปีที่แล้ว
This video will show a quick an easy way to troubleshoot SQL Server AG failover and find root causes. github.com/microsoft/agdiag github.com/microsoft/SQL_LogScout
Hey, thank you for this video. I know this is 2 years on but I tried setting up a managed instance link over the weekend and while the secondary managed instance says it is synchronizing it has a red x next to it in the availability replicas list. Not sure if it is taking a long time because the database size but I cant delete it or see any indication that it is still working
It is hard to tell. Please create a case with support.
short and neat, thank you.
Does the app need AAD authentication to the Azure SQL managed instance when failover from on-premises sql server to Azure sql? Thanks!
learn.microsoft.com/en-us/azure/azure-sql/managed-instance/native-windows-principals?view=azuresql
Any video for how to configurate the network connection the Link and adding ports on Azure? Thanks.
Are you talking about creating a VPN connection?