AzureDatabase – Page 5 – DB Cloud TECH

As I explained before that #Azure Data Studio is a magic tool, with Azure data Studio you can write all of your query language (T-SQL, #PowerShell, #CLI) you can manage your On-premises SQL Server and your Azure #sqlserver and today with the new updates April 2020 release you can write your #KQL (#Kusto) Query With Azure notebook It allows you to connect, query and explore Azure Data Explorer, ApplicationInsights and LogAnalytic

For more information about How to Manage Azure with PowerShell Command from Azure Data Studio check this Post ➡️ https://mostafaelmasry.com/2020/04/22/how-to-manage-azure-with-powershell-command-from-azure-data-studio/

For More Information About KQL Query Check these two Courses ➡️ https://www.pluralsight.com/courses/microsoft-azure-data-exploring & https://www.pluralsight.com/courses/kusto-query-language-kql-from-scratch

or you can download Kusto Explorer client tool from here ➡️ https://aka.ms/Kusto.Explorer

To learn more about the new Features in Azure data Studio released in April 2020 Check this post ➡️ https://cloudblogs.microsoft.com/sqlserver/2020/04/28/the-april-2020-release-of-azure-data-studio-is-now-available/

📊MY Azure Posts Road-Map💯

👉All of my Azure Posts ➡️ https://lnkd.in/edn6nyY/#AllAzurePosts 💨✅
👉 Azure Data Studio Posts ➡️ https://lnkd.in/edn6nyY/#AzureDataStudioPosts 💨✅
👉 Azure Storage Account Posts ➡️ https://lnkd.in/edn6nyY/#AzureStorageAccount 💨✅
👉 Azure VM Posts ➡️ https://lnkd.in/edn6nyY/#AzureVM 💨✅
👉 Azure SQL Database Posts ➡️ https://lnkd.in/edn6nyY/#AzureSQL 💨✅
👉 Azure PowerShell and Cloud Shell Posts ➡️ https://lnkd.in/edn6nyY/#AzurePowerShell 💨✅
👉 Azure Subscription Posts ➡️ https://lnkd.in/edn6nyY/#AzureSubscription 💨✅
👉 Azure Errors and issues Posts ➡️ https://lnkd.in/edn6nyY/#AzureErrors 💨✅
👉 Other Azure Posts for other Services ➡️ https://lnkd.in/edn6nyY/#Others 💨✅

Keep Following

Deadlock all of us know the meaning of it and how to manage it on SQL Server on-premises and for how to get alert by it normally we are using Database Mail to generate alert from SQL Server but in Azure, the situation is different because there is no Database Mail in Azure there are services called “Azure Monitor” centralized services for managing all of the alerts on all of the Azure resources and this in of the difference between SQL on Azure and SQL on-premises. From this service we can manage our alerts with defining what is the action we need it (Send Email, Execute Function, Call Services, Send SMS ..etc.), You can access the Monitoring Services from this ➡ link or simply by searching azure portal by (Monitor).

Azure Alert Component
How to create Deadlocks Alert
List by alerts created on Azure
Alert Dashboard
How to Get the deadlock reports Using Azure Matrices
How to check Deadlock using SQL Server Script
Other Articles For How to Manage Azure SQL Database

IF you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Azure Alert Component

Resource: The Azure Resource you need to apply for this Alert role on It and it can be done on the azure subscription itself like alert on cost and budget of the subscription.
Condition: it is the logic of the alert what you need to monitor exactly and when
Action Group: the action you need to do it when the alert fire on the condition you configure it
Matrices: It is like dashboard and reports you can configure it to get some statistics on time and you can build alert on it
ALERT DETAILS: alert name and alert description and severity for this alert from (0) to (4)

Continue reading →