Tuesday, April 27, 2021

Git Github Messed Up

Did you screw up your local repo? Don't want to mess up the real, online repo? Or maybe you got a weird error when trying to sync/ push your commit? For instance, mistakenly added a large (over 100 KB?) binary that GitHub won't accept? Then you need RESET. I don't know why RESET is not explained in basic tutorials. In Visual Studio, you have to go to View History.... then right click and select RESET at the last good branch. (choose "hard" to delete all changes, otherwise it probably will get a lot more complicated). Warning: This might not be as simple as it seems. But so far, this seems to have done what I needed.

Friday, April 9, 2021

T-SQL: How to see recently executed queries

SELECT deqs.last_execution_time AS [Time], dest.text AS [Query] FROM sys.dm_exec_query_stats AS deqs CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest ORDER BY deqs.last_execution_time DESC