I have experience with SQL Server 2000 writing queries, creating packages, and procedures. I've been doing the same things in the same way for awhile now, and I feel like there are probably a lot more sophisticated ways of doing things but I can't identify them or figure out how to learn them. When I look at online training it is either too basic or more related to being a SQL DBA, there seems to be a gap in the middle.
Any suggestions on next steps to continue to improve my skills? Thanks!