MySQL’s BLACKHOLE Storage Engine: The Odd Feature I Wish SQL Server Shipped With
Learn about a MySQL feature that could be useful in some scenarios for SQL Server.
2025-11-10
4,092 reads
MySQL
How to Repair Corrupt MySQL Tables
In the modern world, the companies are not solely dependent on a specific database server platform. There are many database platforms available that are adequate to handle moderate workload and client requirements of high availability and disaster recovery. MySQL is one of those database platforms which provides a lot of features and high performance. Just […]
2024-12-27
1,267 reads
Interesting Aurora MySQL Feature: The Buffer Pool Survives Restarts
Lemme start this off by saying this is probably irrelevant to you. (It’s irrelevant to me, too.)
2024-01-05
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.
2023-08-04
324 reads
Modifying MySQL data from within Python
In the previous article in this series, I introduced you to how to access MySQL data from within a Python script. The article described how to use the MySQL Connector to establish a connection with a database and then retrieve data through that connection. In this article, I continue the discussion by demonstrating how to insert, update, and delete data in a MySQL database, again working with Python and the MySQL Connector.
2023-08-02
Build a Better WordPress Archives Page Using MySQL
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table. But let’s start from the beginning, by starting from the end.
2023-06-07
139 reads
Build a Better WordPress Archives Page Using MySQL
I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data from an events table. But let’s start from the beginning, by starting from the end.
2023-06-07
How Snowflake Creates and Detects Deadlocks
In this article, we look at how Snowflake handles deadlocks and the process of creating a deadlock and detecting a deadlock.
2023-05-29
Unlock the Power of Google Cloud SQL: Setting Up SQL Server and PostgreSQL Instances
Learn how to get started with Google Cloud MySQL and PostgreSQL databases by creating and configuring a database.
2023-05-26
1,004 reads
Retrieving MySQL data from within Python
The approach you take when accessing MySQL will depend on the programming language you’re using and the connector you choose for interfacing with the database. Whatever approach you take, the same basic principles generally apply to each environment. You must establish a connection to the database and then issue the commands necessary to retrieve or modify the data.
2023-05-24
Blogs
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
A New Word: Dead Reckoning
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
PASS Data Community Summit 2025 Slides and Code
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Forums
Personal Contact Is Vital
Comments posted to this topic are about the item Personal Contact Is Vital
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers