kenny yu
kenny yu
  • Видео 8
  • Просмотров 1 555
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 Data...
Просмотров: 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
Using PerfInsights from Azure Portal
Просмотров 922 года назад
Using PerfInsights from Azure Portal
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

Комментарии

  • @Saio89
    @Saio89 Месяц назад

    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

    • @kennyyu5583
      @kennyyu5583 Месяц назад

      It is hard to tell. Please create a case with support.

  • @surajkumar-tq6ve
    @surajkumar-tq6ve 3 месяца назад

    short and neat, thank you.

  • @guitarmon5765
    @guitarmon5765 7 месяцев назад

    Does the app need AAD authentication to the Azure SQL managed instance when failover from on-premises sql server to Azure sql? Thanks!

    • @kennyyu7340
      @kennyyu7340 7 месяцев назад

      learn.microsoft.com/en-us/azure/azure-sql/managed-instance/native-windows-principals?view=azuresql

  • @anniega2466
    @anniega2466 Год назад

    Any video for how to configurate the network connection the Link and adding ports on Azure? Thanks.

    • @kennyyu7340
      @kennyyu7340 Год назад

      Are you talking about creating a VPN connection?