MySQL

Top 6 MySQL DBA Mistakes

  • Article

To err is human, or so the saying goes. Unfortunately, in the world of IT, innocuous mistakes made early on can lead to really daunting problems down the road. In this article, Rob Gravelle goes over a few of the most common DBA mistakes to avoid. Some of these relate specifically to MySQL, while others may be applicable to any RDBMS.

2016-11-14

4,315 reads

Querying Multiple MySQL Tables

  • Article

It’s been said that one of the drawbacks to normalization to the third form (3NF) is more cumbersome data extraction due to the greater number of tables. These require careful linking via JOIN clauses. Improper table joining can easily result in erroneous results or even in the dreaded Cartesian Product. In today’s article, Rob Gravelle explores how table joins are achieved in MySQL.

2016-09-23

3,720 reads

Blogs

Daily Coping 14 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Setting default values for Array parameters/variables in Azure Data Factory

By

(2020-Aug-14) Setting default values for my parameters or variables in Azure Data Factory (ADF)...

Daily Coping 13 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

SSIS - How to convert DateTime from ISO format

By sabarishbabu

Hello, In my source file having DateCreated column as ISO format string like '2020-08-05T05:50:49.844Z'....

How to compare strings by letters in certain places

By BOR15K

Hello All, I need help to compare strings, please. For example, I have two...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers