Mustafa EL-Masry #Azure, Azure Tips

Microsoft Azure AZ-103 Tips , Hints and Notes Part 1


During my study for AZ-103 Exam, I take some notes and hints from the resources, materials, and videos I study from it and from some exam templates, based on that I need to share this points with you and I hope it will be useful for all of us and the series will be around 4 or 5 parts. The first part related to “Manage Azure Subscription and Resources” in the part of today I will list some important articles I write it in this subject and around 20 points as notes related to the same subject

For more information about other Azure posts and articles, all of them are collected in one link ➡️  HERE ✅

keep following me for the upcoming parts in Azure Tips, Hints, and Notes series.

Manage Azure Subscription

  1. Azure Subscription Administrator Roles Types
  2. Manage Azure Policy Using PowerShell
Continue reading “Microsoft Azure AZ-103 Tips , Hints and Notes Part 1” →
Mustafa EL-Masry #Azure, Azure Database, Azure Replication

Enabling Auto-Failover Group on Azure SQL


Today in Article I will explain How we can enable the Auto Failover group on Azure SQL and what is different between Auto-Failover Group and Active Geo-Replication in Azure SQL. Before starting in How to implement the Azure SQL Auto Failover Group I recommend you to take a look on this ➡️ POST to understand How you can configure  Active Geo-Replication on Azure SQL and for more Azure SQL articles check this ➡️ LINK  and for more other Azure Posts and articles check this ➡️ LINK for all of my azure articles

  • Active Geo-Replication VS Failover Group
  • How to enable Auto-Failover Group on Azure Single SQL Server
  • Check the Failover Group Configuration and Connections
  • Test the Failover
  • Conclusion
  • Resources
  • Follow Me on Social Accounts
Continue reading “Enabling Auto-Failover Group on Azure SQL” →
Mustafa EL-Masry #Azure, Azure Data Studio

KQL in Azure Data Studio April 2020 Release


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

Mustafa EL-Masry #Azure, Azure Storage services

Microsoft Azure Storage Permission


Before starting for How we can access the storage account using an access key or SAS and what is the difference between them I highly recommend you to take a look about this articles series for how to manage azure storage account using Azure portal, PowerShell and Cloud Shell ➡️ https://lnkd.in/edn6nyY/#AzureStorageAccount 💨✅

  • Storage account Firewall
  • Access Key
  • Shared Access Signature
  • Azure Blob Data Permissions Deep Dive (360 in 360) Video by John Savill
  • Database Cloud Tech Azure Posts Road-Map
  • Follow Up Database Cloud Tech on LinkedIn , Facebook and twitter
Continue reading “Microsoft Azure Storage Permission” →
Mustafa EL-Masry #Azure, Azure Event

Microsoft Azure Events for Upcoming 30 Days


Microsoft Event for Upcoming 30 days if you are looking for more events in other fields check Microsoft Event Site https://events.microsoft.com/

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

Azure SQL

Azure DP-200 and DP-201

Azure Data AI

Keep Following Me

Mustafa EL-Masry #Azure, Azure Data Studio

How to Manage Azure with PowerShell Command from Azure Data Studio


All of us know Azure Data Studio is new Microsoft tool like SQL Server Management Studio but with highly advanced features like Azure Data Studio Notebook, one of the features that you can PowerShell extension on Azure data Studio to connect to your Azure Portal and do your homework easily, Azure data studio PowerShell extension supported PowerShell and Cloud Shell (CLI) AZ Command, did you imagine this powerful tool from one place you can write your T-SQL, PowerShell, and CLI and you can manage your SQL Server on Premises and your Azure SQL and the other Azure services, all of these services and these languages from one place Using Microsoft Azure data Studio 🚀💪😱

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

Managing Azure With PowerShell From Azure Data Studio

Connect to Azure with PowerShell from Azure Data Studio

Continue reading “How to Manage Azure with PowerShell Command from Azure Data Studio” →
Mustafa EL-Masry #Azure, Azure Storage services

Azure Date Transfer Solutions


Microsoft Azure provided verity of options for how to transfer your data from or to your storage or from on-premises to Azure or from Azure to on-premises many of options and I explained before some of them like Azcopy check this  ➡  post , Azure Data Migration Services (DMS) Check this  ➡  Post  , Azure Storage Explorer Check this ➡  Post.

And to know more about this this solution easily you open your storage account and in the left side you will find Data Transfer if you click on it Microsoft give you service to search on it about the most optimal offline or online data transfer based on your need and this search depend on 3 keys (Network Speed, Data Size, Transfer Frequency option).

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

So before doing any data transfer check this service to Search from among the common Azure data transfer solutions to select the best option for your data. For more information about Azure solution for data transfer check ➡  Microsoft article.

Continue reading “Azure Date Transfer Solutions” →