Explore information related to azure


Time Based Temporary Group Membership in Active Directory on Windows


Basically, Temporary Group Membership (Time Based) is the version of Active Directory in Windows Server 2016 introduces an interesting feature that allows you to temporarily add a user to an AD security group. In order to use the Temporary Group Membership, you need to enable the Privileged Access Management Feature in your Active Directory forest. Like with AD Recycle Bin (which allows you to recover deleted objects), you cannot disable PAM after it has been enabled.

Read More



Setting remote desktop drain mode on a Windows Server RDS host


This article covers how to set remote desktop drain mode on a Windows Server RDS host. Basically, setting remote desktop drain mode on a Windows Server RDS host can be easily performed with PowerShell. The Drain Mode is used when a server administrator needs to maintain a server (install Windows updates, configure or update apps) without affecting the availability of the entire RDS farm. 

When you set the RDS host in drain mode state, the RDS host can no longer accept new connections but existing sessions continue working until users log out. You can monitor the status of the RDS host in Horizon Administrator.


To remove a Remote Desktop Session Host (Uninstall the RD Session Host Role Service) :

  • Open Server Manager.
  • In the left pane, expand Roles.
  • Right-click Remote Desktop Services, and then click Remove Role Services.
  • On the Select Role Services page, clear the Remote Desktop Session Host check box, and then click Next.
  • On the Confirm Removal Selections page, click Remove.

Read More



Active Directory Temporary Group Membership on Windows Server 2016


This article covers how to implement  Active Directory Temporary Group Membership on Windows Server 2016. Temporary Group Membership is a new feature that appeared in Windows Server 2016 and is a part of the Privileged Access Management (PAM) functionality.


By default, PAM is not active and the first thing you need to do is turn it on. You can do this with the PowerShell cmdlet Enable-ADOptionalFeature. For example, to enable PAM in domain contoso.com, run the following command with domain administrator privileges:

Enable-ADOptionalFeature -Identity ″Privileged Access Management Feature″ -Scope ForestOrConfigurationSet -Target ″contoso.com″

Read More



Set-ADUser Modify Active Directory Users with PowerShell - Do it now ?


This article covers how to use Set-ADUser Modify Active Directory Users with PowerShell.

Basically, the Set-ADUser cmdlet is part of the Active Directory module for Windows PowerShell.


The Identity parameter specifies the Active Directory user to modify. 

You can identify a user by its distinguished name, GUID, security identifier (SID), or Security Account Manager (SAM) account name. 

You can also set the Identity parameter to an object variable such as $<localUserObject>, or you can pass an object through the pipeline to the Identity parameter.

Read More



iisnode encountered an error when processing the request - Fix it Now ?


This article covers methods to resolve "iisnode encountered an error when processing the request" error.

Basically, this iisnode error triggers when the application pool doesn't have enough permissions to write to the current folder. 

Therefore, you need to Allow, 'Full Control', for user 'IIS_IUSRS', from 'Advanced Security' upon right clicking your application root directory.


This error simply denotes that Your application pool doesn't seem to have enough permissions to write to the current folder.

1. You can either edit the permissions to give the IIS_IUSRS group write permissions to that folder

2. Go into the advanced settings menu and under Process Model -> Identity change the user account to a user that already has write permissions.

Read More



Microsoft SQL Server Error 916 - Fix it now


This article covers method to resolve Microsoft SQL Server Error 916 for our customers.

The main problem is due to bugs present in SQL Server Management Studio that prevents the user to connect to the database and refuses to display the database list.

How to solve Microsoft SQL server error 916:
If you receive the following error while using Microsoft SQL Server Management Studio 2008:
The server principal "username" is not able to access the database "dbname" under the current security context. (Microsoft SQL Server, Error: 916).

Causes of SQL Server Error 916:
1. The user is not permitted to view the data of selected column within the database.
2. The database is currently not available.
3. There are multiple columns such as Size, Space available, Data Space Used, Default file group, Index Space Used, Mail host, Primary file path and user has added at least one of them to the list of Object Explorer Details.
4. If the Auto Close option for the database is enabled, then Collation column cannot be retrieved by SQL Server Management Studio (SSMS).
5. For a database, Collation column contains NULL.

In order to view the granted permissions for the guest-user, the following command is helpful if run by a member of a Sysadmin fixed server.
The query is as follows:

USE msdb;
 SELECT prins.name AS grantee_name, perms.*
 FROM sys.database_permissions AS perms
 JOIN sys.database_principals AS prins
 ON perms.grantee_principal_id = prins.principal_id
 WHERE prins.name = ‘guest’ AND perms.permission_name = ‘CONNECT’;
 GO

On running the above command, a table is presented to the user containing all the attributes of guest user.
However, an empty result shows that guest user is disabled in the database and again the SQL Server error 916 will be displayed.
To overcome the error you may perform the following available solutions.

To fix this SQL server error 916:
1. In Object Explorer, click databases.
2. Display "Object Explorer Details" (F7) or "View –> Object Explorer Details".
3. Right-click the column headers and deselect "collation".
4. Refresh the databases.

Read More



Install ClickHouse on Ubuntu 20.04 - Step by step process to perform it


This article covers how to install ClickHouse on Ubuntu. Basically, ClickHouse is an open-source analytics database developed for big data use cases. 

Install of ClickHouse on Ubuntu involves a series of steps that includes adjusting the configuration file to enable listening over other IP address and remote access. 


Column-oriented databases store records in blocks grouped by columns instead of rows. 

By not loading data for columns absent in the query, column-oriented databases spend less time reading data while completing queries. 

As a result, these databases can compute and return results much faster than traditional row-based systems for certain workloads, such as OLAP.


Online Analytics Processing (OLAP) systems allow for organizing large amounts of data and performing complex queries. 

They are capable of managing petabytes of data and returning query results quickly. 

In this way, OLAP is useful for work in areas like data science and business analytics.


Aggregation queries are queries that operate on a set of values and return single output values. 

In analytics databases, these queries are run frequently and are well optimized by the database. 


Some aggregate functions supported by ClickHouse are:

1. count: returns the count of rows matching the conditions specified.

2. sum: returns the sum of selected column values.

3. avg: returns the average of selected column values.


Some ClickHouse-specific aggregate functions include:

1. uniq: returns an approximate number of distinct rows matched.

2. topK: returns an array of the most frequent values of a specific column using an approximation algorithm.


You can set up a ClickHouse database instance on your server and create a database and table, add data, perform queries, and delete the database.

You can start, stop, and check the ClickHouse service with a few commands.

To start the clickhouse-server, use:

$ sudo systemctl start clickhouse-server

The output does not return a confirmation.

To check the ClickHouse service status, enter:

$ sudo systemctl status clickhouse-server

To stop the ClickHouse server, run this command:

$ sudo systemctl stop clickhouse-server

To enable ClickHouse on boot:

$ sudo systemctl enable clickhouse-server

To start working with ClickHouse databases, launch the ClickHouse client. 

When you start a session, the procedure is similar to other SQL management systems.

To start the client, use the command:

$ clickhouse-client

Read More



Enable and Configure MPIO on Windows Server 2016 2012 R2


This article covers how to enable Multi-Path Input-Output or MPIO on a Windows server either from a graphical interface using the Server Manager console or from the PowerShell command line. 

Multipathing is the technique of creating more than one physical path between the server and its storage devices. It results in better fault tolerance and performance enhancement. Oracle VM Servers are installed with multipathing enabled because it is a requirement for SAN disks to be discovered by Oracle VM Manager.


To Install MPIO in Windows Server 2008 R2:

Note You must restart the server after you follow these steps.

1. Open Server Manager. To do this, click Start, click Administrative Tools, and then click Server Manager.

2. In Server Manager, click Features, and then click Add Features.

3. Select the Multipath I/O feature for installation, and then click Next.

4. Finish the installation by confirming the selections, and then restart the server.


To Configure MPIO for StorSimple volumes:

MPIO must be configured to identify StorSimple volumes. 

To configure MPIO to recognize StorSimple volumes, follow these steps:

1. Open the MPIO configuration. To do this, click Start, click Administrative Tools, and then click MPIO.

2. In the MPIO window, click Add on the MPIO Devices tab.

3. Type SSIMPLE Model in the Add MPIO Support window under Device Hardware ID.

4. Restart the server when you are prompted.


To Mount a StorSimple volume in Windows Server 2008 R2:

After MPIO is configured on the server, volumes that are created on the StorSimple appliance can be mounted and can take advantage of MPIO for redundancy. 

To mount a volume, follow these steps:

1. Open the iSCSI Initiator Properties dialog box on the server. To do this, click Start, click Administrative Tools, and then click iSCSI Initiator.

2. In the iSCSI Initiator Properties dialog box, click the Discovery tab, and then click Discover Portal.

3. Type the IP address of the "DATA" port on the StorSimple appliance.

Note If you use a private network for iSCSI connections, type the IP address of the DATA port that is connected to the private network.

4. Click the Targets tab in the iSCSI Initiator Properties dialog box. This displays the StorSimple appliance iSCSI qualified name (IQN) in the Discovered Targets section.

5. Click Connect to establish the iSCSI session with the StorSimple appliance. In the Connect To Target dialog box, click to select the Enable multi-path check box.

6. Open Server Manager. To do this, click Start, click Administrative Tools, and then click Server Manager.

7. In Server Manager, click Storage, and then click Disk Management. Volumes that are created on the StorSimple appliance and that are visible to this server appear under Disk Management as new disks.

8. Initialize the disk and create a new volume. During the format process, select a block size of 64 kilobytes (KB).

9. Under Disk Management, right-click the disk, and then click Properties.

10. In the SSIMPLE Model #### Multi-Path Disk Device Properties dialog box, click the MPIO tab, click Details in the DSM Name section, and then verify that the parameters are set to the default parameters.

Read More



Adding users to the local admin group in PowerShell


This article covers how to add users to local admin group either via Group Policy Objective or directly via command line. 


To add a user to the local group in PowerShell:

You can add AD groups or users to the local admin group using the below Powershell command.

Add-LocalGroupMember -Group "Administrators" -Member "domain\user or group," "additional users or groups."


To add a user to the local admin group:

1. Right-click the newly created Group, select Properties, navigate to the Members tab, click Add… and enter designated users to the group, e.g. domain\administrator, domain\domain admins, domain\syskitmonitorservice. 

2. Add other users that also need administrative privileges, if necessary. 

3. Click OK to proceed.


To get local admin group members in PowerShell:

To get the local Administrators group members using PowerShell, you need to use the GetLocalGroupMember command. 

This command is available in PowerShell version 5.1 onwards and the module for it is Microsoft. PowerShell. LocalAccounts.


To Create a User Account in Windows 10 with PowerShell:

1. Open PowerShell as Administrator.

2. To create a new user account without a password, type New-LocalUser -Name "user_name" -Description "Description of your new account." -NoPassword .

3. To create a user account that has a password, firstly execute the following line: $Password = Read-Host -AsSecureString .

Read More



Uninstall Azure ad PowerShell Module - Steps to do it


This article covers how to uninstall the #Azure #PowerShell module and AzureRM module from MSI and PowerShellGet.

To uninstall all official PowerCLI modules except VMware.PowerCLI, run the following command: 

(Get-Module VMware.PowerCLI -ListAvailable).RequiredModules | Uninstall-Module -Force


When you want to uninstall the program, you can go to the Programs and Features to uninstall it. 

So when you want to uninstall Windows Azure SDK and Windows Azure Tools for Microsoft Visual Studio (the first solution is to uninstall it via Programs and Features.


How do I uninstall Windows PowerShell?

Uninstall PowerShell from Start Menu. 

1. You can click Start menu at the bottom-left, type PowerShell in the search box, and you will see Windows PowerShell app. 

2. Right-click Windows PowerShell app, and select Uninstall, or expand the menu in the right to select Uninstall to remove Windows PowerShell exe from Windows 10.


To Install VMware PowerCLI Module From PC With Internet Connection:

1. From a computer with an internet connection open powershell (preferrably as an administrator)

2. Find-Module -Name VMware.PowerCLI.

3. Install-Module -Name VMware.PowerCLI -Scope CurrentUser.

4. Get-Command -Module *VMWare*


To use Azure PowerShell in PowerShell 5.1 on Windows:

1. Update to Windows PowerShell 5.1. If you're on Windows 10 version 1607 or higher, you already have PowerShell 5.1 installed.

2. Install . NET Framework 4.7.

3. Make sure you have the latest version of PowerShellGet. Run Install-Module -Name PowerShellGet -Force .

Read More



Best practices for Azure Cache for Redis


This article will guide you on some of the Best practices for Azure Cache for Redis. By following these best practices, you can help maximize the performance and cost-effective use of your Azure Cache for Redis instance.


1. Use Standard or Premium tier for production systems. The Basic tier is a single node system with no data replication and no SLA.

2. Remember that Redis is an in-memory data store. 

3. Develop your system such that it can handle connection blips because of patching and failover.

4. Configure your maxmemory-reserved setting to improve system responsiveness under memory pressure conditions.

5. Redis works best with smaller values, so consider chopping up bigger data into multiple keys.

6. Locate your cache instance and your application in the same region. Connecting to a cache in a different region can significantly increase latency and reduce reliability. 

7. Reuse connections. Creating new connections is expensive and increases latency, so reuse connections as much as possible. 

8. Configure your client library to use a connect timeout of at least 15 seconds, giving the system time to connect even under higher CPU conditions.

Read More



Install Azure PowerShell module


This article will guide you on how to install the Azure PowerShell module using the cmdlets method and through offline.

Azure CLI is available on #Windows, Mac, Linux, etc. Azure cloud shell is another option that can be browser-accessible and authenticated. 

Azure cloud shell gives you options to choose from either bash or Powershell. 

The Get-Command cmdlet gets all #commands that are installed on the computer, including cmdlets, aliases, functions, filters, scripts, and applications. 

Get-Command gets the commands from #PowerShell modules and commands that were imported from other sessions.

We can use Windows Powershell for managing Azure resources by installing az module.

To install the Azure PowerShell #module, run the following command. Make sure that the Windows PowerShell ISE is opened in "run as administrator” mode. 

By default, the PowerShell gallery is not configured as a Trusted repository for PowerShellGet. 

Click on “Yes to All” to continue with the installation.


Modules included in Azure PowerShell:

1. Azure PowerShell Az. Automation.

2. Azure PowerShell AzureRM. Automation.

3. Other PowerShell modules.

4. Internal Orchestrator. AssetManagement. Cmdlets module.

5. Python 2 modules.

6. Custom modules that you create.

Read More



Troubleshoot Azure Cache for Redis timeouts


This article will guide you on how to troubleshoot Azure #Cache for Redis #timeouts. Azure Cache for Redis regularly updates its server software as part of the managed service functionality that it provides. 

Azure Cache for #Redis is a fully managed, in-memory cache that enables high-performance and scalable architectures. Use it to create cloud or hybrid deployments that handle millions of requests per second at sub-millisecond latency—all with the configuration, security, and availability benefits of a managed service.

This patching activity takes place largely behind the scene. During the failovers when Redis server nodes are being patched, Redis clients connected to these nodes may experience temporary timeouts as connections are switched between these nodes.


To help mitigate #Azure memory issues:

1. Upgrade the cache to a larger size so that you aren't running against memory limitations on the system.

2. Set expiration times on the keys so that older values are evicted proactively.

3. Monitor the used_memory_rss cache metric. When this value approaches the size of their cache, you're likely to start seeing performance issues. Distribute the data across multiple shards if you're using a premium cache, or upgrade to a larger cache size.


To fix #CPU bound on the server or on the client:

i. Check if you're getting bound by CPU on your client. High CPU could cause the request to not be processed within the synctimeout interval and cause a request to time out. 

ii. Moving to a larger client size or distributing the load can help to control this problem.

iii. Check if you're getting CPU bound on the server by monitoring the CPU cache performance metric. Requests coming in while Redis is CPU bound can cause those requests to time out. To address this condition, you can distribute the load across multiple shards in a premium cache, or upgrade to a larger size or pricing tier.

Read More



Azure Cache for Redis client-side issues


This article will guide you on troubleshoot Azure #Cache for Redis client for issues and fix common Redis #error.

Azure Cache for Redis gives you the ability to use a secure open source Redis cache. It is a dedicated offering managed by Microsoft, to build highly scalable and responsive applications by providing you super-fast access to your data.

All #Redis #data resides in the server's main memory, in contrast to databases such as PostgreSQL, Cassandra, MongoDB and others that store most data on disk or on SSDs.

The way to test for this in Redis is to simply query the key. If the key is empty, populate it. If it is a string use get (or exists).

To configure a storage account for your cache metrics:

1. In the Azure Cache for Redis page, under the Monitoring heading, select Diagnostics.

2. Select + Add diagnostic setting.

3. Name the settings.

4. Check Archive to a storage account.

5. Select Configure to choose the storage account in which to store the cache metrics.

Read More



git fetch failed with exit code 1


This article will guide you on how to get rid of Git fetch error and also the causes of this error. To fix git fetch failed with exit code 1 error, simply add an explicit --force, checking for syntax error, and verifying the configuration file for its properness in case sensitivity. 

Read More



Azure PowerShell context objects How to manage them


This article will guide you on how to manage #Azure #PowerShell #context #objects. Azure PowerShell context objects are to hold subscription and authentication information. 

Azure PowerShell is basically an extension of #Windows PowerShell. It lets Windows PowerShell users control Azure's robust functionality. From the command line, Azure PowerShell programmers use preset scripts called cmdlets to perform complex tasks like provisioning virtual #machines (#VMs) or creating #cloud services.

To select Azure subscription in PowerShell:

1. Enter Login-AzAccount and hit enter, then provide your user id and password.

2. Get-AzureSubscription (this will give you the list of subscription).

3. Select-AzureRmSubscription -SubscriptionId xxxxx-xxxxx-xxxxxx-xxxx (this way you can set which particular subscription you want to use).

Read More



How to create bacpac file from SQL server


This article will guide you on how to export an existing #database into a #BACPAC file is through #SSMS. A bacpac is a dacpac + data, while a dacpac only contains the schema of the database.

To create a Bacpac file:

a. To #export a database using the Azure portal, open the page for your database and click Export on the toolbar.

b. Specify the BACPAC filename, select an existing Azure storage account and container for the export, and then provide the appropriate credentials for access to the source database.

c. Click OK.

To import from a BACPAC file into a new single database using the Azure portal:

1. Open the appropriate server page.

2. On the toolbar, select Import database. 

3. Select the storage account and the container for the BACPAC file and then select the BACPAC file from which to import.

Read More



Data Loss through Partial loss of keys in Azure Cache for Redis


This article will guide you on the different methods to fix data loss in #Azure #Cache for #Redis which can happen due to a number of reasons like Redis instance failure, incorrect #database selection, and so on. 

Redis server saves all its data to HDD from time to time, thus providing some level of persistence. It saves data in one of the following cases: automatically from time to time. when you manually call BGSAVE command.

Redis does not use #tables, and stores data in #memory, and is not limited by the hard #disk I / O speed when reading and writing #data, so the speed is extremely fast.

Read More



How to monitor Azure Cache for Redis


This article will guide you on how to monitor Azure Cache for Redis. Azure Cache for #Redis uses #Azure Monitor to provide several options for monitoring #cache instances. These include view metrics, pin #metrics charts to the Startboard, customize the date and time range of monitoring charts, and so on.

To Use Azure Redis Cache:

1. Log into Azure port, go to #Databases >> Redis Cache.

2. Create a news Redis Cache.

3. Get the Access Keys to connect with the newly created Redis Cache.

4. Install the #StackExchange. 

5. You can add Redis Cache connection string into the appsettings.

Read More



How to Use PowerShell to Quickly Find Installed Software


This article will guide you on how to get the list of all installed #software using #PowerShell. 

i. First, open PowerShell by clicking on the Start menu and typing “powershell”. 

ii. Select the first option that comes up and you'll be greeted with an empty PowerShell #prompt. 

iii. PowerShell will give you a list of all your #programs, complete with the version, name of the developer, and even the date you installed it.

Read More



Monitor Azure virtual machines with RDP


This article will guide you on how to monitor virtual #machines #RDP using Azure.
You can View performance directly from an Azure VM:
1. In the #Azure portal, select Virtual Machines.
2. From the list, choose a #VM and in the #Monitoring section choose Insights.
3. Select the #Performance tab.

Read More



Zabbix Single Sign-On SSO Authentication in Active Directory


This article will guide you on how to set #Zabbix : Single Sign-On (#SSO) Authentication in #Active Directory which helps users authenticate the Zabbix frontpage without entering credentials.
Users and resources are added to the directory service for central management and ADDS works with authentication protocols like #NTLM and #Kerberos. Thus, users that belong to ADDS can authenticate from their #machines and get access to others #systems that integrate with ADDS. This is a form of Single Sign-on.

Read More



Method to store uploaded files in Azure using a Drupal CMS


This article will guide you on how to store the uploaded #files inside Azure in a Drupal #CMS. The Windows #Azure #Blob module allows for the uploading and storing of files on the Windows Azure #storage service. 

Read More



Selecting the number of vCPUs and Cores for a Virtual Machine


This articles will guide you when selecting the number of vCPUs and Cores for a Virtual Machine which depends on the operating system used and some other factors.

Basically, When Selecting the Number of #vCPUs and #Cores for a Virtual Machine, you can use all CPU #resources allocated to a virtual machine, it must see one 8 core #processor, 2 vCPUs with 4 cores each or 1 vCPU with 4 cores in two threads instead of 8 vCPUs.

Read More



Azure CLI create CDN


This article will guide you on the steps to create Azure CLI CDN.

What is #Azure #CDN?

Azure Content Delivery #Network (CDN) lets you reduce load times, save #bandwidth and speed responsiveness—whether you are developing or managing #websites or mobile #apps or encoding and distributing #streaming #media, gaming #software, firmware updates or IoT endpoints.

Azure CDN from #Microsoft provides Azure customers the ability to deliver content from Microsoft's own global CDN network.

Read More



Steps to deploy DACPAC with SSMS


This article will guide you on the steps to deploy DACPAC which involves registering a DAC instance by storing the DAC definition in the #msdb system database. 

A DAC is a self-contained unit of #SQL Server #database deployment that enables data-tier developers and database administrators to package SQL #Server objects into a portable artifact called a #DAC package, also known as a #DACPAC.

Read More



Configuring Azure Multi factor authentication


This article will guide you on the complete process to set up Azure multi-factor authentication.

Read More



Steps to install OpenLiteSpeed on CentOS


This article will guide you on how to perform installation of OpenLiteSpeed on Centos Server.

Read More



Steps to install Wraith on Ubuntu


This article will guide you on how to install Wraith on Ubuntu which requires adding Ruby, ImageMagick, and some other dependencies added to the system.

Read More



How to use PowerShell to identify Azure unassociated resources


With the PowerShell tool, we can easily find unassociated resources in Azure.

Read More



How to optimize azure cache for redis


Factors such as memory pressure, high CPU usage, Bandwidth limitations, and Server loads on server side can result in poor performance of Azure Cache for Redis and the Server in general.

Read More



Fix Error sql72014


Most Clients often experience SQL server error in the process of creating a new database, importing, exporting and doing other sql query actions on their database.

Read More




For Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on LinuxAPT.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com






Focus on your business, not your servers.

Click Here to Learn More