Mustafa EL-Masry SQl server Administration

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” →
Mustafa EL-Masry #Azure

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” →
Mustafa EL-Masry SQl server Administration

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” →
Mustafa EL-Masry #Azure, Azure VM

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” →

Mustafa EL-Masry #Azure, Azure Storage services

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” →