Skip to content

DataGeek.blog

A hub for sharing relational database knowledge and experimentation

Search
  • Home
  • About
  • Bloggers
  • Privacy Policy
  • Ask Ember A Question
  • Donate
  • English
  • Español
  •
    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 »
  • February 28, 2023 Ember Crooks

    Choosing the BEST RDBMS

    When I started working as a DBA in 2001, the relational database management system choices were more limited and the choice itself was often left up to a system architect. Rarely did developers have a say, and even DBAs only had a say in whether they could support it or would have to hire people to support it.… Read the rest

    Continue reading »
March 11, 2022 Uncategorized

A New Turn in Ember’s Career

I’ve struggled to write this blog entry to appropriately convey all aspects of what I want to say. This is my third attempt, and I finally think it does things justice.

As part of my publicly shared data science journey, I’ve continued to read job postings, even while reasonably satisfied with my current job.… Read the rest

Continue reading »
March 9, 2022 Uncategorized

Db2u on Native Kubernetes!!

Db2u is here as a technical preview! I’ll cover the basics of how to set it up for a local sandbox, and leave the details and whys to future articles. IBM has stated that db2u will be available in GA later this year on Amazon EKS and Azure EKS, but meanwhile, I’ve got the technical preview up and running on my MacBook Pro!… Read the rest

Continue reading »
February 1, 2022 Advent of Code / AOC2021

Advent of Code 2021 in Db2 LUW SQL – Day 04!

Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 4. It’s posting on February 1.… Read the rest

Continue reading »
December 21, 2021 Advent of Code / AOC2021

Advent of Code 2021 in Db2 LUW SQL – Day 03!

Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 3. It’s posting on December 21.… Read the rest

Continue reading »
December 17, 2021 Uncategorized

db2u Without RedHat OpenShift – A Container-Native Database!

Earlier in 2021, I wrote an article on the big mistake I thought IBM was making by only offering their container-native version of Db2 (db2u) on RedHat OpenShift.

Well, that article and tirelessly asking questions of EVERY IBMer I could get to listen to me (seriously, I could hear eyes rolling when I asked for the umpteenth time) has finally worked!… Read the rest

Continue reading »
December 3, 2021 Advent of Code / AOC2021

Advent of Code 2021 in Db2 LUW SQL – Day 02!

Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 2.

AOC Day 2
My day 2 solutions are available in my GitHub repo.… Read the rest

Continue reading »
December 2, 2021 Advent of Code / AOC2021

Advent of Code 2021 in Db2 LUW SQL – Day 01!

Check out my general blog entry on Advent of Code 2021 for background and resources. In short, I’m working through the Advent of Code 2021 programming challenge using Db2 LUW SQL. This is the detailed entry for day 1.

AOC Day 1
My day 1 solutions are available in my GitHub repo.… Read the rest

Continue reading »
December 2, 2021 Advent of Code / AOC2021

Advent of Code 2021 in Db2 LUW SQL

This year, I’m going to be working through the Advent of Code challenges in SQL and sharing my progress here on the blog. I don’t expect to complete each challenge and the blog entries on them on the same day they are released – I’m not competing on time, I’m just using this to share SQL techniques.… Read the rest

Continue reading »
September 7, 2021 Uncategorized

Db2 Basics: Buffer Pools

What is a Buffer Pool?

A buffer pool is one of the most critical memory areas for a Db2 database. Buffer pools are used to cache data in a way that the data can be reused by other connections. They do not store the results of Query A and Query B, but they store the data pages used to produce those results.… Read the rest

Continue reading »
August 27, 2021 IDUG

In Memory of Scott Hayes

I was very sad to learn that Scott Hayes passed away from COVID-19 on August 18.

The comments on his obituary are a list of friends and mentees from the Db2 community. I wanted to pay tribute to him by sharing my good memories of him and sharing the impact he had directly on my career.… Read the rest

Continue reading »
July 22, 2021 Uncategorized

How to use Docker on your Local Machine – For DBAs

Recent posts related to using Docker with Db2:
An Overview of Running Db2 in Containers
Where do Db2 Containers Come From and How are they Used

The focus of this article is to go through a few of the basics of using Docker with Db2.… Read the rest

Continue reading »
July 15, 2021 Uncategorized

The Basics Of Containers for DBAs

I’ve spent much of the last year or two on a containerization and DevOps crash-course. I’m just recently starting to come up for air and fill in some of the gaps that being neck-deep in the how leave in in the what and why.… Read the rest

Continue reading »

Posts navigation

«Previous Posts 1 2 3 4 5 … 50 Next Posts»

Search

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Privacy Policy
 

Loading Comments...