Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Difference Between Star and Snowflake Schema
In this post, we will understand the difference between star schema and snowflake schema.Star SchemaHierarchies of dimensions are stored in a dimensional table.It contains a fact table that is surrounded by dimension tables.In this schema, a single join creates the relationship between a fact table and any dimension tables.It is a simple database design.It has high levels of data redundancy.The processing of cube is quick.A single dimension table contains the aggregated data.It is a de-normalized data structure.The queries run quickly in comparison to other schema.It uses start join query optimization technique. Hence, the queries perform well.Tables can be connected with ...
Read MoreHow to delete the Azure Resource Group using PowerShell?
To delete the azure resource group using PowerShell, we need to use the Remove-AZResourceGroup command. But before using this command, make sure that no usable resources exist in the resource group that you want to delete.To check if the resources are available in the resource group, use the below command. Here we are using the TestRG resource group name.ExampleGet-AzResource -ResourceGroupName TestRGOnce you are confirmed that you need to delete the Resource Group then use the below command to delete the resource group.ExampleRemove-AzResourceGroup TestRG -Force -VerboseWhen you use the -Force parameter, you won’t be prompted for deletion confirmation.
Read MoreHow to Export the Azure VMs using PowerShell?
To export the azure VMs using PowerShell, we first need to get their desired properties. The cmdlet Get-AZVM will get all the VMs connected to the particular subscription. To export them to the CSV file we can use the below command.ExampleGet-AzVM | Export-Csv .\AZVMs.csv -NoTypeInformationOnce you run the above command, you will notice that you get all the properties of the VM, and sometimes they are not needed. To get the particular properties of the VM use the Select-Object (alias Select) command.ExampleGet-AzVM | Select Name, ResourceGroupName, Location, @{N='VMSize';E={$_.HardwareProfile.VmSize}} | Export-Csv .\AzureVms.csv -NoTypeInformationIf you want to export the VMs from a ...
Read MoreHow to create a new Azure resource group using PowerShell?
Azure Resource Group is a container that stores the resources like Virtual Machines, Storage, IP addresses, etc. To create a new Azure Resource group, we need to use the New-AZResourceGroup command.To use this cmdlet, you first need to connect to the Azure account, and then if you want to create a resource group for the particular subscription you need to select that subscription.To create a new resource group, you need the location for the resource group. The below code will first connect to your Azure account, selects the Azure subscription, and then creates a new resource group.Example$ErrorActionPreference = "Stop" Connect-AzAccount Set-AzContext -SubscriptionName 'Enter your subscription name here' New-AzResourceGroup -Name 'TestRG' -Location 'Central US' -Tag @{'RG'='APP'}OutputResourceGroupName : TestRG ...
Read MoreHow to get the azure resources from the resource group using PowerShell?
To get the available resources from the resource groups using PowerShell, we need to use the Get-AZResource command. Suppose we have the resource group name AnsibleTestRG and we need to retrieve the resources from the resource group, then we will use the below command.ExampleGet-AzResource -ResourceGroupName AnsibleTestRGTo filter the output, OutputGet-AzResource -ResourceGroupName AnsibleTestRG | Select Name, ResourceType, LocationOutputIf there are multiple resource groups in the particular subscription, we can use the below commands to export the resources from the resource group to the CSV file.Example$ErrorActionPreference = "Stop" try { Connect-AZAccount Set-AzContext -SubscriptionName 'Your Subscription Name' $rgs = Get-AzResourceGroup ...
Read MoreHow to check if the Azure resource group is empty or not using PowerShell?
To check if the resource group is empty or not we need to check if the resource group contains any resources.For this example, We have a resource group name called the TestRG and we need to check if it is empty.Example$resources = Get-AzResource -ResourceGroupName TestRG if($resources){"Resource group is not empty"} else{"Resource group is empty"}OutputResource group is emptyTo check if the resource groups in the particular subscription are empty or not, use the below code.OutputConnect-AZAccount Set-AzContext -SubscriptionName 'Your Subscription Name' $rgs = Get-AzResourceGroup Write-Output "Empty Resource Groups" foreach($rg in $rgs.ResourceGroupName){ $resources = Get-AzResource -ResourceGroupName $rg if(!($resources)){ $rg } }
Read MoreHow to create a temporary file using PowerShell?
To create a temporary file with the PowerShell, we can use the New-TemporaryFile command. This command creates a temporary file tmp.tmp where NNNN represents the random hexadecimal number.ExamplePS C:\> New-TemporaryFile Directory: C:\Users\Administrator.AUTOMATIONLAB\AppData\Local\Temp Mode LastWriteTime Length Name ---- ------------- ------ ---- -a---- 4/10/2021 9:14 PM 0 tmpF624.tmpThe output path is selected based on the path defined at Path.GetTempPath() https://docs.microsoft.com/
Read MoreHow to get the disk performance using PowerShell?
To get the disk performance using PowerShell, we need to use the Performance counter of the disk. There are performance counters available for the Physical disk or the logical disk. To check what the disks related counter sets are available we can use the below command, ExamplePS C:\> Get-Counter -ListSet "*disk*" | Select CounterSetNameOutputCounterSetName -------------- FileSystem Disk Activity Storage Spaces Virtual Disk LogicalDisk PhysicalDiskWe will use a Logical disk to get more information about it. We will retrieve its counter first.ExampleGet-Counter -ListSet LogicalDisk | Select -ExpandProperty CounterOutputWe need to retrieve the Disk read time counter, ExampleGet-Counter -Counter '\LogicalDisk(*)\% Disk Read ...
Read MoreHow to get the windows performance counter using PowerShell?
To get the Windows Performance counter using the Powershell, we can use the Get-Counter cmdlet.There are various performance counters available to measure the performance of the windows operating system. Get-Counter cmdlet is used to retrieve the performance of the local or the remote systems with the specific counter name.When you just run a Get-Counter command, it shows the main basic counters like Nic, Processor, disks, etc on the local system. as shown below.ExamplePS C:\> Get-Counter Timestamp CounterSamples --------- -------------- 4/7/2021 7:41:42 PM ...
Read MoreHow to plot the lines first and points last in Matplotlib?
To plot the lines first and points last, we can take the following Steps −Create xpoints, y1points and y2points using numpy, to draw lines.Plot the curves using the plot() method with x, y1 and y2 points.Draw the scatter points using the scatter method.To display the figure, use the show() method.Exampleimport numpy as np from matplotlib import pyplot as plt plt.rcParams["figure.figsize"] = [7.50, 3.50] plt.rcParams["figure.autolayout"] = True xpoints = np.linspace(1, 1.5, 10) y1points = np.log(xpoints) y2points = np.exp(xpoints) plt.plot(xpoints, y1points) plt.plot(xpoints, y2points) for i in xpoints: plt.scatter(i, np.random.randint(10)) plt.show()Output
Read More