Florian von Bracht gitfvb

Steps to solve.

Remove all 1.0.0.1 packages (also x86) from PowerShellGet and PackageManagement module folders
Replace nuget.exe in C:\Users\<username>\AppData\Local\Microsoft\Windows\PowerShell\PowerShellGet
Install a current .NET SDK
When using a German OS, replace this line in C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\2.2.5\PSModule.psm1
Possibly avoid VPN connection for publishing

 #$stdOut -match "Successfully created package '(.*.nupkg)'" | Out-Null

Install python (if not already done) and modules

Download and install python: https://www.python.org/downloads/

Then open a powershell window and install flask

pip install flask

To change the priority of the current running powershell process, do it like

#-----------------------------------------------
# SET UP PRIORITY
#-----------------------------------------------

$processId = [System.Diagnostics.Process]::GetCurrentProcess().ID
$currentPriority = ( get-process -Id $processId ).PriorityClass
If ( $currentPriority -ne "High" ) {

Documentation: https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.diagnostics/get-counter?view=powershell-5.1

Show all available counters, be careful, this seems to be language dependent

get-counter -listset * | Out-GridView
get-counter -listset "*Netzwerk*" | fl
get-counter -listset "*Netzwerk*" | % { $_.Counter }

PowerShell

This works for PowerShell >= 5.1

You need to install the AWS tools beforehand with

Install-Module -Name AWS.Tools.Installer
Install-AWSToolsModule S3

Show last queries and parameter

SELECT TOP 1000 * FROM(SELECT COALESCE(OBJECT_NAME(s2.objectid),'Ad-Hoc') AS ProcName,
  execution_count,s2.objectid,
    (SELECT TOP 1 SUBSTRING(s2.TEXT,statement_start_offset / 2+1 ,
      ( (CASE WHEN statement_end_offset = -1
  THEN (LEN(CONVERT(NVARCHAR(MAX),s2.TEXT)) * 2)
ELSE statement_end_offset END)- statement_start_offset) / 2+1)) AS sql_statement

Here I can write down some notes

	################################################
	#
	# INPUT
	#
	################################################

	#-----------------------------------------------
	# DEBUG SWITCH
	#-----------------------------------------------


	# Remove previous jobs first
	Get-Job \| Remove-Job

	$runs = 100
	$maxThreads = 10
	$start = [datetime]::Now
	$c = 0 # completed jobs
	$sum = 0 # sum of results

	Install-Dependencies.ps1 -LocalPackage DuckDB.NET.Bindings.Full, DuckDB.NET.Data.Full
	Import-Dependencies.ps1 -LoadWholePackageFolder
	$conn = [DuckDB.NET.Data.DuckDBConnection]::new("Data Source=:memory:;")
	$conn.Open()
	...
	$conn.Close()