Get-ChildItem : Invalid Path

Posted by Barac in Powershell on Nov 13th, 2017 | 0 comments

Using UNC paths when working with PowerShell providers. There are errors you can encounter using UNC paths if your current provider is different then filesystem. PowerShell will just use the current one. We can use the Get-PSProvider cmdlet to get full list of the PSProviders available on our system. My current one is filesystem. So lets test this. I will use one simple PowerShell script to delete all sub-folders and files from network folder. $FolderNetworkPath="\\10.0.0.102\test\" Write-Output ((Get-Date -Format g) + " - Delete Files and Subfolders From Network Folder") Get-ChildItem -Path...

Powershell / Credentials / Connect to SQL Server with PowerShell

Posted by Barac in Powershell, SQL Server on Nov 10th, 2017 | 2 comments

How to login using SQL Server Management Object (SMO) For windows authentication #################################################################### ####################### Windows Authentication ##################### #################################################################### [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | out-Null $s = new-object ('Microsoft.SqlServer.Management.Smo.Server') "InstanceName" $s.ConnectionContext.LoginSecure=$true $s.Databases | select name, size, status #################################################################### ...

Powershell / Backup SQL Server DBs to Azure Storage with Powershell script

Posted by Barac in Azure, Powershell, SQL Server on Oct 4th, 2017 | 5 comments

With this simple script, you can backup all databases to Azure daily, you can hardcode the parameters values or you can use task manager to pass them to the PS script. You need to have Azure PowerShell modules installed on your machine (how to). First off all, let’s try just to connect to your Azure Storage Account You can use azure credential-publishsettings file to do that, or putting the variables with access key, subscription and storage account name as in this example: #Variables param ( [string]$AzureKey= "AzureStorageAccessKey", [string]$AzureSubs= "YourSubscription", [string]$AzureStor=...