ststeiger

sudo apt-get remove --purge google-chrome-stable
cd ~/Downloads
wget https://dl.google.com/linux/direct/google-chrome-stable_current_amd64.deb
sudo dpkg -i google-chrome-stable_current_amd64.deb
sudo apt-get update


sudo dpkg-divert --divert /usr/bin/original-google-chrome-stable --rename /usr/bin/google-chrome-stable

dpkg-divert --list

ststeiger

SELECT 
	 sch.name AS referenced_schema 
	,o.name AS referended_object 
	,o.type_desc AS referenced_object_type

	-- ,pk_cols.COLUMN_NAME AS primary_key_column
FROM sys.sql_expression_dependencies AS d 
JOIN sys.objects AS o ON d.referenced_id = o.object_id 
JOIN sys.schemas AS sch ON sch.schema_id = o.schema_id 

ststeiger

SELECT TOP 100 
     qt.text AS sql_query 
	,qs.last_execution_time 
	,qs.execution_count 
	,sd.name AS db 
FROM sys.dm_exec_query_stats AS qs 

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt 

ststeiger

enum ByteFormatMode {
  Binary,   // 1024-based (KiB, MiB, GiB - IEC standard)
  Decimal,  // 1000-based (KB, MB, GB - SI standard)
  Pseudo    // 1024-based but uses KB/MB/GB (Windows-style)
}

function formatBytes(bytes: number, mode: ByteFormatMode = ByteFormatMode.Binary): string {
  const suffixesBinary = ["bytes", "KiB", "MiB", "GiB", "TiB", "PiB", "EiB", "ZiB", "YiB", "RiB", "QiB"];
  const suffixesDecimal = ["bytes", "KB", "MB", "GB", "TB", "PB", "EB", "ZB", "YB", "RB", "QB"];
  const suffixesPseudo = ["bytes", "KB", "MB", "GB", "TB", "PB", "EB", "ZB", "YB", "RB", "QB"];

ststeiger

https://www.perplexity.ai/search/can-you-find-me-information-re-Kv6Kcel1R..clYeGhwa6xg

OK, so to put this down to the Level of an intelligent 12year old: 

First normal form is violated if 
A) cells have multiple values inside the same cell (e.g. separated by separator)  
or 
B) there are repeating columns for the same thing, e.g. Tel1, Tel2, Tel3, 

ststeiger

Step 1: Install IIS .NET-Core Hosting-Bundle

[Use this permalink][2] from https://learn.microsoft.com/en-us/aspnet/core/host-and-deploy/iis/hosting-bundle?view=aspnetcore-9.0#install-the-net-core-hosting-bundle

The bundle file is called something along the lines of dotnet-hosting-<VER>-win.exe

ststeiger

;WITH CTE AS 
(
	          SELECT NULL AS CLV_Value 
	UNION ALL SELECT '123' AS CLV_Value 
	UNION ALL SELECT '[1,2,3]' AS CLV_Value 
	UNION ALL SELECT '{"0": 1234}'
	UNION ALL SELECT '{
	  "json": "[]",
	  "svg": null,

ststeiger

@echo off
title PostgreSQL Portable
cls

:: set default code page
chcp 1252 > nul

:: initialise a new database on first use
if not exist "%PGDATA%" (
    echo.

ststeiger

SELECT 
	 sch.name AS table_schema 
	,tp.name AS table_name 
	,schFK.name AS fk_schema 
	,fk.name AS fk_name 
	,STUFF
	(
		(
			SELECT ', ' + c.name 

ststeiger

SELECT 
	 -- name 
	DISTINCT collation_name
FROM sys.databases
WHERE (1=1) 
-- AND name = 'tempdb';

SELECT name, collation_name 
FROM sys.databases
WHERE (1=1)