dennisdoomen

internal class DockerMsSqlServerDatabase : IAsyncDisposable
{
    private const string Password = "!Passw0rd";
    private const string Image = "mcr.microsoft.com/mssql/server";
    private const string Tag = "2019-GA-ubuntu-16.04";

    private static IContainer _sqlServerContainer;
    private SemaphoreSlim semaphore = new(1, 1);
    private readonly string DatabaseName;

dennisdoomen

using System;
using System.IO;
using System.Linq;
using System.Text;
using Microsoft.VisualBasic;
using Nuke.Common;
using Nuke.Common.CI;
using Nuke.Common.Execution;
using Nuke.Common.IO;

dennisdoomen

SELECT TOP 25
dm_mid.database_id AS DatabaseID,
dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,
dm_migs.last_user_seek AS Last_User_Seek,
OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) AS [TableName],
'CREATE INDEX [IX_' + OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) + '_'
+ REPLACE(REPLACE(REPLACE(ISNULL(dm_mid.equality_columns,''),', ','_'),'[',''),']','') +
CASE
WHEN dm_mid.equality_columns IS NOT NULL AND dm_mid.inequality_columns IS NOT NULL THEN '_'
ELSE ''

dennisdoomen

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

namespace ConsoleApplication1
{
    class Program
    {

dennisdoomen

[alias]
	co = checkout
	ec = config --global -e
	up = !git pull --rebase upstream $(git symbolic-ref --short HEAD) --prune $@ && git submodule update --init --recursive
	cob = checkout -b
	cm = !git add -A && git commit -m
	save = !git add -A && git commit -m 'SAVEPOINT' --no-verify
	wip = !git add -u && git commit -mWIP --no-verify
	undo = reset HEAD~1 --mixed
	amend = commit -a --amend -n

dennisdoomen

• Chocolatey
• Git
• Posh-Git
• GitKraken
• ZLocation
• Notepad++
• Visual Studio 2017
• Jetbrains Rider & ReSharper
• SemanticMerge
• Git-Extras

dennisdoomen

// Option 1
var subject = new EventRaisingClass();
using (var scope = subject.Monitor())
{
    subject.ShouldRaise("NonExistingEvent");
}
  
// Option 2
var subject = new EventRaisingClass();
using (Monitor<EventRaisingClass> monitoredSubject = subject.Monitor()

dennisdoomen

[color "status"]
    changed = red bold
    untracked = red bold
    added = green bold

dennisdoomen

Verifying that +ddoomen is my blockchain ID. https://onename.com/ddoomen

dennisdoomen

            // Rx-workaround (it has hardcoded assembly reference which prevents ILMerging the assembly)
            PlatformEnlightenmentProvider.Current = new CurrentPlatformEnlightenmentProvider();