About 20 minutes ago, I made a nice update of the status of every single record in a table because I didn’t highlight the criteria portion of a SQL statement. So, after I got over the sinking realization of what I had just done, and finished swearing, I realized I’d better pull down a backup and get to work. However, I only updated a single column in a single table, So I didn’t want to roll over the work of an entire business day, just recover the single column from a table that’s 99% read-only for most people. So, how do you do that?

When navigating with routerLinks within the same page in angular, angular’s normal onInit doesn’t activate. How do you do it? You simply subscribe to the router events while on that page. Then you can trigger things wherever you want. Just make sure you don’t forget to unsubscribe!

There is a lot of documentation about using REST with google drive APIs, but not much for using C# and service accounts to get that data. We’re going to try to keep some samples of queries and document some of the issues we ran into and how we overcame them.