Here is the story of my latest weekend experiments. Those who know me are familiar that I try to do something new every weekend and post my experience over here. Earlier this week, I published my course on MySQL Backup and Recovery. After doing this course, I realize that everything I had covered in the course was related to native MySQL backup, but there should be some solution outside which caters to the larger need of MySQL Backup. Additionally, I found that taking backup with MySQL is hit and miss as well as there is no systemic reporting there. I decided to do some research on my own on the internet. I tried out various tools, softwares and quite a few third party plug-ins.
Developer’s Life – Every Developer is a Chhota Bheem
Chhota Bheem is a cartoon character that is extremely popular where I live. He is my daughter’s favorite characters. I like to say that children love Chhota Bheem more than their parents – it is lucky for us he is not real! Children love Chhota Bheem because he is the…
Read MoreSQLAuthority News – SQL Server 2012 Service Pack 2 is Available
Microsoft has announced SQL Server 2012 service pack 2 is available earlier this week. Service packages are cumulative updates and upgrade all editions of SQL Server 2012. This service pack contains up to and including SQL Server 2012 Service Pack1 Cumulative Update 9 (CU9). Here is the list of the…
Read MoreSQL SERVER – How to Get SQL Server Restart Notification?
Few days back my friend called me to know if there is any tool which can be used to get restart notification about SQL in their environment. I told that SQL Server can do it by itself with some configurations. He was happy and surprised to know that he need…
Read MoreSQL SERVER – SQL Server High Availability Options – Notes from the Field #032
[Notes from Pinal]: When it is about High Availability or Disaster Recovery, I often see people getting confused. There are so many options available that when the user has to select what is the most optimal solution for their organization they are often confused. Most of the people even know…
Read MoreMySQL – Video Course – MySQL Backup and Recovery Fundamentals
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 MoreMySQL – Introduction to CONCAT and CONCAT_WS functions
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