Explore information related to install azure powershell

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


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


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


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


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


Gradle Installation and Configuration on Linux

This guide will show the steps to install and configure Gradle on Linux and Windows.

Read More