Florian von Bracht gitfvb

Here you can buy a cheap ESP32 but with some good features that are worth having a detailed look: https://eckstein-shop.de/HIMALAYAMatrix-CoreESP32EntwicklerboardmitESP32-BitWiFi2BBluetoothIoTDEVBoard

So I have ordered one and realised, that board is not listed in the esp32 boards in Arduino. Same for Platformio in VSCode. So I have tried to use the generic ESP32 board, which worked fine for a simple test as you can see here in the video.

Recording.2022-05-30.15-46-37.From.Snipclip-1.mp4

Deactivate WIFI

Check your current network status with

ifconfig

If your wifi has an ip address, it is still connected and active. Deactivate it temporarily with

To show all installed apps, use this

Get-AppxPackage -AllUsers * | Out-GridView

or something like

Get-AppxPackage -AllUsers * | Select Name, PackageFullName | ft

Show last executed queries on sqlserver

SELECT deqs.last_execution_time AS [Time]
	,dest.TEXT AS [Query]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
WHERE lower(dest.TEXT) LIKE '%binaries%'
ORDER BY deqs.last_execution_time DESC

Used the following files from nuget

        FileDescription                        CompanyName           FileVersionRaw
        ---------------                        -----------           --------------
        Microsoft.Bcl.AsyncInterfaces          Microsoft Corporation 4.700.20.21406
        Npgsql                                 Npgsql                4.0.12.0
        System.Buffers                         Microsoft Corporation 4.6.28619.1
        System.Memory                          Microsoft Corporation 4.6.28619.1

if you have multiple columns and want to calculate the differences in seconds and milliseconds, a query like this can help to produce output like in the csv file in this gist.

This is the query

select
	"timestamp"
	,strftime('%f',julianday("inserted")-julianday("timestamp")) "Timestamp to inserted"
	,strftime('%f',julianday("response_calculated")-julianday("inserted")) "Response calculated"
	,strftime('%f',julianday("response_timestamp")-julianday("response_calculated")) "API Call finished"



	function Test-Credential {
	[CmdletBinding()]
	param (
	[Parameter(
	Mandatory = $false
	,ValueFromPipeLine = $true
	#,ValueFromPipelineByPropertyName = $true
	)]


	<#

	# A helpful code snippet to change console encoding

	# Change encoding of powershell console (this does not change [System.Text.Encoding]::Default
	ping \| Out-Null
	# Change the console output to UTF8
	$originalConsoleCodePage = [Console]::OutputEncoding.CodePage
	[Console]::OutputEncoding = [text.encoding]::utf8

	<#

	Sometimes it is hard to make sure a function passes an array back if it is only one element
	With @( ) you can make sure you have an array, even with one element. But in the function to always return an array,
	do something like below, inspired by https://evotec.xyz/powershell-returning-one-object-from-function-as-an-array/

	#>

	Function Do-Foo() {

	# Check the installed capabilites

	Get-WindowsCapability -Online \| Where-Object Name -like 'OpenSSH*'

	# Install OpenSSH Server

	Add-WindowsCapability -Online -Name OpenSSH.Server~~~~0.0.1.0

	# Start service and set it automatically
	Start-Service sshd