kedzior-io

-- From : Michael J Swart (https://sqlperformance.com/2017/07/sql-performance/find-database-connection-leaks)

declare @database_name sysname = N'YOUR_DATABASE_NAME_HERE';
declare @program_name sysname = N'.Net SqlClient Data Provider';

select 
	datediff(SECOND, s.last_request_end_time, getdate()) as seconds_asleep,
	s.last_request_start_time as lastreq,
        s.session_id,
        db_name(s.database_id) as database_name,

kedzior-io

AzureStorageEmulator.exe clear all
AzureStorageEmulator.exe init
AzureStorageEmulator.exe start

kedzior-io

// Razor 
// -------------------------------------------------------------------
<timeago>@comment.UtcCreatedDateTime</timeago>

// Helper 
// -------------------------------------------------------------------
using Microsoft.AspNetCore.Razor.TagHelpers;
using System;
using System.Threading.Tasks;