Case style of tables and field (Naming Conventions)
It all boils down to personal preference and consistency within your team (or just yourself). Nothing worse than seeing different styles mixed. 

As for SQL Server, be mindful of sp_yourProcName, as "sp_" prefix for a stored procedure can do funny things (read more about this from Aaron Bertrand). 

Consistency is king. Make your choice and stick with it.