I was trying to keep it simple for the sake of answering the question, but I'm literally a carpenter and drilling solid wood joists is totally fine (at least in Canada) as long as you roughly follow what I said. Maybe I could've said "design strength" instead of full strength but again, trying to keep it short and simple.
I've worked mostly commercial though so you've inspired me to look back in my books to make sure I wasn't way off base in my recollection.
