Musical Kanned Tomatoes –

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


Freeform Friday 7

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