Skip to content

Instantly share code, notes, and snippets.

View ststeiger's full-sized avatar
😎
Back from holidays

Stefan Steiger ststeiger

😎
Back from holidays
154 followers · 3 following
  • Switzerland
View GitHub Profile
@ststeiger
ststeiger / pgsql.cmd
Last active October 14, 2024 17:48
Batch-start PostGreSQL on Windows
@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
ststeiger / Find_MultiValue_FKs.sql
Created September 24, 2024 11:56
Find multi-column foreign-keys in MSSQL
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
ststeiger / CollationInfo.sql
Created September 20, 2024 15:12
Show info about collation
SELECT
-- name
DISTINCT collation_name
FROM sys.databases
WHERE (1=1)
-- AND name = 'tempdb';
SELECT name, collation_name
FROM sys.databases
WHERE (1=1)
@ststeiger
ststeiger / Task_Promise_Equivalent.cs
Created September 9, 2024 17:06
Syntax Comparison Promises with C# and JavaScript
namespace BaristaLabs.SkinnyHtml2Pdf.Web
{
/*
function waitForEvent()
{
return new Promise((resolve, reject) =>
{
@ststeiger
ststeiger / computed_columns_dependencies.sql
Created August 22, 2024 12:01
Figure out which computed column depends on which column
SELECT
cc.schema_name
,cc.table_name
,cc.computed_column_name
,dc.name AS dependent_column_name
,fk.REFERENCED_TABLE_SCHEMA AS referenced_table_schema
,fk.REFERENCED_TABLE_NAME AS referenced_table_name
,fk.REFERENCED_COLUMN_NAME AS referenced_column_name
@ststeiger
ststeiger / await_worker_request.htm
Last active August 20, 2024 16:19
Awaiting a worker request in JS
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="Cache-Control" content="no-cache, no-store, must-revalidate">
<meta http-equiv="Pragma" content="no-cache">
<title>Awaiting Worker Request</title>
@ststeiger
ststeiger / uuid.txt
Last active August 20, 2024 14:08
How to generate GUID/uuid-V4 in different programming languages
// .NET
System.Guid.NewGuid().ToString()
// JS:
function generateUUID() {
return 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function(c) {
var r = Math.random() * 16 | 0, v = c == 'x' ? r : (r & 0x3 | 0x8);  
@ststeiger
ststeiger / Fix_Default_Value_MSSQL.sql
Created July 24, 2024 12:38
Fix an MS-SQL default-value for table-column
DECLARE @schemaName nvarchar(128);
DECLARE @tableName nvarchar(128);
DECLARE @columnName nvarchar(128);
DECLARE @constraintName nvarchar(128);
DECLARE @dropConstraintSQL nvarchar(MAX);
SET @schemaName = 'dbo';
SET @tableName = 'T_ChecklistVersion';
SET @columnName = 'CLV_Obsoleted';
@ststeiger
ststeiger / computed_columns.sql
Last active July 24, 2024 10:00
List computed columns definition
SELECT
s.name AS schema_name
,t.name AS table_name
,cc.name AS column_name
,cc.definition AS computed_column_definition
,COLUMNPROPERTY(cc.object_id, cc.name, 'ordinal') AS ordinal_position
-- ,sys_ordinal_position.derived_ordinal_position
FROM sys.computed_columns AS cc -- damn, object_id refers to table
INNER JOIN sys.tables t ON cc.object_id = t.object_id
@ststeiger
ststeiger / How_to_disable_jcef.txt
Last active July 21, 2024 14:32
JetBrains Rider disable jcef jcef.enabled
./options/ide.general.xml: <entry key="ide.browser.jcef.enabled" value="false" />
/root/.config/JetBrains/Rider2024.2/options/ide.general.xml
<application>
<component name="GeneralSettings">
<option name="reopenLastProject" value="false" />
<option name="confirmExit" value="false" />