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 Single Database Fundamental


AS we now Azure SQL Single database is one from deployment Azure Database models if you need to know more information check this post-Azure Database Deployment model options today I am writing about Fundamental information for Azure Single Database

For More Azure Database Articles Check this Link and If you are Preparing for AZ-103 Azure Administrator Certification check this Article

Create Azure Single Database
  1. The Single Database deployment option creates a single isolated database in Azure SQL Database
  2. Azure Single Database Support DTU-based and Vcore-based Purchased Model
  3. The internal of SQL Database server is hidden from the end-user and all are managed by Microsoft Azure
  4. Azure Single Database has it is own Resources (DTU or V-Core) and this resource will not be shared with other databases in the same single instance. Each Database has dedicated resources.
  5. Single Database Isolated meaning if you created two single databases on the same single database server each Database has dedicated resources and the two databases cannot be communicated together and I think this one is a security feature
  6. This means Azure Single Database is the best option for small workloads with applications connects to one DB.
  7. To Provision Azure SQL Single Database, you need (resource Group, Database name, Server Name, User Name, Password, Location, deployment option either single or elastic pool, Compute Storage and purchase model either DTU-based or vCore-based)
  8. In Azure SQL Single database provisioning you can create new or select existing one from (Resource group and Server name)
  9. In Azure SQL Single database provisioning the (resource Group, Database name, Server Name) Should be a unique name.
Continue reading “Azure Single Database 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”

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”