Skip to content

Instantly share code, notes, and snippets.

View dariusz-wozniak's full-sized avatar
🏀

Dariusz Woźniak dariusz-wozniak

🏀
View GitHub Profile
@dariusz-wozniak
dariusz-wozniak / search_all.sql
Created July 14, 2022 14:43
SQL: Search all tables and all columns for a specific value
DECLARE @SearchStr nvarchar(100)
SET @SearchStr = '## YOUR STRING HERE ##'
-- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.
-- Purpose: To search all columns of all tables for a given search string
-- Written by: Narayana Vyas Kondreddi
-- Site: http://vyaskn.tripod.com
-- Updated and tested by Tim Gaunt
-- http://www.thesitedoctor.co.uk
@dariusz-wozniak
dariusz-wozniak / sc.DotSettings
Last active July 14, 2022 10:42
Optimizely (Episerver) Service Configuration template (`sc` keyword)
<wpf:ResourceDictionary xml:space="preserve" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:s="clr-namespace:System;assembly=mscorlib" xmlns:ss="urn:shemas-jetbrains-com:settings-storage-xaml" xmlns:wpf="http://schemas.microsoft.com/winfx/2006/xaml/presentation">
<s:Boolean x:Key="/Default/PatternsAndTemplates/LiveTemplates/Template/=1E1AF075028B114ABB26DB4B886536E6/@KeyIndexDefined">True</s:Boolean>
<s:String x:Key="/Default/PatternsAndTemplates/LiveTemplates/Template/=1E1AF075028B114ABB26DB4B886536E6/Shortcut/@EntryValue">sc</s:String>
<s:String x:Key="/Default/PatternsAndTemplates/LiveTemplates/Template/=1E1AF075028B114ABB26DB4B886536E6/Description/@EntryValue">ServiceConfiguration</s:String>
<s:String x:Key="/Default/PatternsAndTemplates/LiveTemplates/Template/=1E1AF075028B114ABB26DB4B886536E6/Text/@EntryValue"> [ServiceConfiguration(typeof(I$CLASS$))]&#xD;
[UsedImplicitly]</s:String>
<s:Boolean x:Key="/Default/PatternsAndTemplates/LiveTemplates/Template/=1E1AF075028B114ABB26DB4B
@dariusz-wozniak
dariusz-wozniak / IrfanView-Instagramify.ini
Last active May 20, 2022 13:48
Add borders to images
; UNICODE FILE - edit with care ;-)
[Batch]
AdvCrop=0
AdvCropX=0
AdvCropY=0
AdvCropW=0
AdvCropH=0
AdvCropC=0
AdvResize=1
@dariusz-wozniak
dariusz-wozniak / list-databases.sql
Created July 7, 2021 14:28
List user server databases in SQL Server
SELECT *
FROM master.sys.databases
WHERE Cast(CASE WHEN name IN ('master', 'model', 'msdb', 'tempdb') THEN 1 ELSE is_distributor END As bit) = 0
Name|TwoLetterISOLanguageName|ThreeLetterISOLanguageName|ThreeLetterWindowsLanguageName|DisplayName|EnglishName|NativeName
---------------
aa-DJ|aa|aar|ZZZ|aa (DJ)|Afar (Djibouti)|aa (DJ)
aa-ER|aa|aar|ZZZ|aa (ER)|Afar (Eritrea)|aa (ER)
aa-ET|aa|aar|ZZZ|aa (ET)|Afar (Ethiopia)|aa (ET)
af-NA|af|afr|ZZZ|Afrikaans (Namibië)|Afrikaans (Namibia)|Afrikaans (Namibië)
af-ZA|af|afr|AFK|Afrikaans (South Africa)|Afrikaans (South Africa)|Afrikaans (Suid-Afrika)
agq-CM|agq|agq|ZZZ|Aghem (Kàmàlûŋ)|Aghem (Cameroon)|Aghem (Kàmàlûŋ)
ak-GH|ak|aka|ZZZ|Akan (Gaana)|Akan (Ghana)|Akan (Gaana)
am-ET|am|amh|AMH|Amharic (Ethiopia)|Amharic (Ethiopia)|አማርኛ (ኢትዮጵያ)
@dariusz-wozniak
dariusz-wozniak / list-of-countries.txt
Last active August 1, 2024 13:18
List of countries TXT (plain text) - including countries with limited recognition
Abkhazia
Afghanistan
Åland Islands
Albania
Algeria
American Samoa
Andorra
Angola
Anguilla
Antarctica
@dariusz-wozniak
dariusz-wozniak / CultureInfos
Last active June 29, 2021 18:35
CultureInfos in Windows - C#
/*
void Main()
{
var cultures = CultureInfo.GetCultures(CultureTypes.AllCultures & ~CultureTypes.NeutralCultures);
"Name|TwoLetterISOLanguageName|ThreeLetterISOLanguageName|ThreeLetterWindowsLanguageName|DisplayName|EnglishName|NativeName".Dump();
"---------------".Dump();
foreach(var culture in cultures)
@dariusz-wozniak
dariusz-wozniak / emoji-test.txt
Created April 29, 2021 13:44
Emoji Keyboard/Display Test Data for UTS #51 Version: 13.1
# emoji-test.txt
# Date: 2020-09-12, 22:19:50 GMT
# © 2020 Unicode®, Inc.
# Unicode and the Unicode Logo are registered trademarks of Unicode, Inc. in the U.S. and other countries.
# For terms of use, see http://www.unicode.org/terms_of_use.html
#
# Emoji Keyboard/Display Test Data for UTS #51
# Version: 13.1
#
# For documentation and usage, see http://www.unicode.org/reports/tr51
@dariusz-wozniak
dariusz-wozniak / getPublicKeyToken.ps1
Created April 27, 2021 09:37
Get publicKeyToken for given assembly (assemblyIdentity)
([system.reflection.assembly]::loadfile("C:\fullpathto\name.dll")).FullName
@dariusz-wozniak
dariusz-wozniak / reinstall-nugets.ps1
Created April 27, 2021 08:22
Force to reinstall NuGet packages in project without update
Update-Package -reinstall -Project ProjectName