MySQL Tips and Tricks – Part1

MySQL like any other database has its own pros and cons, you can find them on the web easily, here are a couple Pros & Cons of MySQL Blob’d Images or Pros and Cons of MySQL In this blog I will talk about INNER JOIN vs. IN and LEFT JOIN vs.

Read More

Converting Data Attribute to Table Attribute Part II

As promised from my previous blog “Converting Data Attribute to Table Attribute Part I”; here is the MySQL code demonstration. First, let us create the two tables and populate them with some data DROP TABLE IF EXISTS users; DROP TABLE IF EXISTS user_attribute; CREATE TABLE users ( id INT UNSIGNED

Read More

Converting Data Attribute to Table Attribute Part I

WHAT IS THIS ALL ABOUT? Sometimes there is a need to create dynamic tables or views with variable field structure; In this post, I’m going to explain how to convert data attributes into table attributes; data attributes are values in table field; TABLES STRUCTURE WE HAVE Users table id Username

Read More

DATA MIGRATION FROM LEGACY SYSTEMS – Part2

In this blog, I will walk you throw an example of how to migrate data from csv file into MySQL, this is not the only way you can do this but I found this simple and easy in the case I was handling Data migration/conversion goes throw the following: –

Read More

DATA MIGRATION FROM LEGACY SYSTEMS – Part1

Introduction In most businesses, data migration/conversion becomes a necessary routine and is something that we deal with on a regular basis. To add to the problem, most business systems now hold far more data than in previous years and so there is far more data that need to be moved.

Read More

Is TRUNCATE the cause or is it something else?

I’ll try to explain the situation here as much as I can; we have a .net web app that uses MySQL as the backend database; database size is about 250GB and has 130GB of memory; the app is multi-tenant; one of the app components is a windows services that runs

Read More

Management Styles

Over the last several years and as I grew in my field, I’ve been observing and watching how I manage and lead different teams and compare myself with other managers and leaders; I have learnt a lot from great managers and leaders over those years but again no one is

Read More