Thanks for reading my posts. I hope they will help you on your SQL Career Journey. I'm going to summarize some of my key points in this post.
1. Document and UNDERSTAND everything about the SQL Servers you are responsible for. When I say "SQL Servers" I also mean MySQL, PostgreSQL, and any other RDMS. In my last position we had a mix of Windows SQL Servers, MySQL Servers, and PostgreSQL as well. This isn't actually uncommon as some business are looking to move from one platform to the other.
2. Get a list of tasks and their priorities from your manager. Make sure that your time is being accounted for working towards the goals he or she sets. Your manager has a lot on his mind so make sure you take some time to reiterate what your working on. Your manager's priorities may have changed according to business needs, and you need to stay "in the loop."
3. Make a journal/notebook of your tasks, your progress on them, their due dates, and what you've learned. (This also serves to help you in future interviews by refreshing what you've learned, and being able to clearly tell the interviewer what experiences you have had).
4. Recap what you've been asked to do. I usually do this verbally AND via email. I found that some managers may forget what they told you. When done via email it's almost like a contract that both parties agree to.
5. Make a testing type environment. Practice querying in that environment. Familiarize yourself with the database by performing these queries.
6. Look through database documentation such as the ERD and the Data Dictionary. If these aren't available then you have to create them.
7. Use SQL Server Profiler or the MySQL equivalent. This is helpful when you have no idea how to structure your query, or just want to see how the application developers wrote the query.
No comments:
Post a Comment