I do this on every WP site I set up, and while it’s no panacea for SQL issues moving forward as it’s more obscurity than security, it does make me feel all warm and fuzzy inside. 🙂
I have never had issues with it since I started the practice two years ago. A key to the process is pointed out in both articles you’ve linked to, changing the $table_prefix value in wp-config.php. If you do this, and if the plugins you are using are properly written, then they will honor that and you should not see any issues. I would feel confident about this change you’ve made.