- Settings -> Windows Update
- Install all updates
- launch Windows Powershell as administrator and execute:
| using System.Collections.Generic; | |
| using System.Windows; | |
| using System.Windows.Media; | |
| namespace Hardcodet.Wpf.Util | |
| { | |
| /// <summary> | |
| /// Helper methods for UI-related tasks. | |
| /// </summary> | |
| public static class TreeHelper |
| $destinationDirectory = "C:\LocalNuGetTest\" | |
| $webClient = New-Object System.Net.WebClient | |
| $webClient.Credentials = New-Object System.Net.NetworkCredential("USERNAME", "PASSWORD") | |
| $feed =[xml]$webClient.DownloadString("https://hostednugetfeed.com/custom-feed/nuget/v2/Packages") | |
| $records = $feed | select -ExpandProperty feed | select -ExpandProperty entry #| select -ExpandProperty content | |
| for ($i=0; $i -lt $records.Length; $i++) { | |
| $content = $records[$i] | select -ExpandProperty content | |
| $properties = $records[$i] | select -ExpandProperty properties |
| -- list all functions in schema | |
| SELECT proname, prosrc | |
| FROM pg_catalog.pg_namespace n | |
| JOIN pg_catalog.pg_proc p | |
| ON pronamespace = n.oid | |
| WHERE nspname = 'public'; | |
| -- list all tables in schema | |
| SELECT * FROM information_schema.tables | |
| WHERE table_schema = 'public' |
Useful information that developers should know, even when skimming content.
| $userPath = $env:USERPROFILE | |
| $pathExclusions = New-Object System.Collections.ArrayList | |
| $processExclusions = New-Object System.Collections.ArrayList | |
| $pathExclusions.Add('C:\Windows\Microsoft.NET') > $null | |
| $pathExclusions.Add('C:\Windows\assembly') > $null | |
| $pathExclusions.Add($userPath + '\AppData\Local\Microsoft\VisualStudio') > $null | |
| $pathExclusions.Add('C:\ProgramData\Microsoft\VisualStudio\Packages') > $null | |
| $pathExclusions.Add('C:\Program Files (x86)\MSBuild') > $null | |
| $pathExclusions.Add('C:\Program Files (x86)\Microsoft Visual Studio') > $null |