Greg Trevellick GregTrevellick

💭

Nerding

.Netter. Vsixer(ish). Building on the shoulders of giants.

GregTrevellick / Run as

Last active July 1, 2020 13:49

	C:\Windows\System32\runas.exe /user:DOMAIN\First.Last /savecred "cmd /c \"start foobar.exe\""

	C:\Windows\System32\runas.exe /user:DOMAIN\First.Last /savecred "C:\Program Files (x86)\foobar.exe"

	C:\Windows\System32\runas.exe /user:DOMAIN\First.Last /savecred "C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\devenv.exe"

GregTrevellick / markdown-details-collapsible.md

Last active May 23, 2019 09:47 — forked from pierrejoubert73/markdown-details-collapsible.md

How to add a collapsible section in markdown.

Your markdown heading here

Show details closed by default

Your markdown content here

GregTrevellick / &=

Created October 26, 2018 14:48

	using System;
	using System.Collections.Generic;

	public class Program
	{
	public static void Main()
	{
	Console.WriteLine("Hello World");

	var mixed = new List<bool> {true, false, true, false};

GregTrevellick / InternalsVisibleTo.cs

Last active January 12, 2020 07:00

InternalsVisibleTo

	using System.Runtime.CompilerServices;
	[assembly: InternalsVisibleTo("UnitTests")]

GregTrevellick / Table names & row counts

Last active August 25, 2021 08:32

TSQL get table names and table row counts

	SELECT SCHEMA_NAME(A.schema_id) + '.' + A.Name, AVG(B.rows) AS 'RowCount'
	FROM sys.objects A
	INNER JOIN sys.partitions B ON A.object_id = B.object_id
	WHERE A.type = 'U'
	GROUP BY A.schema_id, A.Name
	--ORDER BY AVG(B.rows) DESC

GregTrevellick / Email address regex

Created July 22, 2020 14:36

Email address regex

(([!#-'*+/-9=?A-Z^-~-]+(\.[!#-'*+/-9=?A-Z^-~-]+)*)@([!#-'*+/-9=?A-Z^-~-]+(\.[!#-'*+/-9=?A-Z^-~-]+)*|\[[\t -Z^-~]*]))