MySQL

Using ADF to Upload Disparate CSV Files into Azure MySQL

  • Article

In this article our objective is to showcase how to leverage Azure Data Factory (ADF) and a custom script to upload data in Azure MySQL database when we have CSV files with different schemas. As there is no straightforward way to upload data directly using ADF for this given scenario, it will actually help to […]

2021-03-04

1,246 reads

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

Everyone Run a SQL Saturday in 2021

By

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

Modern Data Warehouse & Reverse ETL

By

An extension to the Modern Data Warehouse (MDW) that I have heard a bit...

Daily Coping 12 Apr 2021

By

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

Read the latest Blogs

Forums

performance tuning

By rohitkocharda

Hi everyone, Any good suggestion to tune below query:   --CREATE NONCLUSTERED INDEX nonclust_code...

Understanding the Internals of a Data Page

By Mohsin_A_Khan

Comments posted to this topic are about the item Understanding the Internals of a...

Preventing Trigger Execution

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Preventing Trigger Execution

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers