DataGeek.blog

June 6, 2023 Ember Crooks

The Job Hunt So Far, and Thanks for the Support!

There is a part of me that just wants to spill everything about my job search in blog entries and LinkedIn posts. Some of this would be valuable information for readers, and it would certainly be cathartic for me. However, I don’t think it would be in my best interest when negotiating with potential employers.… Read the rest
Continue reading »
May 30, 2023 Ember Crooks

Differences Between Db2 and MySQL

With a year of fairly extensive MySQL experience under my belt, and uncertainty as to which exciting direction my career will take me next, I wanted to take a moment to write about some of the differences between Db2 and MySQL at a fairly high level.… Read the rest
Continue reading »
May 23, 2023 Michael Krafick

Db2 One Way Hashing as a Data Masking Solution

Database performance is heavily influenced by data volume and cardinality (or how unique that data may be).

It’s interesting to watch the look on someone’s face when this concept clicks. There is a look of understanding from a developer when she can extrapolate why SQL ran in seconds on a small, local, dockerized, database but the same SQL runs in minutes in a much larger QA environment.… Read the rest
Continue reading »
May 10, 2023 Ember Crooks

Unexpected Career Turn

It’s amazing that I’ve had a 22-year career in tech, and until last week, I had never been laid off. Last week, I was a victim of the 20% layoffs at Shopify. Along with me came very talented people with years of experience there.… Read the rest
Continue reading »
May 2, 2023 Ember Crooks

MySQL: Quotation Marks

My article on DB2 Basics: Quotation Marks has 962 views so far this year, so I thought it might be time to write a similar article on using quotation marks with MySQL.

General quotation marks

For the most part, you can use single and double quotation marks interchangeably in MySQL as long as you maintain consistency.… Read the rest
Continue reading »
April 25, 2023 Ember Crooks

Scaling Relational Databases

“Relational databases don’t scale!”. This is the claim that database experts have heard over and over again, and yet we spend our careers scaling databases. I immediately translate this in my head to either “I threw hardware at the problem and it didn’t work!”… Read the rest
Continue reading »
April 18, 2023 Ember Crooks

A year of switching RDBMS platforms from Db2 to MySQL

About 18 months ago, I decided that it was time to look for my next job. I had only been at my employer at the time for about 2 years, and had helped them through a couple of tough things they had hired me for.… Read the rest
Continue reading »
April 11, 2023 Ember Crooks

Comparing Db2 and MySQL: Generating Values

I’m going to walk through the basic creation of auto-incrementing integer columns in MySQL and Db2 and point out some differences and similarities.

Functionality

Every relational database I have worked with has had a functionality for generating column values. The most basic generation is an incrementing integer.… Read the rest
Continue reading »

June 3, 2010 Uncategorized

5 things that made me a better DBA

Several times I've figured things out in my career and thought "how did I ever call myself a DBA without knowing that?" Continue reading »

June 2, 2010 Uncategorized

Hello world!

I am at this point an expert on DB2, and on the aspects of DB2 that interact with Commerce, and frequently train clients and new DBAs on how to do what I do, so it's time to share. Continue reading »

June 2, 2010 Uncategorized

Instance Creation in WebSphere Commerce 7 (DB2 9.5)

SQL30082N Security processing failed with reason "42" ("ROOT CAPABILITY REQUIRED"). SQLSTATE=08001 Continue reading »

General quotation marks

Functionality