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

How do you use PowerShell toc check if an active directory user locked out, disabled etc.?

By

If your organization uses a password policy (there are very good odds these days...

DBA Myths: The system sessions are the ones with a session_id 50 or less

By

Anecdotally any session_id that’s 50 or less is going to be a system session...

SQL Undercover TV – Encrypting SQL Backups

By

In this episode, David looks at how we can encrypt our SQL Server backup...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Is it possible get from Query Store historical ~ CPU % usage by each query ?

By ebooklub

Is it possible get from Query Store historical ~ CPU % usage by each...

missing storage space

By MVDBA (Mike Vessey)

Hi I have a particular drive on one of my sql servers, it's gotten...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers