Tom Oldy, September 20, 2024

Mastering SQL Performance Optimization: Essential Tips and Techniques In the world of databases, performance is everything. Whether you're a Database Administrator, IT Professional, SQL Developer, or Data Engineer, optimizing SQL queries can make a significant difference in the efficiency and speed of your database operations. This blog post provides actionable ...

Continue reading this post
blogpost
Tom Oldy, September 19, 2024

Beginners Guide to SQL Introduction Are you new to SQL and looking for a comprehensive guide to kickstart your learning? You're in the right place. SQL, or Structured Query Language, is the backbone of database management and one of the most valuable skills for data analysts, data engineers, and database ...

Continue reading this post
blogpost
Tom Oldy, September 19, 2024

Unlocking SQL Efficiency: Strategies for Faster Queries In the realm of data management, efficiency is paramount. For data analysts, SQL developers, database administrators, and data engineers, optimizing SQL queries can mean the difference between seamless operations and performance bottlenecks. If you're grappling with slow-running queries or inefficient query plans, this ...

Continue reading this post
blogpost
Tom Oldy, August 5, 2024

Manually running redundant SQL queries and generating reports can be a significant challenge, consuming valuable time and increasing the likelihood of human error. This process often leads to inefficiencies, delays in accessing critical data, and fragmented workflows. Without automation, teams may struggle with outdated or incomplete information, hindering their ability ...

Continue reading this post
blogpost
Tom Oldy, July 12, 2024

Integrating SQLBot into your Slack environment isn’t just a technical upgrade—it’s a game-changing move towards more effective, collaborative, and, yes, even fun SQL reporting. Make the switch today and let your data shine like never before!

Continue reading this post
blogpost
Doug Breaker, October 4, 2023

Postgres LIKE Operator - 1 Tip To Make Your Query 80 Times Faster I love SQL and I love Postgres. I've been playing around with the ~ 8 million unclaimed asset records in New York , and have been struggling with an efficient way to do a name search. My ...

Continue reading this post
blogpost
Doug Breaker, August 23, 2023

Read this 2 minute article to understand how to make your Rails app faster with the ActiveRecord update_all method. GIF of Tombstone included!

Continue reading this post
blogpost
Doug Breaker, October 6, 2022

Every wonder how to group by the week of the year in Postgres? MySQL comes with the handy WEEKOFYEAR() Function . How do you solve for the same thing in Postgres? Let's take an example, let's say we're measuring how many hearing tests get taken per week. Using MySQL, you'd ...

Continue reading this post
blogpost
Doug Breaker, October 6, 2022

Want to group MySQL by quarter? Read our 30-second guide.

Continue reading this post
blogpost
Doug Breaker, August 30, 2022

Soooooo . . . I can't stop building stuff. Love it. My latest little side project is a food/calorie/nutrition tracking app that does (nearly) everything via text message. I've gotten into TailwindCSS because I never took the time to properly learn CSS. Love it! Three cheers for laziness. Rails 7 ...

Continue reading this post