gitfvb

Show tables with rows and size

SELECT
t.NAME AS TableName,
MAX(p.rows) AS RowCounts,
(SUM(a.total_pages) * 8) / 1024.0 as TotalSpaceMB,
(SUM(a.used_pages) * 8) / 1024.0 as UsedSpaceMB,
(SUM(a.data_pages) * 8) /1024.0 as DataSpaceMB

gitfvb

# source: https://stackoverflow.com/questions/52094271/how-to-remove-emojis-from-a-filename-using-powershell
$regexReplace = "(?:[\u2700-\u27bf]|(?:\ud83c[\udde6-\uddff]){2}|[\ud800-\udbff][\udc00-\udfff]|[\u0023-\u0039]\ufe0f?\u20e3|\u3299|\u3297|\u303d|\u3030|\u24c2|\ud83c[\udd70-\udd71]|\ud83c[\udd7e-\udd7f]|\ud83c\udd8e|\ud83c[\udd91-\udd9a]|\ud83c[\udde6-\uddff]|[\ud83c[\ude01-\ude02]|\ud83c\ude1a|\ud83c\ude2f|[\ud83c[\ude32-\ude3a]|[\ud83c[\ude50-\ude51]|\u203c|\u2049|[\u25aa-\u25ab]|\u25b6|\u25c0|[\u25fb-\u25fe]|\u00a9|\u00ae|\u2122|\u2139|\ud83c\udc04|[\u2600-\u26FF]|\u2b05|\u2b06|\u2b07|\u2b1b|\u2b1c|\u2b50|\u2b55|\u231a|\u231b|\u2328|\u23cf|[\u23e9-\u23f3]|[\u23f8-\u23fa]|\ud83c\udccf|\u2934|\u2935|[\u2190-\u21ff])"
get-childitem -path D:\Apteco\Build\Hubspot\extract -Filter "*.txt" | ForEach {
    $f =$_
    $fName = $f.FullName
    $fNameTemp = "$( $fName ).tmp"
    Get-Content -Path $fName -Encoding UTF8 | ForEach { $_ -replace $regexReplace } | Set-Content -Path $fNameTemp -Encoding UTF8
    Rem

gitfvb

$webserverProcess = [scriptblock]{

    param(
        [uri]$redirect
    )

    Add-Type -AssemblyName System.Web

    $http = [System.Net.HttpListener]::new() 

gitfvb

You can use this example command in PowerShell or maybe CMD

& "C:\Program Files\gs\gs10.01.1\bin\gswin64c.exe" -q -dNOPAUSE -dBATCH -dSAFER -sDEVICE=pdfwrite -dCompatibilityLevel="1.4" -dPDFSETTINGS=/screen -dEmbedAllFonts=true -dSubsetFonts=true -dColorImageDownsampleType=/Bicubic -dColorImageResolution=144 -dGrayImageDownsampleType=/Bicubic -dGrayImageResolution=144 -dMonoImageDownsampleType=/Bicubic -dMonoImageResolution=144 -sOutputFile="output.pdf" "input.pdf"

gitfvb

This is also especially important for german locale systems

Define longitude and latitude variables in Designer as Numeric with Precision of 4 and Geographic Format Latitude or Longitude. The name of the variable is not important.

The best is to create a csv file that contains the store number, name and the columns Longitude and Latitude. Best is tab delimited. The coordinates in this file should also use the . as decimal place as the server is doing the calculation in expressions. To use the file to visualise your stores on a map, please use , as a decimal place for lat/long. So in the end you need a file for server calculation and another file for client visualisation.

Then to bring the stores together with the customers make an expression like

gitfvb

# Define the function to use
Function Times-Two {
    param($j)
    $j*2
}

# Define all functions you want to load into parallel runspaces
# The reason to do this is that functions are not available in the runspaces like variables

gitfvb

Create a service account like here

That creates and downloads you a json file (that should not be shared in public)

With this code (mostly created with Co-Pilot) from pwsh/Powershell Core, you can send a message via httpv1:

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.