Skip to content

Instantly share code, notes, and snippets.

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

Stefan Steiger ststeiger

😎
Back from holidays
149 followers · 3 following
  • Switzerland
View GitHub Profile
@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" />
@ststeiger
ststeiger / FileRightsModifier.cs
Created June 5, 2024 11:32
Give full rights to everyone
namespace HubSpotClient.Trash
{
internal class FileRightsModifier
{
@ststeiger
ststeiger / Maddy_SSL.sh
Created June 1, 2024 16:45
Maddy SSL Configuration
# Create a private key for example.int:
# Generate a private key for the domain example.int:
openssl genpkey -algorithm RSA -out /etc/maddy/certs/example.int/privkey.pem -pkeyopt rsa_keygen_bits:2048
# Generate a CSR for example.int:
# Create a Certificate Signing Request (CSR) using the private key:
openssl req -new -key /etc/maddy/certs/example.int/privkey.pem -out /etc/maddy/certs/example.int/example.int.csr -subj "/C=US/ST=California/L=San Francisco/O=My Company/OU=IT Department/CN=example.int"
@ststeiger
ststeiger / View_Dependencies.sql
Created May 28, 2024 16:14
List view-dependencies in MS-SQL
SELECT DISTINCT referenced_schema_name, referenced_entity_name
FROM sys.dm_sql_referenced_entities('dbo.V_COR_Objekte_Kategorien', 'OBJECT')
WHERE (1=1)
-- AND referenced_entity_name NOT IN('T_OV_Ref_ObjektTyp', 'T_SYS_ApertureColorToHex')
ORDER BY referenced_entity_name