by Ember Crooks | Aug 31, 2023 | DB2, snowflake, sql
As I’ve been learning about Snowflake, at least once a week, I find small things in the SQL or feature set that just make me happy. I really feel like Snowflake is meant for someone who loves SQL, but also someone who does other programming.… Read the rest
by Craig S. Mullins | Aug 8, 2023 | IFCID, monitoring, performance, SLA, sql, trace
Monitoring and measuring performance metrics are essential practices for maintaining and optimizing the performance of an IBM Db2 environment. By regularly monitoring and analyzing performance data, DBAs can identify bottlenecks, proactively address performance...
by Craig S. Mullins | Jul 24, 2023 | optimization, performance, sql, workload
Managing workloads and optimizing queries are essential tasks for maximizing the performance of a Db2 databases and the applications that access them. By employing effective techniques, DBAs and performance analysts can streamline query execution, reduce resource...
by Craig S. Mullins | Jun 26, 2023 | BIND, data studio, explain, performance, sql, tips and tricks, visual explain
Query execution plans play a crucial role in identifying performance bottlenecks within an IBM Db2 database. When a query is executed, the database optimizer determines the most efficient way to retrieve the requested data by generating a query execution plan. It does...
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 | Jan 31, 2023 | Featured, mysql, sql
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
Recent Comments