Azure SQL Database Managed Instance Fundamental


SQL Server Managed instance is one of the Azure SQL deployment model options and it is providing 100 % Compatibility with SQL Server on-premises so managed instance it the best migration option when you need to migrate the on-premises database without changing any configuration or losing any features not supported by Azure Single database and Azure SQL Database elastic pool. IF you need to know more information about Azure Single database and Azure elastic pool check this post and if you are interested and preparing for azure administrator AZ-103 certification check this link

  • Azure SQL Manged instance Tips
  • Differences between SQL Server On-Premises and Azure SQL Managed instance
  • Azure Managed instance Service Tier
  • Azure SQL Managed instance Security
  • References
Azure Deployment Model Options
Continue reading “Azure SQL Database Managed Instance Fundamental”

Move Azure Single Database to SQL Elastic Pool


AS I explained before in my previous articles How to provision Azure Single Database and How to Provision Azure SQL Database elastic pool today I will explain How we can move Azure Single Database to New Elastic Pool, For more information about Azure Database Deployment model Check this Post and If you are interested in More Azure Database Articles to check this Link and if you are Preparing for AZ-103 Azure Administrator Certification check this Article, In Microsoft documentation, you will find How to Provision Single Database or Elastic pool Server but you will note find information for How to move Single database to Elastic pool server

Case Scenario

Let us assume that we have 2 Azure Single Database Servers contain 3 Database with different Service Tier and we need to move them to Azure elastic pool

Continue reading “Move Azure Single Database to SQL Elastic Pool”

Azure SQL Database Elastic Pool Fundamental


As we know Azure SQL Database elastic pool is one of the Microsoft Azure database deployment model options to know more about these models check this post and to know more about Azure Single Database check this article and if you interested to check all of the Azure SQL Articles check this link, IF you are Preparing for AZ-103 Azure Administrator Certification check this Article

Azure SQL Deployment Model options
Continue reading “Azure SQL Database Elastic Pool Fundamental”

Azure Administration AZ-103 Exam preparation and learning Resources 2020


Introduction

undefinedMy Name Is Mustafa Elmasry I am Database Consultant MCTS, MCTIP, MCSA, MCSE, MCT for more information about me check this page Today I need to announce that I am Very Excited and Thrilled to have passed my AZ-103 I am now Microsoft Certified: Azure Administrator Associate, That’s how I pass my time during #COVID19 days. From 5 months I passed AZ-900 Microsoft Certified: Azure Fundamentals and I started to prepare for Azure Administrator Exam AZ-103 and I am preparing now for the AZ-104 beta new version. I know that I am Database Engineer and this certification not related directly to my carrier objective but I have believed that before starting to learn any cloud services you should have full visibility about azure infrastructure to be able to manage your Azure services well. During the last 5 months, I started to my study journey for Azure administrator and from the first day, I took a covenant on myself to write down all of the notes, hints, and tricks to be a repository that can help the others for how to prepare for Azure administrator certification in this post you will find all of the resources, notes and even the articles I write it during this journey. I take 3 Courses to prepare for the exam AZ-103. In this article, you will find two documentation The First one contain all of the tips and hints I recorded during my study, and the second one it is full documentation explain most of the features and services in azure administration track. In the end, I will be so happy if you share with me your comment and feedback on this post and documents also if anyone has any issue in SQL Server or Azure SQL don’t hesitate to contact me

Microsoft Certified: Azure Administrator Associate
  • Azure AZ-103 Posts and Articles
  • Microsoft Azure AZ-103 Tips, Hints and Notes 2020
  • Azure Administration AZ-103 Documentation 2020
  • Azure Administration AZ-103 Free Resource
  • Another Important Azure Resource
  • Azure Administration AZ-103 Non-Free Courses
  • Keep Following
Continue reading “Azure Administration AZ-103 Exam preparation and learning Resources 2020”

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


Today in this Part i will list some important notes related to Implement and Manage Storage to Check Part 1 got to this link Microsoft Azure AZ-103 Tips, Hints and Notes Part 1

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

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

Manage Azure Storage Account Articles

  1. Managing and implementing Azure storage
  2. Microsoft Azure Storage Kind and Architecture
  3. Create Storage Account Using PowerShell and CLI Command
  4. How To Monitor Azure Storage Account
  5. Sync your local files with Azure Storage Sync Service
  6. Copy Files to or from Azure Storage using Azcopy
  7. Azure Storage Geo-Replication
  8. Azure Date Transfer Solutions
  9. Microsoft Azure Storage Permission

Implement and Manage Storage Tips

Continue reading “Microsoft Azure AZ-103 Tips,Hints and Notes Part 2”