Blog

Best practices

7 SQL Best Practices Every Developer Should Know

Learn seven practical SQL best practices for writing faster, safer, and more readable queries. Tips from the team behind Beekeeper Studio, the open-source SQL editor for Postgres, MySQL, SQLite, and more.

Matthew Revell / October 28, 2025

Plugins

Data Analytics in Seconds With Haiku 4.5 in Beekeeper Studio

Industry leading fast AI data analytics using Beekeeper Studio and Claude Haiku 4.5 can answer data analytics questions before you know it.

Matthew Rathbone / October 16, 2025

Reviews

Top 5 Free CockroachDB GUI Clients for Developers in 2025

Discover the best CockroachDB GUI clients for macOS, Windows, and Linux. We compare open source options and modern tools with advanced features like AI integration.

Matthew Revell / September 28, 2025

Release

Redis, Trino, and SurrealDB support now GA in Beekeeper Studio 5.4

Beekeeper Studio now supports Redis, Trino, and SurrealDB — three more databases, one modern GUI.

Matthew Revell / September 24, 2025

Tutorial

How to Check Database Size in PostgreSQL: Your Quick Guide

Learn how to determine PostgreSQL database size for capacity planning, monitoring growth, and performance optimization with simple SQL queries.

Matthew Rathbone / September 23, 2025

Release

5.4 beta featuring Redis, Trino, and SurrealDB and more

Release 5.4 beta brings initial support for Redis, Trino, and SurrealDB, plus a 55× UI performance tune-up.

Matthew Revell / September 9, 2025

Opinion

Benchmarking LLM Codegen for SQL

A guide to AI SQL codegen benchmarks: what Spider, BIRD-SQL, and newer efforts reveal about LLMs and their ability to write SQL.

Matthew Revell / September 2, 2025

Reviews

Top ClickHouse GUI Clients for Developers in 2025

Looking for the best ClickHouse GUI client? We compare four top tools to help you query and browse ClickHouse with ease.

Matthew Revell / August 27, 2025

Tutorial

SQL ALTER TABLE Add Column: A Complete Guide

Learn how to use SQL ALTER TABLE to add columns to existing tables. Follow examples for adding data types and default values.

Matthew Rathbone / August 25, 2025

Tutorial

Master JSONB Functions in PostgreSQL: A Practical Guide

Learn PostgreSQL JSONB functions with examples for effective JSON data management. Explore key operators, indexing, and more.

Matthew Rathbone / August 24, 2025

Release

GPT-5 just landed. Here's what it means for SQL.

GPT-5 brings a bigger context window, improved accuracy, and better SQL handling. Here’s what it could mean for your workflows.

Matthew Revell / August 20, 2025

Release

GPT-5, Claude, Gemini, and local LLMs now in AI Shell

AI Shell now supports GPT-5, Claude Opus 4.1, Gemini 2.5 Pro, and local Ollama models.

Matthew Revell / August 19, 2025

Reviews

One-to-One Database Relationships: Complete Implementation Guide

Master one-to-one database relationships with detailed examples, SQL code, performance considerations, and common pitfalls. Learn when to use 1:1 relationships and implementation best practices.

Matthew Rathbone / July 24, 2025

Tutorial

One-to-Many Database Relationships: Complete Implementation Guide

Master one-to-many database relationships with real-world examples, advanced SQL patterns, performance optimization, and best practices. The most comprehensive guide to 1:many relationships.

Matthew Rathbone / July 24, 2025

Tutorial

MySQL COALESCE: Handling NULL Values Effectively

Learn how MySQL COALESCE handles NULLs by returning the first non-NULL value, ensuring meaningful query results.

Matthew Rathbone / July 24, 2025

Tutorial

Many-to-Many Database Relationships: Complete Implementation Guide

Master many-to-many database relationships with junction tables, advanced patterns, and real-world examples. Learn when to use M:N relationships and optimize performance with proper indexing strategies.

Matthew Rathbone / July 24, 2025

Release

Meet your AI SQL pair programmer

Chat with your database using your favorite LLM. Beekeeper Studio’s secure AI Shell writes SQL tailored to your data.

Matthew Revell / July 22, 2025

Tutorial

How to Count Distinct Values in SQL: Complete Guide with Examples

Learn how to count distinct values in SQL with COUNT DISTINCT function. Master SQL techniques for unique data analysis with multiple columns and aggregate functions.

Matthew Rathbone / July 21, 2025

Tutorial

Understanding Database Relationships: A Comprehensive Beginner's Guide

Master database relationships with visual diagrams, real examples, and SQL code. Learn one-to-one, one-to-many, and many-to-many relationships to build better databases and write more effective queries.

Matthew Rathbone / July 20, 2025

Release

Beekeeper Studio 5.3 - SQL AI Shell

Quickly write SQL with AI, no hand-holding required. Connects to Claude, ChatGPT, and Gemini.

Matthew Rathbone / July 14, 2025

Tutorial

SQL Temp Table: How to Create a Temporary Table in SQL with Examples

Temp tables provide a practical solution for storing intermediate results, and they play a crucial role in optimizing query performance.

Matthew Rathbone / July 12, 2025

Tutorial

SQL JOIN for Beginners with Diagrams & Example Code

Easy to understand diagrams and code examples

Matthew Rathbone / July 2, 2025

Tutorial

How to Insert Date in SQL: Essential Tips for Database Management

Working with dates is a common requirement in database management, specifically when using SQL. One might often have to insert date values into their

Matthew Rathbone / July 2, 2025

Tutorial

Postgres Generate UUID: A Guide to Unique Identifiers

Learn how to generate UUIDs in PostgreSQL using uuid-ossp, ensuring unique IDs across systems with code examples and step-by-step guidance.

Matthew Rathbone / June 27, 2025

Reviews

5 Best Studio 3T Alternatives for MongoDB in 2025

Frustrated with Studio 3T? These five MongoDB GUI tools offer alternatives, from lighter interfaces to more flexible, cross-database workflows.

Matthew Revell / June 20, 2025

Rankings

Top 5 MongoDB GUI Clients for Developers in 2025

Looking for the best MongoDB GUI? Here we compare five options for querying and exploring your data.

Matthew Revell / May 27, 2025

Tutorial

SQL Server Joins Guide: Inner, Left, Right & Full Joins

Master SQL Server joins with this comprehensive guide. Learn INNER, LEFT, RIGHT, and FULL OUTER joins with practical examples and clear explanations for combining table data effectively.

Matthew Rathbone / May 19, 2025

Tutorial

MySQL Joins Guide: Mastering Joins with Examples

Learn MySQL joins including INNER, LEFT, RIGHT, FULL, CROSS, and SELF JOINs with examples to enhance your database query skills.

Matthew Rathbone / May 13, 2025

Tutorial

Master PostgreSQL Cross Join: Examples & Use Cases

Learn how PostgreSQL CROSS JOIN works with examples and when to use it for generating combinations and data analysis.

Matthew Rathbone / May 7, 2025

Tutorial

Rails Execute SQL: Master Raw Queries for Optimized Performance

Learn how to execute raw SQL in Rails for complex queries, performance boosting, and database features while avoiding SQL injection.

Matthew Rathbone / April 25, 2025

Release

Beekeeper Studio 5.2 - MongoDB, SQL Anywhere, and an enhanced JSON sidebar

Edit rows in JSON view, query Mongo using SQL or the MongoDB Shell, and hide secrets in privacy mode.

Matthew Rathbone / April 24, 2025

Tutorial

Rails Generate Migration: Powerful Command Line Options

Explore the powerful command line options of 'rails generate migration' for efficient database management in Ruby on Rails applications.

Matthew Rathbone / April 22, 2025

Tutorial

PostgreSQL JSON Function Examples

A comprehensive guide to working with JSON data in PostgreSQL with practical examples of common JSON operations.

Matthew Rathbone / March 23, 2025

Reviews

5 Free & Open Source SQL Server Management Studio Alternatives for 2025

Open source alternatives to SSMS that offer something different, all of them free and cross-platform!

Matthew Rathbone / March 22, 2025

Reviews

5 Free & Open Source phpMyAdmin Alternatives

Modern, desktop-based alternatives to phpMyAdmin that offer better performance and user experience

Matthew Rathbone / March 21, 2025

Reviews

5 Best Free & Open Source Database Managers for 2025

The top database management tools in 2025, all of them free and open source!

Matthew Rathbone / March 20, 2025

Reviews

5 Free & Open Source SQLPro Alternatives

Cross-platform, open source alternatives to SQLPro Studio that work on all operating systems

Matthew Rathbone / March 20, 2025

Reviews

Best Free & Open Source SQL Editors for Database Development

Discover the best free and open source SQL editors that make database development easier, faster, and more enjoyable.

Matthew Rathbone / March 19, 2025

Reviews

5 Free & Open Source PopSQL Alternatives

Open source alternatives to PopSQL that offer local-first database management with collaborative features

Matthew Rathbone / March 19, 2025

Reviews

5 Free & Open Source DB Browser for SQLite Alternatives

Open source DB Browser for SQLite alternatives with modern interfaces and multi-database support

Matthew Rathbone / March 18, 2025

Reviews

5 Free & Open Source HeidiSQL Alternatives

Open source HeidiSQL alternatives that work across all platforms, not just Windows!

Matthew Rathbone / March 17, 2025

Tutorial

MySQL Select Top N Rows: Easy Methods with LIMIT

Learn how to select the top N rows in MySQL using the LIMIT clause with examples for efficient data sorting.

Matthew Rathbone / March 14, 2025

Release

Beekeeper Studio 5.1 - DuckDB and MongoDB

DuckDB and MongoDB support have landed, along with a whole bunch of tweaks, bug fixes, and UI improvements

Matthew Rathbone / February 28, 2025

Tutorial

How to Remove Duplicate Records & Data in SQL

A step-by-step guide with examples showing practical ways to find and clean duplicate records using ROW_NUMBER, DISTINCT, and CTEs.

Matthew Rathbone / February 9, 2025

Reviews

5 Free & Open Source Azure Data Studio Alternatives for 2025

With Microsoft retiring Azure Data Studio in 2026, here are the best free and open source alternatives to consider!

Matthew Rathbone / January 20, 2025

Reviews

5 Free & Open Source MySQL Workbench Alternatives for 2025

Open source MySQL Workbench alternatives that offer something different, all of them free and open source!

Matthew Rathbone / January 15, 2025

Reviews

5 Best Free & Open Source Redshift GUIs for 2025

The top Redshift GUIs for 2025, all of them free and open!

Matthew Rathbone / January 7, 2025

Reviews

5 Best Free & Open Source SQLite GUIs for 2025

The top SQLite GUIs for 2025, all of them free and open!

Matthew Rathbone / December 13, 2024

Reviews

5 Top Free & Open Source SQL Server GUIs for 2025

The top SQL Server GUIs for 2025, all of them free and open!

Matthew Rathbone / December 9, 2024

Reviews

5 Best Free & Open Source MySQL GUIs for 2025

The top MySQL GUIs for 2025, all of them free and open!

Matthew Rathbone / December 1, 2024

Tutorial

How to Use SQL in Excel: Unleashing Data Analysis Capabilities

Learn how to combine Excel and SQL for powerful data analysis. Connect databases, write queries, and use add-ins like Power Query.

Matthew Rathbone / November 17, 2024

Tutorial

How to Uninstall SQL Server: A Step-by-Step Guide

Learn how to properly uninstall SQL Server using Control Panel, command prompt, or remove specific features with our comprehensive guide.

Matthew Rathbone / November 17, 2024

Tutorial

How to Pivot in PostgreSQL: A Comprehensive Guide

Master pivoting in PostgreSQL using CASE statements, crosstab functions, and aggregate operations to transform rows into columns.

Matthew Rathbone / November 17, 2024

Tutorial

How to Find Duplicates in SQL: A Step-by-Step Guide

Learn multiple techniques to find duplicate records in SQL using GROUP BY, COUNT, window functions, CTEs, and more with practical examples.

Matthew Rathbone / November 17, 2024

Release

Beekeeper Studio 5.0 Beta Release

ClickHouse support, IAM for Postgres, and JSON row view join the chat. Lots of behind the scenes changes to secure and modernize the app.

Matthew Rathbone / November 4, 2024

Reviews

5 Best Free & Open Source MariaDB GUIs for 2025

The top MariaDB GUIs for 2025, all of them free and open!

Matthew Rathbone / November 1, 2024

Tutorial

Data Querying Tools

Data querying is essential for managing and analyzing data stored in databases. In this guide, we will explore some of the most widely used data querying tools, highlighting their strengths, use cases, and practical examples.

Matthew Rathbone / October 21, 2024

Tutorial

How to Create a JDBC SQL Server Connection String

When connecting to a SQL Server database through a Java application, JDBC (Java Database Connectivity) is the bridge between your application and the database. A key component of this connection is the connection string. In this tutorial, we'll cover how to properly configure a JDBC connection string for SQL Server, what each part of the string means, and how to use it in your Java code.

Matthew Rathbone / September 23, 2024

Tutorial

How to use MariaDB with Docker

Using MariaDB with Docker and docker-compose can be a useful way to set up a development environment for your application. This guide will walk you through the process of setting up MariaDB with Docker, from installation to basic configuration.

Matthew Rathbone / September 21, 2024

Tutorial

Postgres in Docker - A Practical Guide

How to run Postgres using docker in development and in production - code examples included.

Matthew Rathbone / September 21, 2024

Tutorial

How to Query Active Record for Weekdays Only

When working with Rails applications, you might need to filter records based on weekdays only, excluding weekends. This requirement is common in scenarios like business hours reporting, scheduling, or other date-specific business logic. In this tutorial, we'll explore how to achieve this using 'Active Record' - Rails' built-in ORM (Object-Relational Mapping) tool.

Matthew Rathbone / September 12, 2024

Reviews

5 Best Free & Open Source PostgreSQL GUIs for 2025

The top PostgreSQL GUIs for 2025, all of them free and open!

Matthew Rathbone / September 11, 2024

Tutorial

How to Select Weekdays Only in Oracle SQL

In many business scenarios, you may need to perform operations or run queries that only consider weekdays. This can be especially important when dealing with working hours, schedules, or financial transactions, which typically exclude weekends. In this tutorial, we’ll walk through how to filter out weekends in Oracle SQL and work with weekdays only.

Matthew Rathbone / September 9, 2024

Tutorial

How to Show Grants in MySQL

Understanding and managing user permissions in MySQL is necessary for maintaining database security and proper access control. In this tutorial we will focus on displaying user privileges in MySQL using the `SHOW GRANTS` command.

Matthew Rathbone / September 8, 2024

Tutorial

How to Extract Total Days, Hours, or Minutes from an Interval in PostgreSQL

When working with date and time data in PostgreSQL, intervals are a common way to represent a span of time. Sometimes, you may need to extract specific components from an interval, such as total days, hours, or minutes. In this tutorial, we will cover how to extract these specific components from an interval.

Matthew Rathbone / August 28, 2024

Tutorial

How to Create a Table in Azure SQL Database

Creating tables is a fundamental task when working with databases, and Azure SQL Database is no exception. This tutorial will walk you through the steps to create a table in Azure SQL Database using SQL queries. We'll also cover some essential options and considerations to help you make the most out of your table creation.

Matthew Rathbone / August 26, 2024

Tutorial

How to Show Tables in PostgreSQL Using `psql`

When working with PostgreSQL, especially from the command line interface `psql`, one of the common tasks you'll perform is listing all tables in your current database. This guide will show you how to do that using various methods within psql.

Matthew Rathbone / August 25, 2024

Tutorial

How to Subtract in SQL

When working with databases, there are numerous scenarios where you might need to subtract values, whether it's to calculate differences between dates, subtract numeric values, or compare results across rows. This tutorial will guide you through the different ways to subtract in SQL, using practical examples that you can directly apply.

Matthew Rathbone / August 23, 2024

Tutorial

How to Rename a Table in PostgreSQL

Renaming a table in PostgreSQL is a straightforward task, but there are some important considerations to keep in mind. This tutorial will guide you through the process of renaming a table in PostgreSQL, explaining not only how to do it but also why it works the way it does.

Matthew Rathbone / August 19, 2024

Tutorial

How to Use SQL Query Templates

SQL query templates are a powerful tool to streamline your database operations and reduce repetitive coding. In this article, we'll walk through how to create and use SQL query templates, why they are beneficial, and provide code examples with expected outputs.

Matthew Rathbone / August 13, 2024

Tutorial

How to Rename a Column Using ALTER TABLE in SQL

Learn the different syntaxes for renaming columns using the ALTER TABLE command in SQL databases like MySQL, PostgreSQL, SQL Server, and SQLite.

Matthew Rathbone / August 8, 2024

Tutorial

How to Subtract in PostgreSQL

Learn how to perform subtraction ops in PostgreSQL, from basic numbers to dates and timestamps, with clear examples.

Matthew Rathbone / August 7, 2024

Tutorial

How to Create a Table in Oracle

Creating tables in Oracle is a fundamental task for managing your database schema. This guide will walk you through the essential steps and considerations when creating tables, including syntax, data types, and best practices.

Matthew Rathbone / July 29, 2024

Tutorial

How to Drop a Column in PostgreSQL

Dropping a column in PostgreSQL is a common operation when you need to clean up or optimize your database schema. This tutorial will walk you through the process of dropping a column, including why and how it works.

Matthew Rathbone / July 25, 2024

Tutorial

How to Rename a Column in PostgreSQL

Renaming a column in PostgreSQL is a common task when you need to make your database schema more intuitive and maintainable. This tutorial will guide you through the process, including potential pitfalls and considerations.

Matthew Rathbone / July 23, 2024

Tutorial

How to drop a table in MySQL

This tutorial will cover the syntax and practical use cases for dropping tables in MySQL, including safety precautions and potential pitfalls.

Matthew Rathbone / July 22, 2024

Tutorial

How to Kill a Session in PostgreSQL

Learn to kill sessions in PostgreSQL with our guide on using pg_terminate_backend and pg_cancel_backend functions effectively.

Matthew Rathbone / July 17, 2024

Tutorial

How to Kill Queries in Amazon Redshift

Learn how to identify, terminate, and automate problematic queries in Amazon Redshift to maintain optimal database performance.

Matthew Rathbone / July 15, 2024

Tutorial

How to Create Charts Using Ruby on Rails

Learn to create charts in Ruby on Rails using Chartkick. A simple tutorial for visualizing SQL data with charts.

Matthew Rathbone / July 10, 2024

Tutorial

How to Drop a Sequence in PostgreSQl

Learn how to drop a sequence in PostgreSQL efficiently using commands like DROP SEQUENCE, IF EXISTS, CASCADE, and RESTRICT.

Matthew Rathbone / July 6, 2024

Tutorial

How to Limit Rows in Teradata

Learn how to limit rows in Teradata using TOP, SAMPLE, and QUALIFY with practical examples to ennhance query performance and efficiency.

Matthew Rathbone / July 6, 2024

Tutorial

How to Drop Constraints in PostgreSQL

To drop a constraint in PostgreSQL, use the `ALTER TABLE` command followed by the `DROP CONSTRAINT` clause, specifying the name of the constraint to be dropped. Be careful, as this can potentially lead to data integrity issues.

Matthew Rathbone / July 6, 2024

Reviews

5 Free & Open Source DataGrip Alternatives for 2024

Open source DataGrip alternatives that offer something different, all of them free and open source!

Matthew Rathbone / July 2, 2024

Tutorial

Understanding and Resolving the "SQLite Database is Locked" Error

When working with SQLite databases, encountering a "database is locked" error can be a frustrating roadblock. This tutorial explains why this error occurs and provides practical solutions to resolve it, complete with code examples and their expected outputs.

Matthew Rathbone / June 25, 2024

Tutorial

PostgreSQL Stored Procedure Example Tutorial

Learn how to write and call PostgreSQL Stored Procedures with step-by-step examples

Matthew Rathbone / June 20, 2024

Tutorial

Storing Images in a Database: A How-To Guide

This tutorial will guide you through the process of storing images in SQL databases using BLOB (Binary Large Object) data types, providing practical examples and explanations.

Matthew Rathbone / June 18, 2024

Tutorial

How to Show Tables in SQLite

Learn how to show tables in SQLite using .tables & SELECT statements. Discover methods to see table schemas and utilize Beekeeper Studio for easy SQLite database management.

Matthew Rathbone / June 16, 2024

Release

Beekeeper Studio 4.6 - Azure SSO and LibSQL

Azure SQL SSO, support for LibSQL, and a bunch of bug fixes

Matthew Rathbone / June 12, 2024

Tutorial

Creating a User in MariaDB: A Step-by-Step Guide

To create a new user in MariaDB, use the `CREATE USER` and `GRANT` statements to create the user and grant necessary privileges, then use `FLUSH PRIVILEGES` to make the changes take effect. Manage user accounts carefully for security and integrity.

Matthew Rathbone / June 10, 2024

Tutorial

How to Add a Column in Teradata: A Step-by-Step Guide

Learn how to add a column in Teradata using the ALTER TABLE command with practical examples.

Matthew Rathbone / June 4, 2024

Tutorial

MySQL Change Column Type Guide

Learn how to change column type in MySQL using the ALTER TABLE statement. Follow practical examples to modify column data types efficiently.

Matthew Rathbone / May 28, 2024

Release

Beekeeper Studio 4.3.4 - Minimal mode

The start of a focus mode for Beekeeper Studio

Matthew Rathbone / May 22, 2024

Metrics

Teradata Corporation (TDC) Revenue, Updated for 2024 Q1

Teradata Corporation (TDC) booked $465,000,000 in 2024 Q1. Read for more metrics.

Matthew Rathbone / May 10, 2024

Metrics

Splunk Inc. (SPLK) Revenue, Updated for 2024 Q3

Splunk Inc. (SPLK) booked $1,067,355,000 in 2024 Q3. Read for more metrics.

Matthew Rathbone / May 10, 2024

Metrics

Snowflake Revenue, Updated for 2024 Q4

Snowflake Inc. booked $774,699,000 in 2024 Q4. Read for more metrics.

Matthew Rathbone / May 10, 2024

Metrics

MongoDB, Inc. (MDB) Revenue, Updated for 2024 Q4

MongoDB, Inc. (MDB) booked $458,002,000 in 2024 Q4. Read for more metrics.

Matthew Rathbone / May 10, 2024

Metrics

Elastic N.V. (ESTC) Revenue, Updated for 2024 Q3

Elastic N.V. (ESTC) booked $327,957,000 in 2024 Q3. Read for more metrics.

Matthew Rathbone / May 10, 2024

Metrics

Dynatrace Inc. (DT) Revenue, Updated for 2024 Q3

Dynatrace Inc. (DT) booked $365,096,000 in 2024 Q3. Read for more metrics.

Matthew Rathbone / May 10, 2024

Metrics

Datadog (DDOG) Revenue, Updated for 2024 Q1

Datadog (DDOG) booked $611,253,000 in 2024 Q1. Read for more metrics.

Matthew Rathbone / May 10, 2024

Metrics

Cloudera (CLDR) Revenue, Updated for 2022 Q2

Cloudera (CLDR) booked $236,057,000 in 2022 Q2. Read for more metrics.

Matthew Rathbone / May 10, 2024

Metrics

Alteryx, Inc. (AYX) Revenue, Updated for 2023 Q4

Alteryx, Inc. (AYX) booked $351,000,000 in Q4 2023. Read for more metrics.

Matthew Rathbone / May 10, 2024

Reviews

5 Free & Open Source DBeaver Alternatives for 2024

Open source DBeaver alternatives that offer something different, all of them free and open!

Matthew Rathbone / May 8, 2024

Tutorial

Cassandra Show Tables: How to List Tables Using CQL

Learn to show tables in Cassandra with simple CQL commands. Step-by-step guide for listing keyspaces and tables using cqlsh.

Matthew Rathbone / May 8, 2024

Tutorial

Deleting a Database in MySQL: A Step-by-Step Guide

To delete a database in MySQL, use the DROP DATABASE command, be careful, this action is permanent.

Matthew Rathbone / May 6, 2024

Tutorial

MySQL Subtraction Techniques

Learn how to perform subtractions in MySQL including numbers, columns, dates, aggregates, and handle NULL values effectively.

Matthew Rathbone / April 29, 2024

Tutorial

Adding a Primary Key to an Existing Table in PostgreSQL

Learn how to add a primary key to an existing table in PostgreSQL using the ALTER TABLE command

Matthew Rathbone / April 29, 2024

Tutorial

How to List Databases Using the psql command line tool

Use \l or \list to list databases. In this tutorial we'll also show you how to get more detailed information, such as the size, description, use roles & permissions, and tablespace data.

Matthew Rathbone / April 21, 2024

Tutorial

Understanding and Implementing 'SELECT TOP 1' in SQL

A guide to using 'SELECT TOP 1' for efficient data retrieval with equivalent methods for SQL Server, MySQL and PostgreSQL.

Matthew Rathbone / April 17, 2024

Tutorial

PostgreSQL Information_Schema Guide for Database Management

Learn how to use PostgreSQL information_schema to view tables, columns, constraints, and more for effective database management.

Matthew Rathbone / April 9, 2024

Tutorial

Understanding PostgreSQL Information_Schema Views

Explore the PostgreSQL information_schema views for insights on database structure, tables, columns, triggers, and constraints.

Matthew Rathbone / April 8, 2024

Release

Beekeeper Studio 4.2 - Firebird, SQL importing, & scaling up

We've laid the groundwork for more quickly adding new databases.

Matthew Rathbone / April 5, 2024

Tutorial

Configure GoDaddy MySQL Hostname - Step-by-Step Guide

Learn to find and set up your GoDaddy MySQL hostname for web apps. Essential guide for smooth database connections.

Matthew Rathbone / March 8, 2024

Tutorial

PostgreSQL How To Select Weekdays Only

Learn how to extract weekdays from dates in PostgreSQL. Code samples included

Matthew Rathbone / February 19, 2024

Tutorial

SQLite Subtract Operations: Learn How to Do It

Discover how to perform SQLite subtract operations with our guide, including date and time calculations. Code samples included.

Matthew Rathbone / February 14, 2024

Tutorial

SQL Server Subtraction Operations

Learn how to perform subtraction in SQL Server, handle NULL values, datetime calculations, and aggregate data sets with clear examples.

Matthew Rathbone / February 14, 2024

Tutorial

How to Rename a Column in SQL Server | Easy Step-by-Step Tutorial

Learn the stress-free way to rename a column in SQL Server using sp_rename and Beekeeper Studio. Our comprehensive guide covers everything from the basics to safeguarding against errors, ensuring a smooth SQL column renaming process.

Matthew Rathbone / January 18, 2024

Tutorial

Formatting Dates in Oracle Database - Quick Guide

Discover how TO_CHAR and TO_DATE functions can help you display and convert date values using various format codes. Perfect for developers aiming to refine their SQL skills.

Matthew Rathbone / January 13, 2024

Release

Beekeeper Studio 4.1 - Spreadsheet Mode, Modal Editor, Wayland Support, & More

Beekeeper Studio SQL Editor now behaves more like a spreadsheet (in the ways that matter).

Matthew Rathbone / January 12, 2024

Tutorial

Guide to Formatting Dates in PostgreSQL

Learn the ins and outs of formatting dates in PostgreSQL with our comprehensive guide. Dive into date types with examples and the TO_CHAR function to master PostgreSQL date formatting.

Matthew Rathbone / January 12, 2024

Tutorial

MySQL Create Index Tutorial: Optimizing MySQL Queries

How to create indexes in MySQL to enhance query performance. This guide with examples will introduce you to index creation for faster data retrieval and efficient querying.

Matthew Rathbone / January 6, 2024

Tutorial

MySQL Full Outer Join Explained With Code Examples

FULL OUTER JOIN is not supported by MySQL, in this guide we'll show you how to accomplish the same thing with a workaround

Matthew Rathbone / January 2, 2024

Release

Beekeeper Studio 4.0 - export, backup and restore your database

Create native database backups, restore backups, and create multi-table exports in Beekeeper Studio 3.20

Matthew Rathbone / September 28, 2023

Release

Beekeeper Studio 3.9.20 - export, backup and restore your database

Create native database backups, restore backups, and create multi-table exports in Beekeeper Studio 3.20

Matthew Rathbone / August 3, 2023

Tutorial

How to drop a foreign key constraint in PostgreSQL

Matthew Rathbone / May 24, 2023

Tutorial

How To Limit The Number Of Rows Returned In Oracle Database

Oracle doesn't have the LIMIT keywords, but fear not, we have other tools....but really hope you're using 12c+.

Matthew Rathbone / May 17, 2023

Tutorial

SQL Server Express Edition: Features and Limitations

Understand SQL Server Express limitations including 1 CPU, 1GB RAM, 4GB database size, network protocol restrictions, and missing enterprise features.

Beekeeper Studio Staff / May 9, 2023

Tutorial

SQL Server System Tables and Stored Procedures (SPs)

Comprehensive reference guide to SQL Server system tables and stored procedures found in master and user databases, essential for database administration.

Beekeeper Studio Staff / May 8, 2023

Tutorial

Essential SQL Server Performance Counters Guide

Learn how to monitor SQL Server performance using key counters: CPU utilization, memory usage, cache hit ratios, and disk I/O metrics with optimization strategies.

Beekeeper Studio Staff / May 7, 2023

Tutorial

The 4 Pillars of SQL Server Performance: CPU, Memory, Disk I/O, & Cache Hit Ratios

Master SQL Server performance optimization by understanding the four key metrics: CPU utilization, memory management, cache hit ratios, and disk I/O performance.

Beekeeper Studio Staff / May 6, 2023

Tutorial

SQL Server does not exist or access denied

Beekeeper Studio Staff / May 3, 2023

Tutorial

How To Limit The Number Of Rows Returned In Redshift

When you only want a subset of your results in Redshift, this is how you do it.

Matthew Rathbone / May 3, 2023

Tutorial

SQL Server Client Network Utility

Beekeeper Studio Staff / May 1, 2023

Tutorial

Difference and Limitations: MSDE vs. SQL Server

Beekeeper Studio Staff / April 26, 2023

Tutorial

How To Limit The Number Of Rows Returned In SQLite

If you don't want to pull back all records for a large SQLite dataset, or page through data, here's how

Matthew Rathbone / April 26, 2023

Tutorial

Convert Microsoft Access databases to SQL Server or MSDE

Beekeeper Studio Staff / April 25, 2023

Tutorial

System Tables and Stored Procedures - SQL Server

Beekeeper Studio Staff / April 23, 2023

Tutorial

Connecting to SQL Server 2005 and SQL Server Express

Beekeeper Studio Staff / April 21, 2023

Tutorial

SQL Server Administration

Beekeeper Studio Staff / April 20, 2023

Tutorial

SQL Server Development and T-SQL

Beekeeper Studio Staff / April 19, 2023

Tutorial

Understanding DDL triggers in SQL Server 2005

Beekeeper Studio Staff / April 19, 2023

Tutorial

How To Limit The Number Of Rows Returned In SQL Server

If you don't want to pull back all records for a large SQL Server dataset, or page through data, here's how

Matthew Rathbone / April 19, 2023

Tutorial

Migrating changes made to SQL Server databases to production

Beekeeper Studio Staff / April 15, 2023

Tutorial

Longhorn, Vista to drop SQL Server 2000 and MSDE support

Beekeeper Studio Staff / April 14, 2023

Tutorial

SQL Server Express and MSDE

Beekeeper Studio Staff / April 13, 2023

SQL Server Administration

sp_spaceused: Determine SQL Server table size

Teratrax / April 12, 2023

Tutorial

How To Limit The Number Of Rows Returned In BigQuery

Use the LIMIT clause to limit the number of rows returned. Combine with OFFSET to page through your data. But be careful - costs can mount quickly with BigQuery.

Matthew Rathbone / April 12, 2023

Tutorial

Filter stored procedure resultset with ISNULL

Beekeeper Studio Staff / April 11, 2023

Tutorial

How to Verify SQL Server and MSDE Installation

Learn how to check if SQL Server or MSDE is installed on your computer through Windows Services and how to identify default and named instances.

Beekeeper Studio Staff / April 10, 2023

SQL Server Administration

MDAC explained (ADO version 2.5, 2.6, 2.7, and 2.8)

Teratrax / April 9, 2023

Tutorial

Specified SQL Server not found

Beekeeper Studio Staff / April 8, 2023

Tutorial

SQL query analyzer tool

Beekeeper Studio Staff / April 7, 2023

Release

Beekeeper Studio 3.9 - Ramping up after a slow winter

User enums, better sorting, PostgreSQL partition support, massive Electron upgrade and a whole lot of bug fixes

Matthew Rathbone / April 7, 2023

Tutorial

Compare SQL Server 2005 Editions

Beekeeper Studio Staff / April 6, 2023

Tutorial

SQL Server Utility (SSEUtil) - Essential Features Guide

Learn about SQL Server Utility tool (SSEUtil) functions including database management, SQL execution, performance measurement, and server monitoring capabilities.

Beekeeper Studio Staff / April 5, 2023

Tutorial

How To Limit The Number Of Rows Returned In PostgreSQL

How to limit the number of rows returned for pagination, reporting, or debugging.

Matthew Rathbone / April 5, 2023

Tutorial

Microsoft SQL Server Cursors

Beekeeper Studio Staff / April 4, 2023

Tutorial

Client Network Utility: Configure MSDE protocols

Beekeeper Studio Staff / April 3, 2023

Tutorial

SQL Server Performance Optimization Guide

Learn essential SQL Server performance tuning techniques, including memory management, 64-bit advantages, reducing blocking, monitoring key performance counters, and index maintenance.

Beekeeper Studio Staff / April 2, 2023

Tutorial

OPENROWSET: Import data into SQL Server tables

Beekeeper Studio Staff / April 1, 2023

SQL Server Administration

Automate archival of daily SQL Server backups

Teratrax / March 31, 2023

Tutorial

View SQL Server Agent job history

Beekeeper Studio Staff / March 30, 2023

Tutorial

Microsoft SQL Server Desktop Engine (MSDE) 2000 Guide

Learn about MSDE 2000 capabilities, limitations, and benefits. Understand database size limits, replication features, and when to use this SQL Server alternative.

Beekeeper Studio Staff / March 29, 2023

Tutorial

How To Limit The Number Of Rows Returned In MySQL

Use row limiting to paginate, debug, or perform reporting in your MySQL database.

Matthew Rathbone / March 29, 2023

Tutorial

MSDE vs. SQL Server

Beekeeper Studio Staff / March 28, 2023

Tutorial

Convert Microsoft Access databases to SQL Server or MSDE

Beekeeper Studio Staff / March 27, 2023

Tutorial

History and Benefits of Microsoft SQL Server Desktop Engine (MSDE)

Learn about Microsoft SQL Server Desktop Engine (MSDE) history, benefits, and how it compares to SQL Server and the Jet engine for desktop database applications.

Beekeeper Studio Staff / March 26, 2023

Tutorial

SQL Server 2005 Express: Express Manager, Management Studio, downloads, & limitations

Beekeeper Studio Staff / March 25, 2023

Tutorial

sp_helpdb: How big is your database log file?

Beekeeper Studio Staff / March 23, 2023

Tutorial

List available SQL Server instances on the network

Beekeeper Studio Staff / March 22, 2023

Tutorial

How to Rename a Column in Oracle Database

Sometimes you just need a column to have a different name, but don't worry, it's super easy to do in Oracle.

Matthew Rathbone / March 22, 2023

Tutorial

How many rows does your largest SQL Server table contain?

Beekeeper Studio Staff / March 21, 2023

Tutorial

Microsoft released SQL Server 2005 SP2 CTP

Beekeeper Studio Staff / March 20, 2023

SQL Server Administration

DBCC CHECKCONSTRAINS: Verify foreign key integrity

Teratrax / March 19, 2023

Tutorial

Verify SQL Server and MSDE Installation

Beekeeper Studio Staff / March 18, 2023

Tutorial

SQL Server Performance Analysis: Key Monitoring Areas

Learn the four critical areas of SQL Server performance monitoring: System Utilization, Batches and Stored Procedures, Connectivity and Concurrency, and SQL Server Agent Jobs.

Beekeeper Studio Staff / March 18, 2023

SQL Reference

SOUNDEX() helps you find that last name

Beekeeper Studio Staff / March 18, 2023

Tutorial