Primarily I work with Oracle which is more a circumstance of my jobs and the companies. I’m always opened to all databases and systems. While it’s much easier to stay current with Oracle since I have the the real life experiences daily the others provide a challenge. One way I stay current on SQL Server is joining the PASS community, following some awesome SQL Server types on twitter and reading their blogs. I also take advantage of their FREE SQLSaturdays in the local areas. This past Saturday I spent the day immersed in SQL Sever in Orlando.
I really enjoy the SQL Saturdays they off so much information in one day. I know that the local IOUGs usually host 1 day during the week that is very similar to the SQL Saturdays, but they tend to follow during the week and are more limited in their content. Yes it does mean using my own personal time but if I want to stay current on any vendor product that is a sacrifice. Plus its a few Saturdays out of the year depending on how many close by SQLSaturdays I desire to attend.
The content from this Saturdays event was varied and very well put together. I enjoyed all the sessions. I’m always performing comparisons in my mind as the content is presented between SQL Server and Oracle. The session on Database Design Diasters was quite interesting. The main take away: Developers no matter of the platform make the same mistakes at least when using SQL Server and Oracle.
I found striking comparisons in two other sessions with regards to SQL Server vs Oracle. Extend Events and assessing performance metrics. SQL Server has come a very long way in this area but hands done Oracle does a much better job collecting and displaying the metrics. AWR, ASH, as well as the ability to dig into the tables underneath. The wealth of data Oracle provides and ease of use wins every time.
Transaction logs session provided a unique comparison. Logs provide the same functionality as the Redo Logs and the Undo Tablespace. The manner in which the same concepts were strikingly uniquely implemented is worth it’s own blog post. My immediately reaction is that Oracle does a better job in their implementation mainly because it’s automatically performing the backup — by archiving the log data to the archive logs. But I’m hesitant because that might just a knee reaction and I want to explore the transaction logs for a deeper understanding — hence it’s own blog post.
I do recommend that any DBA take advantage of the community resources available to include any conferences, learning or networking opportunities. As well as don’t limit yourself to only learning one vendor product within the database world. Explore. Be adventurous. This is how careers are taken to the next level.
Thank you to the SQLSaturday Orlando organizers and speakers. It was a great experience.