Thursday, December 12, 2019

looking for a used car?

  • https://www.kbb.com/ can help with reasonable pricing if you punch in the year, make, model, and mileage. The corporate entity name, such as Toyota, is the make. The particular type car, such as Corolla, is the model.
  • https://www.carfax.com/value/ can help with the history of a car if you punch in the VIN (vehicle identification number) number.

the "teach a man to fish" quote that often comes up in software

Give a man a fish, and you feed him for a day. Teach a man to fish, and you feed him for a lifetime.

Pitney Bowes

...peddles the personal postage meter.

Wednesday, December 11, 2019

assorted strange SQL

  1. LEAD and LAG are esoteric and obscure. They are like ROW_NUMBER() only they get either the page before or the page after what ROW_NUMBER() would get.
  2. The whole SELECT INTO trick in T-SQL to SELECT into a temp table that is spun up right then may also be used to just make a new, regular table!
  3. When a table variable is passed to a stored procedure (in T-SQL) it is a TVP (table-valued parameter).
  4. CTEs in T-SQL use In-Memory memory management while table variables may use the Memory-Optimized Table approach to memory. I don't really understand this stuff. The MOT approach has a divide between Durable and Non-Durable and I don't understand that yet either.
  5. Not every reserved keyword in T-SQL must be wrapped in brackets to be used as a name. This only applies to the keywords which could otherwise be keywords (without error) in the SQL statement at hand.

Sage

This is another ERP yet. Sage is French and you pay upfront for everything you are going to get in terms of goodies instead of as you go.

Tuesday, December 10, 2019

when the file you added is not under "Excluded Changes" in TFS for some strange reason

  1. Go into the Source Control Explorer in Visual Studio 2017.
  2. Navigate to the folder holding the file you want to add.
  3. Right-click and pick: Add Items to Folder...