If you throw 100 darts and only 1 hits the bullseye, it doesn’t mean you’re good at darts.
Re: people spouting conspiracies constantly.
Programming 102, Subsection 3, Paragraph 7
Get it working.
Franks2000InchTV
Then get it working correctly.
Then get it working fast.
Then get it working fast correctly.
Mike Lindell: Secretly an idiot.
He has the haunted look of an idiot who secretly knows he’s an idiot pretending not to be an idiot.
Protiguous, 2021. Talking about Mike Lindell’s claims that the 2020 election was stolen from Donald Trump.
List Databases with a different collation than the SQL Server
select
[d].[name] [Database Name]
,databasepropertyex( [d].[name], 'COLLATION' ) [Database Collation]
,serverproperty( 'COLLATION' ) [Server Collation]
from [sys].[databases] [d]
where ( databasepropertyex( [d].[name], 'COLLATION' )) != serverproperty( 'COLLATION' );
List collation on all columns in all tables in database on SQL Server
select
concat( quotename( [s].[name] ), N'.', quotename( [t].[name] ), N'.', quotename( [c].[name] ) ) [Column Name]
,[c].[collation_name] [Collation]
from [sys].[schemas] [s]
join [sys].[tables] [t] on [t].[schema_id] = [s].[schema_id]
join [sys].[columns] [c] on [c].[object_id] = [t].[object_id]
where [c].[collation_name] is not null
order by [Column Name];
Example:
Borders
Borders don’t make you any safer.
Protiguous, 2021
Borders only keep out potential friends.
Concat two enumerables
public static IEnumerable<T> Concat<T>( this IEnumerable<T> left, IEnumerable<T> right ) {
foreach ( var a in left ) {
yield return a;
}
foreach ( var b in right ) {
yield return b;
}
}
Concat two arrays in C#
public static T[] Concat<T>( this T[] array1, T[] array2 ) {
var result = new T[ array1.LongLength + array2.LongLength ];
array1.CopyTo( result, 0 );
array2.CopyTo( result, array1.LongLength );
return result;
}
Create only 1 instance of an object per thread.
/// <summary>
/// Create only 1 instance of <see cref="T" /> per thread. (Only unique when using this method!)
/// </summary>
/// <typeparam name="T"></typeparam>
public static class Cache<T> where T : notnull, new() {
private static ThreadLocal<T> LocalCache { get; } = new(() => new T(), false);
public static T? Instance { get; } = LocalCache.Value;
}
Some useful C# Swap methods
public static class SwapExt
{
[MethodImpl(MethodImplOptions.AggressiveInlining)]
public static void Swap<T>(ref T? left, ref T? right) => (left, right) = (right, left);
[Pure]
[MethodImpl(MethodImplOptions.AggressiveInlining)]
public static (T? right, T? left) Swap<T>(this T? left, T? right) => (right, left);
[Pure]
[MethodImpl(MethodImplOptions.AggressiveInlining)]
public static (T? right, T? left) Swap<T>((T? left, T? right) tuple) => (tuple.right, tuple.left);
}
Pay close attention to which method you think is being used. (The refs versus the tuples.)
Protiguous 