DvdKhl’s gists

DvdKhl / HighMemUsageSqlBulkCopy.csproj

Created June 20, 2024 19:49

	<Project Sdk="Microsoft.NET.Sdk">

	<PropertyGroup>
	<OutputType>Exe</OutputType>
	<TargetFramework>net8.0</TargetFramework>
	<ImplicitUsings>enable</ImplicitUsings>
	<Nullable>enable</Nullable>
	</PropertyGroup>

	<ItemGroup>

DvdKhl / BytesToIPAddress.sql

Last active April 6, 2025 03:10

SQL Server function to convert varbinary(16) IPv4/IPv6 addresses to its string (shortened) form

	--Copyright (C) 2022 DvdKhl
	--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:
	--The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
	--THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
	--FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
	--WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE

DvdKhl / RecordDebugStackoverflow.cs

Created September 27, 2020 17:48

RecordDebugStackoverflow

	using System;
	using System.Collections.Immutable;

	//.NET 5 RC1 / Visual Studio 2019 Preview (Version 16.8.0 Preview 3.1)
	//1. Set breakpoint on Console.WriteLine
	//2. Start debugging
	//3. Hover ActiveModuleSet with mouse

	namespace RecordDebugStackoverflow {
	class Program {

DvdKhl / OverlapAsyncLock.cs

Last active March 24, 2018 08:51

Async/Await: Overlapping execution but only execute expensive task once per overlap

	public class OverlapAsyncLock {
	public class OverlapLock : IDisposable {
	private bool isFirst;
	private OverlapAsyncLock owner;

	internal OverlapLock(bool isFirst, OverlapAsyncLock owner) {
	this.isFirst = isFirst;
	this.owner = owner;
	}

DvdKhl / HD3Cube.c

Created October 3, 2017 10:59

	#include <stdlib.h>
	#include "stm32f1xx.h"

	void TIM2_IRQHandler() {
	if (TIM2->SR & TIM_SR_UIF) {
	TIM2->SR &= ~TIM_SR_UIF;
	GPIOC->BSRR = GPIOC->ODR & GPIO_ODR_ODR13 ? GPIO_BSRR_BR13 : GPIO_BSRR_BS13;
	}
	}

DvdKhl / ConsoleColors.cs

Created October 29, 2016 22:31

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Text;
	using System.Threading.Tasks;

	namespace ConsoleColors {
	class Program {
	static void Main(string[] args) {

DvdKhl / AVD3NativeLibApi.c

Created October 24, 2016 20:15

	#include "AVD3NativeLibApi.h"

	void* CRC32Create() {
	uint8_t b = (uint8_t)malloc(4);
	memset(b, 0xFF, 4);
	return b;
	}

	void CRC32Transform(void* handle, uint8_t *b, int32_t length) {
	uint64_t state64 = (uint32_t)handle;

DvdKhl / SHA1 SpeedTest.cs

Last active October 23, 2016 17:35

	using System;
	using System.Diagnostics;
	using System.Security.Cryptography;

	namespace SHA1Test {

	class Program {
	static void Main(string[] args) {
	var sha = SHA1.Create();
	var sw = new Stopwatch();

DvdKhl / Hasher.htm

Last active June 3, 2016 20:30

JavaScript File Hasher ( asm.js )

	<!DOCTYPE html>
	<html>
	<head>
	<title>JS Ed2k File Hasher</title>
	</head>

	<body>
	<input type="file" id="files" name="file" />
	<div id="readBytesButtons"><button>Hash File</button></div>
	<div>Read Speed: <span id="readspeed"/>mb/s</div>

DvdKhl / IBANChecksum.cs

Last active September 10, 2024 14:37

Fast C# IBAN Checksum Verifier / Validation

	//Copyright (C) 2013 DvdKhl
	//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:
	//The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
	//THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
	//FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY,
	//WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE