Skip to content

Instantly share code, notes, and snippets.

View ridercz's full-sized avatar
🇨🇿

Michal Altair Valášek ridercz

🇨🇿
180 followers · 0 following
View GitHub Profile
@ridercz
ridercz / migrateall.cmd
Created March 26, 2026 01:17
Migrate all .sln files in given folder and it subfolders to .slnx
@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION
SET "ROOT=%CD%"
SET "DRYRUN=0"
:PARSE_ARGS
IF "%~1"=="" GOTO ARGS_DONE
IF /I "%~1"=="--DRY-RUN" SET "DRYRUN=1"
@ridercz
ridercz / 2021-2025.cmd
Created February 3, 2026 21:10
Stazeni zadani prijimacek z matematiky CERMAT 2021-2025
curl -L "https://prijimacky.cermat.cz/files/files/M9A_2025_TS.pdf" -o "2025_A.pdf"
curl -L "https://prijimacky.cermat.cz/files/files/M9A_2025_rozsireny_klic.pdf" -o "2025_A_klic.pdf"
curl -L "https://prijimacky.cermat.cz/files/files/M9B_2025_TS.pdf" -o "2025_B.pdf"
curl -L "https://prijimacky.cermat.cz/files/files/M9B_2025_rozsireny_klic.pdf" -o "2025_B_klic.pdf"
curl -L "https://prijimacky.cermat.cz/files/files/M9C_2025_TS.pdf" -o "2025_C.pdf"
curl -L "https://prijimacky.cermat.cz/files/files/M9C_2025_rozsireny_klic.pdf" -o "2025_C_klic.pdf"
curl -L "https://prijimacky.cermat.cz/files/files/M9D_2025_TS.pdf" -o "2025_D.pdf"
curl -L "https://prijimacky.cermat.cz/files/files/dokumenty/M9D_2025_rozsireny_klic.pdf" -o "2025_D_klic.pdf"
curl -L "https://prijimacky.cermat.cz/files/files/MA_2024_9_Ax.pdf" -o "2024_A.pdf"
curl -L "https://prijimacky.cermat.cz/files/files/M9PAD24C0K01_roz%C5%A1%C3%AD%C5%99en%C3%BD_kl%C3%AD%C4%8D.pdf" -o "2024_A_klic.pdf"
@ridercz
ridercz / ExifMetadataExtractor.ipynb
Created August 18, 2025 18:28
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ridercz
ridercz / ExifImageSharp.ipynb
Created August 18, 2025 18:26
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ridercz
ridercz / Encoding.ipynb
Created July 15, 2025 19:38
Base16, Base32 and Base64 in .NET
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ridercz
ridercz / Hash.ipynb
Last active April 8, 2025 14:02
Hashovací algoritmy nejenom v .NET
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ridercz
ridercz / SparseColumns.sql
Created March 4, 2025 23:01
Find candidates for sparse columns in MS SQL
SET NOCOUNT ON
CREATE TABLE #SparseTypes (
[DataType] nvarchar(20),
[Percentage] int
)
-- Values from https://learn.microsoft.com/en-us/sql/relational-databases/tables/use-sparse-columns
INSERT INTO #SparseTypes VALUES('bit', 98)
INSERT INTO #SparseTypes VALUES('tinyint', 86)
INSERT INTO #SparseTypes VALUES('smallint', 76)
@ridercz
ridercz / hierarchyid.sql
Created February 10, 2025 15:06
SQL Server HierarchyId demo
-------------------------------------------------------------------------------
-- Using linked IDs
-------------------------------------------------------------------------------
-- Create table
CREATE TABLE Categories (
[Id] int IDENTITY NOT NULL,
[ParentId] int NULL,
[Name] nvarchar(100) NOT NULL,
@ridercz
ridercz / ProcessIO.cs
Created January 20, 2025 22:29
Running external process with stdin/out/err redirection
// Video: https://youtu.be/cdTu27j6dn8
using System.Diagnostics;
using System.Text;
// Verify there are exactly 2 arguments and get source and destination folders
if (args.Length != 2) {
Console.WriteLine("Usage: mirror <source folder> <destination folder>");
return;
}
@ridercz
ridercz / SerialPlotter.ino
Created January 17, 2025 00:11
M5Stack CoreS3 + ENV unit demo for Arduino serial plotter
#include "M5CoreS3.h"
#include "M5UnitENV.h"
SHT3X sht3x;
QMP6988 qmp;
void setup()
{
auto cfg = M5.config();
CoreS3.begin(cfg);