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 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 Database Deployment model options


Azure Database Deployment model options

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 3



Today in this Part i will list some important notes related to Deploy and Manage Virtual Machine and the previous parts check it here ➡️ Part 1 Manage Azure Subscription ➡️ Part 2 Implement and Manage Storage

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

Manage Azure VM Articles

  1. Azure Virtual Machines Types,Series
  2. What is Azure AD Connect Sync Engine
  3. Virtual Machine (VM) Backup and Restore (Vault)
  4. Moving Azure VM Using Recovery Service Vault
  5. Azure VM Backup Soft Delete Security features

Deploy and Manage Virtual Machine Tips

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

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”

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”

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”

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

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”

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

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”

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”

Azure Storage Geo-Replication


I explained before How we can use the Geo-replication on Azure SQL and how is very helpful for SQL replication and failover for more information about this subject check this ➡ Article Today we will use the same services for replicated the azure storage data.

  • Previous articles in azure Storage services
  • What is Geo-Replication
  • Azure Storage replication Types
  • How to Implement Geo-Replication on Azure Storage

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

Previous articles in azure Storage services

Continue reading “Azure Storage Geo-Replication”

Azure VM Backup Soft Delete Security features


I talked before about How we can implement backup on Azure VM using Recovery services vault and we mentioned that recovery services vault can be used for two purpose backup and site recovery but today we will take in one of the azure security feature Soft Delete but before this point, if you need to know how you can implement backup on VM using recovery services vault check this ➡ article and if you need to know how you can implement the site recovery using azure backup vault check this ➡ article.

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

Soft Delete Life Cycle on Azure Recovery Services vault
Continue reading “Azure VM Backup Soft Delete Security features”

Copy Files to or from Azure Storage using Azcopy


Before starting on How to move files hosted on the azure container using Azcopy command line I highly recommend you to read below articles to know more information about Azure Storage types, features, how to create it, storage replication types, azure storage explorer and How to monitor your azure storage

  • Azure Storage information
  • What is Azcopy
  • Prerequisites
  • Azcopy command details
  • Check File using Azure Storage Explorer

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

Azure Storage information

Continue reading “Copy Files to or from Azure Storage using Azcopy”

Create Deadlock Alert on Microsoft Azure SQL


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 “Create Deadlock Alert on Microsoft Azure SQL”

The subscription is not registered to Microsoft.insights resource provider


When I am creating Alert from Azure Monitor services I found below massage restricted me to complete the process of creating alert after few search on Microsoft document I found that I need to register for the Microsoft.insights provider to my subscription and they we can do it from azure portal or using PowerShell.

Creation of alert rules will fail, since the subscription is not registered to Microsoft.insights resource provider

Fix the issue using PowerShell command

Register-AzureRmResourceProvider –ProviderNamespace Microsoft.Insights

Fix the issue from Azure Portal

Under subscription in the left side select Resource provider and search about Microsoft.insights then do register for it easily

Keep Following Me

Manage Azure Policy Using PowerShell


Azure Policy is a Microsoft service in Azure used for creating and managing policies , assignments and definition and it is used to force some roles on some resources in case of some actions.

  • Policy definition: is the conditions of the policy
  • Policy assignment: in the part we can define which resource or services you need to apply this policy on it , add in your note that the policy assignment by default inherited so for example if you applied Policy on Subscription it will be inherited on all of the resource under this subscription
  • Policy parameters: it will give you the availability to custom your policy
  • Azure initiative Policy: it the like Azure policy but we can use when you need to do group of policy in one step and it is containing the 3 parts (initiative definition, initiative assignment, initiative parameters) “Policy Combo
Azure Policy

Today we will create Azure policy to enforce any new resource for using tag let’s go to see how we can create this policy using PowerShell Command.

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

  • Create Resource Group “IF you need it is not mandatory”
  • Save the Resource Group in PowerShell variable ($resource)
  • Call the Resource Group ID
  • Get the Azure Policy definition of required to assign tag for any new resource will be created
  • Save the Azure policy information into PowerShell variable ($Policy)
  • Create Azure Policy
Continue reading “Manage Azure Policy Using PowerShell”

How to Solve Error Azure Recovery Services vault cannot be deleted


Today when I am doing cleaning for the azure resources that I don’t need it to reduce the cost, I tried to remove Resource Group contain Recovery Service vault Services but it gives me error

Failed to delete resource group prodresouorcegroup: Deletion of resource group ‘prodresouorcegroup’ failed as resources with identifiers ‘Microsoft.RecoveryServices/vaults/elmasryvmbackupvault1’ could not be deleted

Then when I tried to remove the recovery services vault it gives me another error

Vault cannot be deleted as there are existing resources within the vault. Please ensure there are no backup items, protected servers or backup management servers associated with this vault. Unregister the following containers associated with this vault before proceeding for deletion. For instructions, see https://aka.ms/AB-AA4ecq5

After some Google Search I know the correct steps for deleting  Azure Recovery services vault

Continue reading “How to Solve Error Azure Recovery Services vault cannot be deleted”

Sync your local files with Azure Storage Sync Service


We talked before about Storage and the types of storage and how to manage the storage but today we will talk about the file share that’s one of the types of azure storage and the questions now after creating the file share how I can sync my files from my V-Center VM to Azure File share, Microsoft provided us services called Azure file sync so to let us know how we can configure it and what is the prerequisites we should configure it on the V-Center VM

For more information about Azure Storage check below posts and if you need to check all of my azure posts ➡ Latest Microsoft Azure Articles and Posts

Managing and implementing Azure storage
Microsoft Azure Storage Kind and Architecture
Create Storage Account Using PowerShell and CLI Command
How To Monitor Azure Storage Account
  • Create Azure File Share.
  • Files Assessment on local V-Center VM.
  • Install Azure File Sync on Azure.
  • Install Azure File Sync on local V-Center VM
  • Registration Verification
  • Create Cloud Sync endpoint and server endpoint
Sync your local files with Azure Storage Sync Service
Continue reading “Sync your local files with Azure Storage Sync Service”

Moving Azure VM Using Recovery Service Vault


As I explained before on my last article [Virtual Machine (VM) Backup and Restore (Vault)] that we can use the Azure recovery services vault for taking backup and doing a restore from azure VM using recovery services vault also the same services can be used to migrate your local VM from V-center to Azure using (Recovery services vault site recovery) and in this post, we will explain how to use this services recovery vault to Move VM between two rejoin and to do failover easily for the VM. Let’s go for technical steps

To know more information about azure services check my (Latest Microsoft Azure Articles and Posts)

  • How to build replication on VM
  • How to do Test Failover
  • How to do Real Failover
VM Replication From East US2 to East US
Continue reading “Moving Azure VM Using Recovery Service Vault”

Virtual Machine (VM) Backup and Restore (Vault)


Introduction

Azure Recovery service vault It is azure built in services doesn’t required any infrastructure preparation and it is supported multiple types of backup (VM , File , Disk and SQL Database) it is one of the built options in the VM , so easily when you open Azure virtual machines and select your VM you will find in the left side Backup from this point and this place you can start to manage your backup and restore process as well you can keep monitoring your backup jobs and restore jobs let us go for demo and how to do VM backup and restore it and what is the restore types supported.

  • Azure backup Process.
  • Azure backup hints
  • How to start to take backup from VM
  • Azure Recovery Services vault
  • Azure Restore Options
  • Azure Restore Hints
  • How to do VM restore from Azure recovery services vault

To know more information about azure services check my (Latest Microsoft Azure Articles and Posts)

Azure backup Process:

How the backup process will start and what is the sequences that running behind the seances when I asked azure backup services to take backup from my MV.

  • You need to install Azure backup recovery vault Services
  • Define backup policy then the backup extension will be installed.
  • After this the backup services will start to discovery and analysis your VM disks, files, data and size.
  • Then It will start to create Snapshot from your data. That’s why the backup process sometimes take time but this time will not be more than 24 Hours.
  • After the snapshot completed the Azure backup extension will transfer the snapshot to azure backup recovery vault.

Azure backup hints

Continue reading “Virtual Machine (VM) Backup and Restore (Vault)”

Moving Database Files on SQL Server Always On


I think all of us know how to move files for SQL Server databases from disk to another disk but today I will explain how we can do it on SQL Server always on to reduce the downtime and taking new backup to return the database to always-on again. Let us start on the technical steps.

  • Preparations Steps
  • Check the current DB Files locations
  • Check Always on Health Status
  • Disable all backup jobs on Primary and secondary servers
  • Suspend the data movement on Secondary server
  • Remove Database from Primary server
  • Update DB files by new disk location on secondary server
  • Stop SQL Server instance on Secondary server
  • Move (CUT) DB Files from old location to new Location (Past)
  • Start the SQL Server instance again
  • Verify the DB File Location Using T-SQL on the post
  • Join the DB to availability group from Primary server
  • Check SQL Server always on Health Status Using T-SQL on the post
  • Enable the SQL Server Jobs\
  • Failover the SQL Server for Primary (X) to Secondary Server (Y) and do the same steps on (X)

Let’s Start The Technical Demo

Continue reading “Moving Database Files on SQL Server Always On”

Moving Microsoft Azure Resources Using PowerShell


One of the common tasks as an azure administrator you should know it when you deployed azure resource on resource group related for testing as example and you need to move it to new resource group or resource group of production we can do this activity with one PowerShell command and if you are not interested in PowerShell don’t worry you can do also from Azure Portal.

Alert 💣:Moving Azure resource will create new resource id this meaning if you any subscription or APP referencing this resource-id it will break be caution ✍ (Read More, Document the Steps, Test the Steps ) then do your implementation

To know more information about azure services check my (Latest Microsoft Azure Articles and Posts)

Moving Azure Resource Using Azure Portal

Open Microsoft Azure Portal select the source resource group and from the top, you have two option (Move or Change) both you will direct you to move your resource by the selecting the resource you need to move it then the new resource group (Destination) during this steps you can create new resource group easily.

Moving Azure Resource using PowerShell

Continue reading “Moving Microsoft Azure Resources Using PowerShell”

How to hide SQL databases from users using SSMS


I know the First question you will ask it  “Why we need to hidden it IF the user doesn’t have access on it and he can’t do any operation on this DB 🤔” Simple answer “Business needs & Business Case & Management Request” Whatever the answer but this is the request from management So let us see How we can do it using two solutions.

First Solution hide the DB using Permissions

Before starting on the solution, I need to highlight important point “to implement this solution the user will take ownership of the DB” and this will break the security role. To hide the DB, we need two steps after it the user when he will log in to SQL Server management studio, he will see only this database:

  • Deny or remove the permission of View on databases from the Public User on the instance level.

At this time no one will able to see any databases on the SQL Server management studio except the admins only this means you should grant this permission for specific users that you need them to view all databases “It is just view Permission, accessing the DB is another permission”.

  • Change the DB Authorization by the user name you need him to view this DB only or you can do this step on two or three or more databases at this time this user when he login to SQL Server Management studio he will view these databases only the other databases will be hidden.

Technical deployment scripts

Continue reading “How to hide SQL databases from users using SSMS”

How To Monitor Azure Storage Account


Monitoring Azure Storage activities depend on Azure activity log services and to access this activity log we have three options and to know more information about Azure Storage account check below posts and for all of my posts in azure check this link (Latest Microsoft Azure Articles and Posts)

Activity log: it is like the event viewer in windows when you open the storage account you will find in the left side activity log if you open it you will find all of the activities you do it and when and who do it

Activity log on azure storage account

Log analytics: Search about log analytics on the Azure portal search and create new work space then on the left you will find container call “Work space data source” under it you will find Azure activity log if you click on it you will find your azure subscription just only connect the subscription to the log analytics then Go for the left side again and select Log and from here you can query your activity log using KQL query (Kusto Query Language). Look at this post to know more information about (Microsoft Azure Log Analytics).

Microsoft azure Log Analytics

Log Analytics on Activity log: we can add Log analytics as a solution on the activity log on Azure storage account to do that ( You Should Create first step 2 Log Analytics workspace > open Storage account > in the left side select activity log > on the top right side click on log > add > Select the log analytics Workspace you created it > then save > the refresh) IF you return to Log Analytics workspace in the left side select solution you will find the solution you created it.

Keep Following Me

Create Storage Account Using PowerShell and CLI Command


before Creating the Storage account i recommend to read these two articles (Microsoft Azure Storage Kind and Architecture & Managing and implementing Azure storage) first to know more information about the choices and options for Storage account. For more information about the all of the previous Posts and Articles related to Microsoft Azure services (Latest Microsoft Azure Articles and Posts)

IF you are interested to read more articles in the same subject here is below :

To create Storage account we should know some information needed for create process

  • Storage account Name: The name should be unique.
  • Resource Group: Storage account services should be created under resource group and it is recommended both to be in the same location for Example “East US”.
  • Location: Location of the Storage account it deepened on it the features of the storage account because not all features supported on all locations.
  • Account Kind: We have 5 Types (V1, V2, BlobStorage, BlockBlobStorage, FileStorge)
  • Storage Replication: Microsoft provide 6 types of replications depended on the locations and the storage account kind (LRS, ZRS, GRS, RA-GRS, GZRS, RA-GZRS)
Continue reading “Create Storage Account Using PowerShell and CLI Command”

Microsoft Azure Storage Kind and Architecture


Azure Storage it is the container for your data that you can save on it the Hot data and Cool data. but what is the best storage types i need it (Blob, File Shares, Tables, Queues)? and what is the Storage Performance and Storage kind (V1, V2,..) and what about the high availability and disaster recovery for my data.based on all of this options you will be able to determined the best azure storage kind for your Business. So before creating any Storage account you should consider the (Location, performance, Kind, replication, access tier)

After reading this post i recommend you to read this post to complete the full picture about how to manage azure storage and for more azure posts check this link by all of my azure posts and articles

IF you are interested to read more articles in the same subject here is below :

Azure Storage Location

When you are creating any resource in Azure Microsoft asking you about the location because not all locations have full azure features. That’s why the location is the the key that will determined on it the features you will have it on the Storage account. e.g. If you selected Australia Center and selected the performance premium storage you will have two kind of storage account only general Purpose V2 and General Purpose V1 but if you selected East US 2 you will have another choices in the storage kind like BlockblobStorage and FileStorage.

Continue reading “Microsoft Azure Storage Kind and Architecture”

Azure Data Explorer Cluster


Azure Data Explorer it is fully Microsoft managed services for data analytics that we can use it for real time analysis for big large of data streaming. With azure data Explorer we will have the availability to ingest massive of data from multiple sources and with azure data explorer we can start to query this massive of record using KQL (Kusto Query Language).

Keep Following this link to check all of my posts/ articles in azure services

Continue reading “Azure Data Explorer Cluster”

How to Export data from Azure SQL DB


Most of the peoples now looking for how to migrate the DB from on-premises to Azure and for this subjects, Microsoft provided us multiple solutions and services can be used for this request and for more information you can check my post (How to Migrate Database to Azure) that l already explained all of these services on it.But the question now can we take a backup from Azure SQL DB and restore it on our local SQL Server on-premises?

Answer yes but not with a normal process we know it backup and restore to know more information about azure backup check my post (Backup Tips on SQL Azure) we will use bacpac file using the Export option in Azure portal

To check my previous posts / articles on azure technology follow up this link

  • How to Export Azure SQL Database.
  • How to check Blob Files on Azure storage account
  • How to Copy the bacpac file.
  • How to import bacpac file into SQL Server
  • Notes and considerations
  • Resources and references
Continue reading “How to Export data from Azure SQL DB”

Azure Active Geo-Replication Services


Azure Active Geo-Replication Services is one of the powerful services in Azure used for replicating the SQL database data to another Regions using the same concept of always on data are readable on the another regions and synced on time , With Active Geo-Replication we can configure up to four readable secondary databases in the same or different data center locations (regions).

  • What is Azure Geo-Replication
  • What is Geo-Replication Mode
  • How to Configure Active Geo-replication
  • Geo-Replication Permission
  • Benefits from the secondary and Geo-Replication
  • How to Failover to Secondary
  • Checking the replication Status
  • Remove Geo-Replication
  • Conclusion
Active Geo-Replication
Continue reading “Azure Active Geo-Replication Services”

Azure Services for Monitoring and tuning Azure SQL Database


When we are talking about Performance tuning and Monitoring on Azure SQL Server, we should consider some services provided on azure supporting us in this task

  • Query performance insight.
  • Azure SQL Performance Recommendation Services
  • Azure SQL Analytics
  • Azure SQL Automatic Tuning Services
  • Diagnostics settings
  • Learning Resources
Azure SQL Database Monitoring Services
Continue reading “Azure Services for Monitoring and tuning Azure SQL Database”

Microsoft Azure Log Analytics


Azure Log Analytics it is Microsoft azure services help us to analyze and assess the logs from many resources for example we can push the logs from below resources to azure log analytics

  • On-premises servers logs (Windows Server Event Logs, Linux System Log) and this can do by installing agent on the server.
  • Logs of Azure matrices, alerts.
  • Logs of custom app.
  • Logs of Azure APP insight.
  • Logs of Azure resources diagnostics.

What we can do with these logs

For more information about Azure Log Analytics check this post

Services Depend on Log Analytics

Azure SQL Analytics it is Azure solution for advanced monitoring scenarios that allows you to collect and visualize important data related to the performance of your Azure SQL Database, elastic pools, and managed instances in a single place. It is based on Log Analytics, so it relies on the Log Analytics for more information check Microsoft article

For How to Start on Azure SQL Analytics check this post

Conclusion

Azure Log Analytics advanced services you can use it to dump all of your logs in one place and you can query the log to dive deep on it is very powerful tool from Microsoft azure Azure Log Analytic the simple definition for it , is Microsoft services used for log analysis from multiple sources Example we can configure the diagnostics setting in Azure SQL to push the logs for Log analytics direct or to keep it saved in Azure storage blog container and log analytics services can pull the logs from the storage containers. But How you can filter and search on this massive of logs. Microsoft provide us amazing option inside the log analytics that you can query your data on it and the use of it is very easy , this query depend on KQL Language (Kusto Query)

Announcement AZ-104: Microsoft Azure Administrator (beta) Released


Congratulation Microsoft announced the beta exam Az-104 Microsoft Azure Administrator and this is the replacement of Az-103 that will be retires on August 31, 2020. This mean still you can take the old exam version till August 31, 2020 when you pass the Exam Az-104 you’ll have earned your Azure Administrator Associate certification and it will be valid for two years.

Remember, the number of spots is limited to the first 300 candidates taking the AZ-104 beta exam on or before May 31, 2020. Please note that the beta exam is not available in Turkey, Pakistan, India, or China.

Schedule Your Exam Now AZ-104: Microsoft Azure Administrator (beta)

Advantage of taking beta Exam Microsoft announced that the first 300 people who take the AZ-104 beta exam on or before May 31, 2020, can get 80% off market price!

Learning Resource

Let’s do it Hope more success for all of you

Azure Subscription Administrator Roles Types


In Azure we have different roles types and as of now they are 3 types

  • Classic subscription administrator roles
  • Azure Active Directory (Azure AD) administrator roles
  • Azure role-based access control (RBAC) roles

Classic subscription administrator roles model

  • Account Administrator: user has full access
  • Server Administrator: user managing the services and assign Co-administrator role to user
  • Co-Administrator: Same as services administrator but with some limitations.

Azure Active Directory (AAD) administrator model Roles

  • Global Administrator: can manage all azure resources
  • Billing Administrator: Can Mange the Billing and Subscriptions
  • User Administrator: can add user inside the directory but outside the directory cannot add them.

Azure Role-Based Access Control (RBAC) model Roles

  • Owner Role: this meaning the user has full access to all resources and also can delegate role access for others users. It is same like Server administrator role in classic model roles.
  • Contributor Role: this user can create and manage resources but can’t delegate access to others users like owner role
  • Reader Role: this role means the users can view azure resources only.
  • User access administrator: Special account can access and manage all azure resources. And this account should be used by the azure admin only.
  • Built in Roles: we have more than 70 built in roles
  • Custom Role: administrator can custom some roles based on his needs using RBAC Services.

Latest Microsoft Azure Articles and Posts


In this post you will find all of the posts and articles related to Microsoft azure services keep following me

Azure Posts Road-Map

  1. All of my Azure Posts
  2. Az-103 Exam Certification Tips, Hints and Notes
  3. Azure Data Studio Posts
  4. Azure Storage Account Posts
  5. Azure VM Posts
  6. Azure SQL Database Posts
  7. Azure PowerShell and Cloud Shell Posts
  8. Azure Subscription Posts
  9. Azure Errors and issues Posts
  10. Other Azure Posts for other Services
Microsoft Azure Services

Az-103 Exam Certification Tips, Hints and Notes

  1. Microsoft Azure AZ-103 Tips, Hints and Notes Part 1
  2. Microsoft Azure AZ-103 Tips,Hints and Notes Part 2
  3. Microsoft Azure AZ-103 Tips,Hints and Notes Part 3
  4. Azure Administration AZ-103 Exam preparation and learning Resources 2020

Azure Data Studio

  1. How to Manage Azure with PowerShell Command from Azure Data Studio
  2. KQL in Azure Data Studio April 2020 Release

Manage Azure Storage Account

  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

Manage Azure VM

  1. Azure Virtual Machines Types,Series
  2. What is Azure AD Connect Sync Engine
  3. Virtual Machine (VM) Backup and Restore (Vault)
  4. Moving Azure VM Using Recovery Service Vault
  5. Azure VM Backup Soft Delete Security features

Manage Azure SQL Database

  1. Azure SQL Database Architecture
  2. Azure Database Deployment model options
  3. Azure Single Database Fundamental
  4. Azure SQL Database Elastic Pool Fundamental
  5. Azure SQL Database Managed Instance Fundamental
  6. Move Azure Single Database to SQL Elastic Pool
  7. How to Migrate Database to Azure
  8. Azure Active Geo-Replication Services
  9. Backup Tips on SQL Azure
  10. How to Export data from Azure SQL DB
  11. Azure Services for Monitoring and tuning Azure SQL Database
  12. Create Deadlock Alert on Microsoft Azure SQL
  13. Enabling Auto-Failover Group on Azure SQL

Manage Azure using PowerShell and CLI

  1. How to manage Azure using Windows PowerShell
  2. Moving Microsoft Azure Resources Using PowerShell
  3. Create Storage Account Using PowerShell and CLI Command
  4. Manage Azure Policy Using PowerShell

Manage Azure Subscription

  1. Azure Subscription Administrator Roles Types
  2. Manage Azure Policy Using PowerShell

Manage Azure Services

  1. Azure Log Analytics
  2. Azure Data Explorer Cluster

Azure Errors and Issues

  1. How to Solve Error Azure Recovery Services vault cannot be deleted
  2. The subscription is not registered to Microsoft.insights resource provider

All of the Posts

  1. Azure SQL Database Managed Instance Fundamental
  2. Move Azure Single Database to SQL Elastic Pool
  3. Azure SQL Database Elastic Pool Fundamental
  4. Azure Single Database Fundamental
  5. Azure Database Deployment model options
  6. Azure Administration AZ-103 Exam preparation and learning Resources 2020
  7. Microsoft Azure AZ-103 Tips,Hints and Notes Part 3
  8. Microsoft Azure AZ-103 Tips,Hints and Notes Part 2
  9. Microsoft Azure AZ-103 Tips, Hints and Notes Part 1
  10. Enabling Auto-Failover Group on Azure SQL
  11. KQL in Azure Data Studio April 2020 Release
  12. Microsoft Azure Storage Permission
  13. How to Manage Azure with PowerShell Command from Azure Data Studio
  14. Azure Date Transfer Solutions
  15. Azure Storage Geo-Replication
  16. Azure VM Backup Soft Delete Security features
  17. Copy Files to or from Azure Storage using Azcopy
  18. Create Deadlock Alert on Microsoft Azure SQL
  19. The subscription is not registered to Microsoft.insights resource provider
  20. Manage Azure Policy Using PowerShell
  21. How to Solve Error Azure Recovery Services vault cannot be deleted
  22. Sync your local files with Azure Storage Sync Service
  23. Moving Azure VM Using Recovery Service Vault
  24. Virtual Machine (VM) Backup and Restore (Vault)
  25. Moving Microsoft Azure Resources Using PowerShell
  26. How To Monitor Azure Storage Account
  27. Create Storage Account Using PowerShell and CLI Command
  28. Microsoft Azure Storage Kind and Architecture
  29. Azure Data Explorer Cluster
  30. How to Export data from Azure SQL DB
  31. Azure Active Geo-Replication Services
  32. Azure Services for Monitoring and tuning Azure SQL Database
  33. Azure Log Analytics
  34. AZ-104: Microsoft Azure Administrator (beta) Released
  35. Azure Subscription Administrator Roles Types
  36. What is Azure AD Connect Sync Engine
  37. Azure Virtual Machines Types,Series
  38. Managing and implementing Azure storage
  39. Azure SQL Database Architecture
  40. How to manage Azure using Windows PowerShell
  41. Backup Tips on SQL Azure
  42. How to Migrate Database to Azure

What is Azure AD Connect Sync Engine


When you are planning for Hyper model and you need to sync the identity between your local active directly on-premises to azure active directory at this time you will need to know what is Azure AD connect

Azure AD Conenct

Continue reading “What is Azure AD Connect Sync Engine”

Azure Virtual Machines Types,Series


Introduction

Microsoft provided us multiple types and series from Azure VM supported all of the workloads with many of options that we should consider it before going for moving your services to azure VM we should understand very well what is the VM types and what is the Microsoft recommendation for choosing the VM type based on the workload.

  1. Azure Virtual Machine Types
  2. Azure Virtual Machine series(Size)
  3. Virtual Machine Pricing.
  4. Learn more about Azure VMs

Azure VM

Continue reading “Azure Virtual Machines Types,Series”

Managing and implementing Azure storage


In this article I’ll cover +10 important points you need to cover them when you are going to understand Managing and implementing Azure storage

  1. Introduction
  2. What are the Types of Azure Storage account?
  3. What are the Azure Storage blob types?
  4. What are the Blob storage resources?
  5. What are the Azure Storage Firewall and Access Key?
  6. What is the Azure Storage Explorer?
  7. What are the Azure Storage Replication?
  8. What is the Azure blob Pricing?
  9. What are the Solutions for moving data to Microsoft Azure Blob storage?
  10. What is Azure Data Box?
  11. What is Azure CDN?
  12. What is the Azure backup Types?
  13. What is the SQL Server Backup limitation on Microsoft Azure Blob storage?
  14. What is the Azure Backup Monitoring ?
  15. References and another Important articles

Introduction

IF you are planning for (Az-103) Microsoft Azure Administrator Exam or new update from this certification (AZ-104) Microsoft Azure Administrator (beta) that will be available on or around April 2, 2020, you should take in your consideration implement and manage storage this part is (10-15%) from the exam . in this post I will share some important key note that can-do refresh for you in this part.

IF you are interested to read more articles in the same subject here is below :

Azure Storage

Continue reading “Managing and implementing Azure storage”

Azure SQL Database Architecture


There are four layers in Azure SQL Architecture most quite similar to on-premises

  • Client Layer
  • Service Layer
  • Platform Layer
  • Infrastructure Layer
  • Client Layer: Is the interface for applications to access a SQL database the client layer includes SQL Server tools, (ODBC), ADO.NET, (PHP) and Tabular Data Stream (TDS) is used to transfer data between a SQL database and applications. SQL Server also uses TDS to communicate with applications. This allows applications such as .NET, ODBC, ADO.NET, and Java to easily connect to Azure SQL Database without any additional requirements
  • Service Layer: acts as a gateway between the client and platform layers
  • Platform Layer: (SQL Server, Azure Fabric, Management Services) Azure Services Fabric is Responsible for Load Balancing , Automatic Failover and Automatic replication of the SQL Databases between Physical Servers https://docs.microsoft.com/en-us/azure/service-fabric/service-fabric-overview and Management Services takes care of an individual server’s health monitoring and patch updates.
  • Infrastructure Layer: Layer responsible for administrating the OS and physical hardware

How to manage Azure using Windows PowerShell


Introduction

#PowerShell, #Bash and #CLI, and the most common language now for how to manage #Azure are very helpful when you need to automate the tasks did you imagine that you can know provision new VM or new SQL on Azure using your mobile though azure mobile app with Powershell. 💥⛈

If you asked me what is the best? I will be told you nothing all of them are very powerful language and choosing which one of them depends on your past experiences If you are coming from background windows so the PowerShell is the most compatibles with you and if you are coming from Linux background Bash will be the most compatible with you.

Take Control of the Cloud with the Windows Azure PowerShell Cmdlets https://channel9.msdn.com/Events/TechEd/NorthAmerica/2013/WAD-B305#fbid=

How I prepare my local PC to be able to manage azure using theses language?

This is our post of today, all of us know that we have the availability to write PowerShell or Bach code from Azure portal itself😲 . But if we need to manage the portal from our PC, we need to install some tools and import some modules, at the end of the post you will find most of the tools and requirements and advanced tools you can use it on your local PC or on-Premises server to manage Azure.🦾

Note🚦: If you didn’t used Cloud shell before on Azure portal, when you start it portal will ask you to create Storage account for more information check this postStep by Step How to Enable Azure Cloud Shell in Microsoft Azure“🚀

Continue reading “How to manage Azure using Windows PowerShell”

Backup Tips on SQL Azure


Based on my Study i will list some tips and notes related to the backup on SQL Azure, I will be Happy if you ٍshared your knowledge, experiences and your review in the comment.

Continue reading “Backup Tips on SQL Azure”

How to Migrate Database to Azure


All of the markets now taking about azure and the new technologies in azure this means that all of us should learn what Is azure and what is the services related to our work in azure for example if you are SQL Server database administrator like Me, you should have fundamental information about azure services, and what is SQL Server types on azure and how we can manage azure SQL .

One of the most interesting topics for me How to migrate your SQL Server DB from on-premises to Azure, If you do search on google on this topic you will find many of articles talking about this subject, and based on my study I listed some notes that can help you on this subject

All of the information here depend on my study and search if something wrong I will be happy to correct me , and if there is extra information you know it related to this subject it will be great to share it on the comment for sharing the knowledge wit all of us I am highly recommend you to read the post first (https://www.thomasmaurer.ch/2019/01/azure-cloud-shell/)


Continue reading “How to Migrate Database to Azure”