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
Rob Gravelle demonstrates a sure-fire way to calculate how much disk space your MySQL data entities are taking up.
2016-07-12
2,667 reads
2016-04-01
1,481 reads
Both management and various departments rely on data reports to help guide their business decisions. Rob Gravelle presents ten open source and commercial report generation tools for MySQL and other relational databases.
2016-01-11
4,964 reads
In this follow-up to Beyond the LIKE Operator: Advanced Pattern Matching with MySQL, Rob Gravelle shows how to use the REGEXP operator to match alphanumeric characters, explores the role of meta-characters, and compares standard regular expression syntax to that of MySQL.
2015-12-02
3,785 reads
Inserting and updating table contents with data from other tables and/or views within the same database need not be a nail-biting ordeal. Rob Gravelle shares some common Insert and Update tasks to help avoid any problems.
2015-09-25
2,820 reads
MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 to allow you to raise your own error conditions from stored procedures, triggers, and events. Rob Gravelle demonstrates how to utilize both.
2015-08-17
2,032 reads
This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.
2012-05-02
4,079 reads
Many people want to create a customized migration process using SQL Server Integration Services (SSIS), but it is hard to start working with heterogeneous databases like MySQL, Postgres, DB2, etc. Check out this tip to learn about how to import data from heterogeneous databases like MySQL to SQL Server.
2012-04-20
3,717 reads
In this article, we are going to create a linked server to the MySQL Database.
Once finished that task, we will select, insert, update and delete some data using SQL Server.
2012-04-17
9,936 reads
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers