In my day job, I spend a lot of time looking at other peoples’ SQL and helping them make it run faster through a vast array of different techniques. I have been toying lately with seeing if I could take…
As someone who regularly makes up scenarios to demonstrate concepts – both professionally and in my free time, I was very used to Db2’s answer to data generation – which is basically either fun with recursive SQL, pay for the…
This blog entry compliments a webinar on February 8th where I will be a panelist answering questions on Amazons RDS for Db2. Register for “Introducing Amazon RDS for Db2”now. I was lucky enough to be invited to speak at IDUG…
I have answered this question so many times and in so many different ways. Conceptually, my article Db2 Basics: The Role of Databases covers the concept of a database or database management system, why we need them and how we…
IBM, the Death Star, and rise of the Resistance. In the spring of 2018, Ember and I attended a dinner with members of the Db2 Technical Advisory Board (TAB). This was a collection of respected Db2 end-users, clients, and consultants…
There are many ways to scale databases. One I was less familiar with before my last job is application-level sharding. While there are tools that work on some platforms to help you achieve application-level sharding (like Vitess with MySQL), the…
Disclaimer: this article is only my opinions. I do not represent Snowflake. I realized after writing last week’s article that some people might be like me a few months ago, and not really understand what Snowflake is and how it…
Disclaimer: I’ve recently become a Snowflake employee, but this post is speaking of my own personal opinions, and in no way represents Snowflake. I certainly do not speak for the company. I am just a few weeks into learning about…
I am so excited about the new job that I’m starting on July 5th! I’m joining the Field CTO office at Snowflake as a Principal Architect, Data Performance. In this role, I’ll be tackling the thorniest performance issues that clients…
Table spaces are one of the more powerful tools in Db2 that are largely invisible. We used to have to spend a lot more time on table space management. Basics and Terminology Some of the terms here are rarely needed…
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,…
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…
