It has been a while since I was last in Birmingham (Alabama) for a SQL Saturday. They didn’t have one last year, and the event they did have was on the same weekend as Music City Code, so I wasn’t able to attend. This year, I can’t make it to SQL Saturday in Richmond due to this event, so I am fairly sure things have balanced themselves out.
I will be doing two sessions (my two current sessions that I have been doing recently, the first one being my favorite session ever to give. Lots of demos that work, and material I actually know from heart. The second has no prep whatsoever, so I don’t hate it either.
Let Me Finish… Isolating Write Operations
OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.
Then I am doing a second professional development session with Robert Verell, and any other career nerd types that are there for the conference:
Discuss Your Career (Panel)
As a database professional, you have plenty of choice in your career path. Should you stay at the same company for 20 years, or change every few years? Much depends on what matters most to you. Do you want higher income, regular work hours, training, vacation time, group insurance, job security, lots of travel, telecommuting, or the possibility to advance to management? The panel will give their observations and experience over decades of experience. Discussion will include at least one person who has spent over 19 years with the same employer, one person who has changed careers very recently, and everyone in attendance who is willing to give an opinion.
The goal of this session will be to have a discussion about career matters. If attendees have questions about how to manage their career, we will discuss. Or there will be slides with different priorities to discuss if no one has questions. I would note that this session is not specifically about whether or not to change companies, positions etc. The goal is discuss the pros and cons of staying in one place, changing frequently, etc. There are so many factors to consider that it is maddening. If you don’t learn anything, maybe you will teach someone else something about their career. And if you neither learn, nor teach, the prize giveaways start right after this session, so it is a now lose situation.