Ismail and To7a Event Materials | MSPs | ITPros Microsoft Egypt

Ismail & To7aHi all,
In this blog we gonna talk about all the details, materials of ismail & to7a MSP | ITPros | Microsoft Egypt Event.

  1. Network Fundamentals by | Andrew Adel Younan
    Presentation :
    MVA Course and Certificate :

  2. Database Fundamentals by | Nermeen El Sayed
    Presentation :
    MVA Course and Certificate :

  3. Server Virtualization by | Helmy Mohamed
    Presentation :
    MVA Course and Certificate :

  4. Powershell by | Amr Ahmed
    Presentation :
    Book :
    MVA Course and Certificate :

  5. Cloud Computing by | Mohamed Abdelrahman
    Presentation :
    MVA Course and Certificate :

  6. Security by | Nihal El Ansary
    Presentation :
    MVA Course and Certificate :

  7. Career Path by | Mohamed Bassem
    Presentation :
    Courses and Certificates :

Finally we wanna thank Ismail Habib thanks a lot ismail for your support, thanks Mohamed Gaafer, BIG thank for the HR – Marcom MSP teams, thanks Amr Saad and thanks for all 🙂

ITPros | MSP Egypt Team 

Microsoft Virtual Academy

What is MVA?

Successful technologists never stop learning and great technology never stops evolving. Microsoft Virtual Academy (MVA) offers online Microsoft training delivered by experts to help technologists continually learn, with hundreds of courses, in 11 different languages.Cloud Geek Our mission is to help developers, knowledgeable IT professionals and advanced students learn the latest technology, build their skills, and advance their careers. MVA is free of charge, and the entire service is hosted on Windows Azure. Become an MVA member so that you can earn points for your learning, achieve different levels of badges and status relative to others in your country or around the world, and get certificates when you complete an entire course. Your personal dashboard helps you track your progress against your personal learning plans.

Let’s start Registration sign in 1 2 with your mail and now you are an MVA member and you can see your account and setting From the navigation pane you can access your account, courses, Live events and others.3 From Courses you can see MVA courses and products and download Microsoft eBook  8 when you scroll down you can see MVA courses and Products6 Again scroll down, you can see New courses and Recent News4 From the right part you can see your Learning Plan and edit it 5 Top students Global and Local Popular courses7


After some courses you need to see your Progress and your Points Join My Dashboard 9

My Learning plan 10 Courses in progress and Completed which you can download PDF certificate of Completion11 Top Students in MVA and in Egypt WEEKLY, MONTHLY and ALL TIME 12

Installing SharePoint 2013 on Network Load Balance windows server 2012

Our lab scenario

SP Arc

Configure NLB between the 2 servers which play as a SharePoint servers

Install a SQL Server which will contain the SharePoint Database

Now let’s configure SharePoint on Server 1

Open the installation icon and install the prerequisites



When the installation complete Click on Install SharePoint Server


Enter product key, Accept Terms, Continue and Install Now


Run the SharePoint Configuration Wizard



Create a new server Farm on Server 1 and Click on Next.


Enter Database server name “SQL1Fov”.

Enter the User Name and the Password

SQL Access

Enter Passphrase.


Specify port number.


Click Next. and now the Configuration is completed.


Click on Finish button. This will open Central Admin web page as a URL


Now the SharePoint server 1 installation finished let’s configure the Second Server and connect it to the Farm.

Choose Connect to an existing server farm

2-connect to server farm

Click yes to start the services


Type the name of SQL Server which contain the existing sharepoint Farm Database and Retrieve Database to see our configured Database

3-Database serverEnter the Passphrase Password and click next



5-configure SQL database

Wait for the Configuration

6- Finall configuration

Now the second Server configuration finished and we have a 2 SharePoint servers running SharePoint 2013 on a Network Load Balance and Connected to SQL Server 2014 Failover Clustered Database.

SharePoint 2013 AppFabric Installation Error

when you try to install SP2013 in offline mode all Prerequisites installation success but AppFabric Not ! so let’s try to solve this Problem.SharePoint Error

copy the source files of SharePoint to c:\SP2013 and copy the Prerequisites to the Prerequisites folderSP2013 Files

uninstall AppFabric from control panel uninstall Appfabric

open CMD and run the following command

 c:\SP2013>prerequisiteinstaller.exe /AppFabric:prerequisiteinstallerfiles\WindowsServerAppFabricSetup_x64.exe


system will restart.. once it open again sharepoint installation will restarted successfully.Installation

DFS Replication on a Windows Server 2012 R2 Failover Cluster

Preparing for the Lab 

Lab Scenario

Lab Scenario

The first Step is to create a V-Disk on the Storage Server for each Office

  1. Open Server Manager
  2. Add Roles and select iSCSI role and Finish
  3. Open iSCSI and Create V-Disks and Targets for each office and the Replication Group Servers and Finish
    Targets And V-Disks
  4. create one Target and add the 2 Nodes on it as an initiator
  5. Create the V-Disks for each Office
  6. On each node we connect to the V-Disks using iSCSI Initiator from server manager and Bring disk online. 

Now we have a 4 V-Disks connected to Servers

DFs1 and DFS2 Office1 connected to Office1.vhdx

DFS3 and DFS4 office2 connected to Office2.vhdx

RG1 and RG2 Replication office connected to 2 V-Disks for Replication and Failover Clustering

The Second Step is to Configure a Windows Failover Cluster between Nodes of  each office

  1. Open DFS1 and DFS2 Servers Server Manager
  2. From roles select failover cluster and finish
  3. Open Failover Cluster Manager Validate and Create a Failover Cluster between DFS1 and DFS2
  4. Create the Same steps of Failover between the Nodes of other Offices “Office 2  DFS3, DFS4 and Replication group Office RG1, RG2“.

The Third step is to configure the File Server Role on the Failover cluster on the First office and the second office

  1. Open failover cluster manager
  2. On Roles Configure a new role and select File Server Role FirstOfficeFS
  3. Create the same steps on the other offices which play as a file server ” Office 2 ” SecondOfficeFs

**When you configure File Server you have to create a shared Folder on the 2 offices which contains the Replicated data

Test 1 For Office1 and Test 2 for Office 2

DFS RG shared Folders

The Fourth Step is to Configure a DFS Replication between the 2 offices

  1. on the RG1 Server open DFS Management and Configure a DFS between the 2 offices using the Name of the Failover Cluster FirstOfficeFS and SecondOfficeFS

The Last Step is to Configure a Replication group for data collection

  1.  On RG1 Server open server manager-tools-DFS Management and open Replication
  2. Select New replication group and choose New Replication group for data collection
  3. Select the Branch Server and the Hub Server ” Office 1 and Office 2 “ we create a cluster between nodes so i’ts better to deal with the cluster name ” FirstOfficeFS and SecondOfficeFs ”  not the Servers name 
  4. In our lab i will add the Domain Controller AD as a third node in the Replication Group so now after add the AD we have a 3 way replication from and to the 3 Locations we have.
  5. the Replication will contains FirstOfficeFS, SecondOfficeFS, and the AD ServerReplication Group


SQL Server 2014 top New Features

let’s talk about the Top New Features of SQL Server 2014 SQL14

  1. In-Memory across Workloads Built-in
  2. Scalability Enhancement and Availability
  3. Power BI For Office 365
  4. Backup Encryption
  5. Microsoft Azure Integration

In-Memory across Workloads Built-in

It’s allows you to create memory-optimized database objects that enable more efficient data access **Remember select only Highly Utilized tables to be In-Memory**

that’s will improve performance by as much as 10 times, and improves scalability by 2-5 times.Per

It does this be minimizing the latency it takes to retrieve data.

This feature will be great for applications that need performance, have relatively short transactions, have a high degree of concurrent transactions with many connectionsIn-Memory

Scalability Enhancement and Availability

The number of logical processors has been increased to 640 and memory up to 4 TBs.

If SQL Server running in a virtual environment it’s up to 64 virtual processors and 1TB of memory

If you have a clustered SQL Server environment it’s will support up to 64 different nodes.

ABOUT High Availability the number of secondary Replica maximum from four to eight.


Power BI For Office 365

It’s a cloud-based business intelligence (BI) solution which provides data navigation and visualization capabilities

Power BI for Office 365 includes Power Query , Power Map , Powerpivot, and Power ViewBI

Backup Encryption

It’s the ability to encrypt database backups. SQL Server 2014 supports several encryption algorithms; including Advanced Encryption Standard You must use a certificate or an asymmetric key to perform encryption for SQL Server 2014 backups.0572.1

More info about Backup Encryption

 Microsoft Azure Integration

It’s the Ability to Automatic/Manual Backup to Azure Environment and Working with Azure Secondary Replica and storage. we can set an Availability Group resides in Azure when the Primary Replica Failure happens we can switch Manual but we can still working and Report to/from databaseAzure

Windows Server 2012 R2 Network Load Balancing NLB

You can configure Network Load Balancing to enhance the scalability and availability of server applications.

  1. Open Server Manager
  2. Add roles and features
  3. From features
  4. Network Load Balancing
  5. Open server manager from tools choose NLB Manager Screenshot (98)
  6. Click on Network load balane and choose New Cluster Screenshot (102)
  7. Type the  name of VM which play as and NLB and click Connect Screenshot (103)
  8. Priority it’s by default 1 and click NextScreenshot (104)
  9. Add IPv4 adress from the Network subnet and the subnet maskScreenshot (106)
  10. Chosse the Cluster operation mode in this case we choose Malticast and click Next , FinishScreenshot (108)Screenshot (109)
  11. Once thw NLB configured and the Status is Converged click on the NLB and choose Add Host To ClusterScreenshot (110)
  12. Type the name of the Second Node to add to the NLB Cluster and ConnectScreenshot (111)
  13. Add Host and click NextScreenshot (112)
  14. Configure the Port number and click FinishScreenshot (113)
  15. On the DC open DNS and create new recorde for NLB Cluster and Add Host Screenshot (114)
  16. Now the NLB configured let’s bing and Make sure that’s Working Screenshot (115)