Accidentally deleted an important table? My video course MySQL Backup and Recovery Fundamentals shows how to keep your MySQL data safe and bring it back.
MySQL – Introduction to CONCAT and CONCAT_WS functions
MySQL has two concatenation functions, CONCAT and CONCAT_WS. I show how each one works and why CONCAT_WS makes adding a separator easier.
MySQL – Introduction to User Defined Variables
MySQL user defined variables let you store a value and use it later in your query, with no data type to declare. Here is how to set and read them.
MySQL – Scalability on Amazon RDS: Scale out to multiple RDS instances
Improve MySQL scalability on Amazon RDS when writes outgrow the largest instance, by scaling out to multiple RDS instances for heavy loads.
SQL SERVER – 3 Challenges for DBA and Smart Solutions
Developer’s life is never easy. DBA’s life is even crazier. Let us see in this blog post 3 Challenges for DBA and Smart Solutions.
SQL SERVER – Migration Assistant Upgraded to Support SQL Server 2014
SQL Server Migration Assistant upgraded its support to SQL Server 2014, so you can move from another database to any edition from SQL Server 2005 to 2014.
MySQL – Beginning Temporary Tables in MySQL
MySQL temporary tables hold result sets for one connection and are dropped when it closes. Here is how to create them and why INFORMATION_SCHEMA skips them.