June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

MySQL – Video Course – MySQL Backup and Recovery Fundamentals

June 10, 2014
Pinal Dave
SQL, SQL Tips and Tricks
MySQL, SQL Backup and Restore
Data is the one of the most crucial things for any organization and keeping data safe is the biggest challenge for any DBA. This is true for any organizations. Think about the scenario that you have a database which is extremely important and suddenly you accidently delete the most important…
Read More

MySQL – Introduction to CONCAT and CONCAT_WS functions

June 7, 2014
Pinal Dave
SQL, SQL Tips and Tricks
MySQL
MySQL supports two types of concatenation functions. They are CONCAT and CONCAT_WS CONCAT function just concats all the argument values as such SELECT CONCAT('Television','Mobile','Furniture'); The above code returns the following TelevisionMobileFurniture If you want to concatenate them with a comma, either you need to specify the comma at the end…
Read More

MySQL – Introduction to User Defined Variables

May 31, 2014
Pinal Dave
SQL, SQL Tips and Tricks
MySQL
MySQL supports user defined variables to have some data that can be used later part of your query. You can save a value to a variable using a SELECT statement and later you can access its value. Unlike other RDBMSs, you do not need to declare the data type for…
Read More

MySQL – Scalability on Amazon RDS: Scale out to multiple RDS instances

May 21, 2014
Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
MySQL, SQL Server

Today, I’d like to discuss getting better MySQL scalability on Amazon RDS.
The question of the day: “What can you do when a MySQL database needs to scale write-intensive workloads beyond the capabilities of the largest available machine on Amazon RDS?”

Read More

SQL SERVER – 3 Challenges for DBA and Smart Solutions

May 20, 2014
Pinal Dave
SQL
Devart, MySQL, SQL Utility

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.

Read More

SQL SERVER – Migration Assistant Upgraded to Support SQL Server 2014

May 18, 2014
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
MySQL, SQL Documentation, SQL Download
We all start somewhere when it is about database. There are different reasons, why we go for one database over another database. Usually the reason is cost and convenience. After a period of time when business is successful and traffic is growing, the same two reasons of cost and convenience…
Read More

MySQL – Beginning Temporary Tables in MySQL

May 16, 2014
Pinal Dave
SQL, SQL Tips and Tricks
MySQL
MySQL supports Temporary tables to store the resultsets temporarily for a given connection. Temporary tables are created with the keyword TEMPORARY along with the CREATE TABLE statement. Let us create the temporary table named Temp CREATE TEMPORARY TABLE TEMP (id INT); Now you can find out the column names using…
Read More
Previous 1 … 6 7 8 9 10 11 12 … 17 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version