gitfvb

Good reference here: https://copdips.com/2018/05/setting-up-powershell-gallery-and-nuget-gallery-for-powershell.html

Here can you see your current clients to gather scripts, modules and packages

Get-PackageProvider

and you will get something like

gitfvb

MIT License

Copyright (c) 2022 Apteco GmbH

Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:

gitfvb

The initial source is nuget. So download the latest nuget.exe from https://dist.nuget.org/win-x86-commandline/latest/nuget.exe and put it into a subdirectory.

Then open PowerShell or cmd, go to that directory of nuget.exe and install the package with all dependencies:

.\nuget.exe install Snowflake.Data

Then you can create a directory for Designer like C:\Program Files\Apteco\FastStats Designer\Providers\snowflake and just put all folders that were downloaded from nuget into that. Next time you are opening Designer you should see Snowflake then.

gitfvb

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE OR ALTER      TRIGGER [dbo].[new_login] on [dbo].[Logins] AFTER INSERT as
 --declare @UserName varchar(50);
begin

gitfvb

Sometimes you don't want to load all the data, only smaller pieces to get a better extract performance. Or maybe do a bigger load once a while and then do daily or hourly incremental extracts. Together with discarding extracts (to enforce a reload of fresh and not fixed or finished data), you can create a pretty powerful combination.

To get this done I have experimented with the different options. To do this I have extracted the training data in Designer and loaded it into a SQLITE database (with DB Browser). Then I have configured the following for bookings, because that should be loaded incremental.

• Custom Query

SELECT *
FROM bookings

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

gitfvb

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

gitfvb

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

gitfvb

To show all installed apps, use this

Get-AppxPackage -AllUsers * | Out-GridView

or something like

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

gitfvb

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