Running tech has come a LOOOONG way from when I first started. I used to be a “log the runs on a sheet of paper (or spreadsheet) and time them with my basic “athletic watch” type of runner. Nowadays you can get a full gamut of details (and logging) all in a single app and track it with a wide assortment of devices. This also leads to decisions (and changes) to make. Continue reading
Today I finished another 7 mile run in my ongoing RAGNAR training for July. My body was still pretty tired from the run two days prior, so the last mile and a half, which includes a really steep hill followed by a trail climb through some switchbacks to the end was more of a survival run than a race to the finish. Continue reading
It’s a big day today. My girls are 10 years old. I blinked and the two little ones that I could cradle in my arms all day long now last about 30 seconds [note to self: will need to go to the gym if carrying them is to continue]. It’s a wonderful day, and it is an emotional day for me as well.
While I haven’t been the best at adhering to it, I’m still a big fan of Kanban and Pomodoro techniques for keeping myself organized and productive. I like it enough to have written about it and even made a tool to help. Another big aspect that helps me with my workflow is music. I tend to bounce around a bit between Electro House, Trance, Ambient, and even Gregorian Chant. However, I’ve found a new resource that is worth adding to the tool belt. Continue reading
Simply write about the first thing that comes to your mind …. NOW!
I have two new favorite commands in SQL Server, especially given the insane digging I’ve done in a huge database with oddly named columns and tables:
EXEC sp_fkeys '[Table_Name]'
This gem will give you all of the foreign keys for a given table, and what table they are referencing. Helpful when building things out or tracking them down.
SELECT * FROM information_schema.COLUMNS WHERE column_name like '%[Column_Name]%'
Wondering where in the world the table that said column in a side referenced documentation / form is actually located at, this will find it for you. It also includes views.
Any other handy SQL Server tricks to share? Continue reading