Lead Db2 Database Engineer and Service Delivery Manager , XTIVIA
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.

Posts:

Update on Ember’s Data Science Journey – August 1st, 2018

One of the struggles for any well-employed person is to find time for further training and educating themselves. Thus I find that I make a lot of progress toward my data science learning goals on airplanes and from airports. I don’t travel a lot for work – maybe once a month this year or a bit less. But when I travel, the time in airports and on airplanes is some of that precious “me” time. Work generally does not expect me to be accomplishing much, and is slow enough that I’m not desperately logging into every WiFi I can find to get off one more email. There is no house to be cleaned or dinner to be cooked, or children or husband to play with or help or talk to.

Continue reading »

What do I Think Data Science is?

This is one of those blog entries that I write and I know it will be obsolete and I will show my own ignorance and cringe at it in five years, but I have to write it anyway. I know that Iam biased. I come from a relational database background, and am working hard to open my mind the new data techniques that seem so popular these days.

Continue reading »

RDBMS Basics: Indexes and Clustered Indexes

What is an index in an RDBMS(Relational DataBase Management System), and what are the benefits and drawbacks of using an index? Why don’t we index everything? How is a clustered index different? Indexes are powerful tools in relational databases. They can speed up performance of queries exponentially, but they can also slow down inserts, updates, and deletes. Let’s take a look at indexing and why it is so important to RDBMS performance, good or bad.

Continue reading »

DB2 Administrative SQL Cookbook: Listing Database Authorities that an ID/Group Holds

Purpose

To list the database authorities held by an ID or group – authorities, not privileges. This information is not available in sysibmadm.privileges. The format of syscat.dbauth has columns with ‘Y’ or ‘N’ in them, and reading that quickly to answer the question “What permissions does this ID have?” can be a bit frustrating. This SQL could also be union-ed with SQL to query sysibmadm.privileges to include the privileges on database objects in one result set.

Continue reading »