Samuel Dalesjö Dalesjo

Dalesjo / gist:6b5c2c169e628eb7b690a965a815b7b4

Created January 14, 2019 09:01

Nlog dateformat

	<!--
	Format date nlog
	https://github.com/NLog/NLog/issues/1199
	http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169814.htm
	https://github.com/nlog/NLog/wiki/Date-Layout-Renderer

	-->


	<variable name="fmt" value="${longdate} \| ${level} \| ${logger} \| ${day} \| ${month} \| ${message}"/>

Dalesjo / ColumnName.sql

Created November 8, 2018 14:03

Find all column with a specific name, and what table they recide in.

	SELECT
	c.name AS ColName,
	t.name AS TableName
	FROM sys.columns c
	JOIN sys.tables t ON c.object_id = t.object_id
	WHERE c.name LIKE '%Trailer%';

Dalesjo / childTables.sql

Created November 1, 2018 16:40

Find constraints connected to table.

	SELECT
	[parentTable].name AS parentTable,
	[childTable].name AS childTable,
	[constraint].name AS [constraint],
	[parentColumn].name AS parentColumn,
	[childColumn].name AS childColumn
	FROM sys.foreign_key_columns as fk
	INNER JOIN sys.objects AS [constraint] ON [constraint].[object_id]=[fk].constraint_object_id
	INNER JOIN sys.objects AS [parentTable] ON [parentTable].[object_id]=[fk].[referenced_object_id]
	INNER JOIN sys.columns as [parentColumn] ON [parentColumn].[column_id]=[fk].[referenced_column_id] AND [parentColumn].[object_id]=[fk].[referenced_object_id]

Dalesjo / smbmount

Last active February 20, 2023 04:05

Script to safetly mount a smb share.