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

Azure Database for PostgreSQL

By

Having worked with Azure SQL Database and its many flavours for couple of years...

Why I Support Code Automation Tools Like ORMs

By

I know I’m a weirdo. I’ve always been a weirdo. When I was a...

#PowershellBasics: Run a file and pass it a parameter.

By

I realized in my last #PowershellBasics post that I was talking about running a...

Read the latest Blogs

Forums

Error on executing rename statement

By VSSGeorge

Error on executing rename statement in a table. Not able to debug this. Please...

In-memory database

By LLSQL42

Hi, Currently i am processing records in SQL Server itself. Any recommended in-memory database,...

Replication CDC -- Cannot Truncate Table

By GonnaCatchIT

Dear All, We just enabled Replication services (CDC) on few of the databases. Now...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers