Skip to content

DataGeek.blog

Db2 Experts on a Data Science Quest

Search
  • Home
  • About
  • Bloggers
  • Privacy Policy
  • Ask Ember A Question
  • Donate
  • English
  • EspaƱol
  • January 31, 2023 Ember Crooks

    MySQL’s “partial” Group By

    This is one area that was not a surprise to me coming from Db2 to MySQL, as I’ve had to deal with people confused in the other direction for years. Essentially, MySQL allows a syntax for GROUP BY that Db2 and most RDBMSes do not allow.… Read the rest

    Continue reading »
  • January 26, 2023 Ember Crooks

    Using ChatGPT to Write SQL

    Working in technology, I’ve heard a number of things about ChatGPT from various news sources.

    I was particularly interested hearing some teachers saying it was the end of being able to properly detect students cheating when writing papers. Then I heard a teacher talking about how this was the new ‘calculator’ that teachers need to learn how to leverage in their curriculums.… Read the rest

    Continue reading »
  • January 18, 2023 Ember Crooks

    Introducing: Roll for Database!

    Alright, so I’m playing around with something. I’ve developed a bit of a TikTok addiction after exploring the platform to connect with my 14-year-old. One of the post types I’ve enjoyed is the “Roll for ______” type, where the content creator uses dice typical to Dungeons and Dragons to choose combinations of things that are sometimes magical, sometimes ridiculous, and occasionally disgusting.… Read the rest

    Continue reading »
  • December 6, 2022 Ember Crooks

    Comparing Db2 and MySQL: Naming Objects and Reserved Words

    Every RDBMS has areas where the differences from other RDBMSes are noticeable, and this is one of them between Db2 and MySQL. Most RDBMSes have quirks to the way SQL is written, and this is certainly true of Db2 where some things were there before the SQL-92 standard or other standards existed.… Read the rest

    Continue reading »
  • December 1, 2022 Ember Crooks

    Db2 Basics: Getting Data Out of Db2

    One of the things that learning a new platform (MySQL) has taught me is just how critical the most basic topics are, so I thought I’d do an overview of how to get data out of a Db2 (on Linux, Unix, or Windows) database.… Read the rest

    Continue reading »
  • November 8, 2022 Ember Crooks

    Comparing Db2 and MySQL: Explain

    The goal of this article is to to take one query and use the explain facilities of Db2 to walk through it, and then do the same with MySQL, and then show some of the optimizations I might make for the query and why.… Read the rest

    Continue reading »
  • November 3, 2022 Ember Crooks

    Comparing Db2 and MySQL: NULL in Indexes

    I’ve been spending some time working with indexes as I learn MySQL, and there were a few things I thought were were worth mentioning. As always, I’m writing from my own knowledge with deep experience in IBM DB2, and as a learner when it comes to MySQL.… Read the rest

    Continue reading »
  • October 27, 2022 Ember Crooks

    Comparing MySQL and Db2: Table and Index Structure

    I’ve spent some time understanding how MySQL structures tables and indexes, and wanted to share what I’ve learned. This is not the structure as created in the CREATE TABLE or CREATE INDEX statements, but how that data is generally structured on disk, both logically and physically.… 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 »
June 8, 2021 Uncategorized

Backing up a Db2 Database to AWS S3

AWS S3 is a cloud object storage service that is easy to use. It is highly available and offers ELEVEN nine’s of durability.

A Few Backup and Recovery Best Practices

I have quite a few blog entries over the years on backup and recovery.… Read the rest

Continue reading »
May 13, 2021 Uncategorized

The Big Mistake IBM is Making with Db2 in Containers

Note: the statements in this entry are my opinions. I quote IBM once in this article, and that statement should be seen as the only pure fact here. I invite IBM and others to add their perspective in the comments below.… Read the rest

Continue reading »
May 11, 2021 Uncategorized

Where do Db2 Containers Come From and How are they Used

In my last post, I wrote an overview of running Db2 in containers. Today, I’d like to talk a bit about where we get Db2 containers and several common ways they are used. Catch my next post about a critical mistake I think IBM is making with containerization.… Read the rest

Continue reading »
April 20, 2021 Uncategorized

An Overview of Running Db2 in Containers

One of my steepest learning curves in the last year and a half has been really getting into containers on K8’s and Docker and what running databases within them means. I thought I’d share a general overview, and plan to follow this post with more specific and more technical posts.… Read the rest

Continue reading »
March 11, 2021 Uncategorized

The Developer-DB Love-Hate Relationship

There’s a reason why database administration or engineering remains a separate specialty. There are a large number of rabbit holes you can go down. I’m well aware that there’s probably 40% of Db2 LUW alone that I don’t know, even though I’ve spent 20 years working with it, and am an internationally recognized expert.… Read the rest

Continue reading »
February 9, 2021 Uncategorized

It Matters Where Your Join Clauses Go

Explicit Join vs. Implicit Join

When writing SQL there are two places you can define how tables are joined. The first is explicit, and is specified after the the keyword ON in the join clause like this:


SELECT * 
FROM table_a as a
    JOIN table_b as b ON a.id=b.id
… Read the rest Continue reading »
November 19, 2020 Uncategorized

Overview of Real-Time Monitoring Options For Db2

I thought I’d share an overview of the real-time monitoring options for Db2 (LUW). This article focuses on comparing the options, with links to deeper information on each tool.

Types of Monitoring

First a quick overview of the types of monitoring that every DBA should be doing.… Read the rest

Continue reading »
November 10, 2020 Uncategorized

My Journey through Beginner Data Science Content

When I first started learning about data science, the amount of material out there was daunting. It is hard to find your way in what you should learn and how you should learn. I thought I’d share what has been working for me and what didn’t.… Read the rest

Continue reading »

Posts navigation

«Previous Posts 1 2 3 4 5 … 49 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...