by Ember Crooks | Sep 26, 2023 | DB2, mysql, snowflake, sql, SQL Language
Every database platform has a way to select from nothing. Sometimes we use it to generate data manually, sometimes we use it to get values of various system functions, but it is important to be able to do. Dummy Table Generally a dummy table is a dummy table that has...
by Ember Crooks | Aug 17, 2023 | DB2, Featured, mysql
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 core work of this...
by Ember Crooks | May 30, 2023 | DB2, Db2vsMySQL, Featured, 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...
by Ember Crooks | May 2, 2023 | Featured, mysql, sql
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...
by Ember Crooks | Apr 25, 2023 | DB2, Featured, mysql, performance, scaling
“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...
by Ember Crooks | Apr 18, 2023 | DB2, Ember's Data Science Journey, Featured, 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
Recent Comments