Calculating MySQL Database, Table, and Column Sizes
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
MySQL
2016-04-01
1,475 reads
Top 10 MySQL Reporting Tools
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
MySQL Pattern Matching using Regular Expressions
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
Common MySQL Insert and Update Tasks and Their Solutions
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 Error Handling using the Signal and Resignal Statements
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
20 tips on converting MySQL views to MS SQL
This article gives 20 tips how to modify MySQL views to make it compatible with Microsoft SQL Server.
2012-05-02
4,073 reads
Export data from MySQL to SQL Server
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
Linked server to MySQL Server.
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,903 reads
MySQL Primer for the SQL Sever DBA
This is an introduction into Mysql for the SQL Server user. It compares the various engines of Mysql and how they compare to SQL Server.
2008-08-08
7,854 reads
Blogs
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
Secure Your SQL Estate: Best Practices for Azure SQL Security
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Forums
Visual Studio SSIS Package Showing Up Blank
Hi all, this is my first time posting on this forum, thank you all...
MySQL 5.6 not writing any logs
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
How to resolve issue of custom Audit log table containing incorrect data?
We have created a parent table, child table & Audit log table in SQL...
Question of the Day
Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers