If we want to delete the hidden files and folders from the C:\temp on the local computer, we need to use the command shown in this example.ExampleBut first, the below command helps us to retrieve the hidden files and folders from the C:\temp.Get-ChildItem C:\Temp -Hidden -RecurseWe just need to pipe the Remove-Item command and to remove forcibly use -Force parameter.Get-ChildItem C:\Temp -Hidden -Recurse | Remove-Item -Force -VerboseOutput

To delete empty files and folders, we need to first retrieve the list and which has been shown in the earlier articles.ExampleIn this article, we are using the logic that if we find an empty file or folder we will delete them. To implement that logic, use the below script.gci C:\Temp -Recurse | foreach { if($_.Length -eq 0){ Write-Output "Removing Empty File $($_.FullName)" $_.FullName | Remove-Item -Force } if( $_.psiscontainer -eq $true){ if((gci ... Read More

To get the list of empty folder on the windows OS using PowerShell, we can use the below method.gci C:\Temp -Recurse | foreach { if( $_.psiscontainer -eq $true){ if((gci $_.FullName) -eq $null){$_.FullName} } }The above command checks the C:\Temp folder and its subfolders and if the content is empty it returns the Folder full path. The PSISContainer property stands for the folder and GCI is the alias of the Get-ChildItem command. We can alternatively use the below command, instead of using the PSISContainer property.gci C:\Temp -Recurse -Directory | foreach { if((gci $_.FullName) -eq $null){$_.FullName} }

To get the list of empty files in Windows OS using PowerShell, there are two ways, a) Using Length parameter. We will count the length of the file. If it is 0 then the file is empty as shown below.Get-ChildItem C:\Temp\ -Recurse | where{$_.Length -eq 0} | Select @{N='EmptyFiles';E={$_.FullName}}Output:b) Another method is a long one that we don’t want to go into. We need to check each file's content and if it is empty then we will declare that file as an empty file.Get-ChildItem C:\Temp -Recurse -File | foreach{ if((Get-Content $_.FullName) -eq $null){ ... Read More

Sometimes changes in the Windows environment variable can be deadly because it saves information about user profiles, application information, and OS information. It is always better to keep the Environment backup handy and update that file whenever there are any changes or at the regular interval.Taking up the environment variables backup is easy. To retrieve the environment variable list we can use the below command, Get-ChildItem env:To store the environment variable, we can use the Out-File command with text file but if the particular environment variable length is larger enough then we can’t store it in the text file properly.Instead, ... Read More

The ConvertFrom-String command converts the String to the Hashtable format as shown below.ExamplePS C:\> "This is string" | ConvertFrom-StringOutputP1 P2 P3 -- -- -- This is stringIn the above example, We haven’t specified any header so that the output is separated the delimiter by space P1, P2 and continuous. By default, this command separates the string with a ‘=’ delimiter as shown below.Example$stringhash = @" Name = Spooler Starttype = Manual Status = Stopped "@ $stringhash | ConvertFrom-StringDataOutputName Value ---- ----- ... Read More

ExampleFor example, we have a below-created hashtable.PS C:\> $servicehash = @{Name='Spooler';State='Stopped';StartType='Automatic'} PS C:\> $servicehashOutputName       Value ----       ----- Name       Spooler StartType  Automatic State      StoppedWe need to add multiple values to the Name Key. If we directly append the value to the key it will treat it as a string and we will not get the desired output. See the example below.ExamplePS C:\> $servicehash.Name += "Winrm" PS C:\> $servicehashOutputName Value ----       ----- Name       SpoolerWinrm StartType  Automatic State      StoppedSo to add the multiple ... Read More

In this post, we will understand the difference between 3NF and BCNF.3NFThere shouldn’t be any transitive dependency.There shouldn’t be any non-prime attribute that depends transitively on a candidate key.It is not as strong as BCNF.It has high redundancy.The functional dependencies are already present in INF and 2NF.It is easy to achieve.It can be used to achieve lossless decomposition.BCNFFor any relation A->B, ‘A’ should be a super key of that specific relation.It is stronger than 3NF.The functional dependencies are present in 1NF, 2NF and 3NF.It has low redundancy in comparison to 3NF.The functional dependencies may or may not be preserved.It is ... Read More

In this post, we will understand the difference between linear regression and logistic regression.Linear RegressionIt helps predict the variable that is continuous, and is a dependent variable.This is done using a given set of independent variables.It extrapolates a line to find the value of dependent variable.Least square methods are used to estimate the accuracy.The best fit line is found, that helps predict the output.It is generally a continuous value.The relation between the dependent variable and independent variable has to be linear.The independent variables may have collinearity between them.It is considered a machine learning problem, i.e an applied statistics problem.Logistic RegressionIt ... Read More

In this post, we will understand the difference between clustered index and non-clustered index.Clustered indexIt is quick.It requires less memory to perform operations.The index is the main data.A table can have one clustered index only.It has inherent ability to store data on the disk.It can store pointers to block not to data.The leaf nodes contain actual data.The clustered key defines the order of data within table.It is a type of index where the table records are physically reordered to match with the index.Non-clustered indexIt is slower.It requires more memory to perform operations.The index is a copy of data.A table can ... Read More