Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 17 years developing a top-level expertise on Db2 for mid-range servers and more than 7 years blogging about it, Ember is hungry for new challenges and looks to expand her skill set to the Data Engineering role for Data Science. With in-depth SQL and RDBMS knowledge, Ember shares both posts about her core skill set and her journey into Data Science.
Ember lives in Denver and work from home for XTIVIA, leading a team of Db2 DBAs.
I think I’m beginning to better understand why IBM is not fond of tools like db2top. The truth is that the developers really only get exposure to the largest Db2 clients. These are the ones that really pay the developer’s salaries, after all.… Read the rest
I still remember this meeting when I had been a DBA for less than a year at IBM. It was IBM, so I was the lone primary DBA for this internal client. With 3 whole months of experience and a shiny college degree.… Read the rest
The IDUG Conference in Charlotte this year was one of the best-run North American Conferences I have been to. They rose close to the high standard that the IDUG European conference committee sets. I had fewer issues with how things ran.… Read the rest
This is my regular pre-conference blog entry. I write these every year to share details about the conference and to share my excitement for this form of education and networking. The IDUG conferences in the US and Europe are my favorite weeks of the year.… Read the rest
I’m a command line gal, and probably always will be. I doubt a GUI will tempt me away from the command line, though I do find myself enjoying using things like Jupyter Notebook to also access the databases I support.
I have been working with Informix from a user perspective recently. I learned about some of the SQL differences and developed a greater empathy for developers in the process. CTE Support is covered, along with comparing the date and time handling syntax.
Continue reading »
Not only was this delete running unreasonably slow – it was also causing lock timeouts on the MEMBER table while running because of the slowness. This post contains application specific details that you don’t need to understand the underlying concept here, which applies across many SQL statements in the real world.
Continue reading »