Follow @endyourif rss Facebook LinkedIn

Finding Deleted File with GitHub

Published on Jan 27, 2020

This is such a handy little thing that I've used a fair amount. It's quite frequent that I refactor code, sometimes even breaking the code into new projects.

The challenge with this is the history of the file disappears with it making it difficult to remember the previous state of that file. Enter git log

Delete duplicate rows with MySQL or MSSQL

Published on Feb 27, 2019

The following article will provide a single SQL query that will delete rows that are duplicated in your table. Before you begin, be sure you've tracked down the bad code that is causing this; otherwise, you will need to run it multiple times!

To start, I will create a basic table structure that will help understand the SQL query: