The velocity of change for the Microsoft SQL Server DBA has increased this decade. The spanbetween the releases of SQL Server 2016 and 2017 was only 16 months, the fastest new releaseever. Gone are the days when DBAs had between three to five years to soak in and adjust to newfeatures in the engine and … Read more
When you trying to connect to the Windows Server Remote Desktop Session Host (RDSH), you may encounter the following error message: The remote session was disconnected because there are no Remote Desktop License Servers available to provide a license. Please contact the server administrator. This issue appears because the server fails to contact the licensing … Read more
Getting the Windows OS Version on specific OU is very useful for System Administrator. For example for the upgrade plan or system architecture plan. Before we continue, you have to import the Active Directory Module for Windows PowerShell with the following command: Import-Module activedirectory For your information, In PowerShell 3.0 and above, this module is imported by … Read more
What is Hyper-V Data Exchange Service (KVP) Hyper-V Data Exchange Service is one of the Integration Services on Hyper-V that provides a mechanism to exchange basic metadata between the virtual machine and the host. The data exchange service (KVP) shares small amounts of machine information between Virtual Machine and the Hyper-V host using key-value pairs (KVP) … Read more
Receive Segment Coalescing (RSC) in Hyper-V vSwitch is a feature in Windows Server 2019 and Windows 10 October 2018 Update that helps reduce host CPU utilization and increase throughput for virtual workloads by coalescing multiple TCP segment into fewer but larger segment. RSC is enabled by default on the external vSwitch. RSC in the vSwitch … Read more
What are Automatic Virtual Machine Activation (AVMA) license keys? Automatic Virtual Machine Activation (AVMA) is a feature that handles the Windows Server activation process for an instance of Windows Server as a VM Guest on Hyper-V Server. AVMA lets you install virtual machines on a properly activated Windows server without having to manage product keys … Read more
Managing windows update using PowerShell command is very helpful once the GUI is not available such as Windows Server Core or using PowerShell Remote. There are many ways managing Windows Update using PowerShell, through this article, I will show how to manage Windows Update using PowerShell Module created by MichalGajda. This module called PSWindowsUpdate, allows you to … Read more
Performing regular database backup is very important to avoid data loss. In this article, we will create a PowerShell Script to backup MySQL databases. Basically, the backup is using mysqldump command. This is an executable file that stored in MySQL installation folder under bin folder. So let’s start scripting : You can set a Task Scheduler to … Read more