Category Archives: Database

Duplicate MySQL Table Using phpMyAdmin

There many reasons for creating copies of existing relational database tables. Sometimes you create duplicate tables for the purposes of table backup or for application testing purposes.  Whatever your reasons may be, you will notice that different relational database integrated development environments (IDE) implement table duplication differently.   I would like to demonstrate how a… Read More »

SQL Server Database Source Control using VSO Git

For a while now, I have ensured that the source code of new projects that I have undertaken (in both contract and permanent employment) is version controlled. In some instances, some clients have their local installation of source control system and in such cases I would integrate with the clients source control system. However, in numerous… Read More »

Dimensional Modelling in Lucidchart vs Visio: Part 1

Data modelling is a pivotal skill that every practitioner in data management should acquire. That said, there are numerous tools that can be used to model data. As a Certified Microsoft Professional, my default modelling tool has always been Microsoft (MS) Visio and sometimes, Visual Studio. However, I’ve recently been introduced to Lucidchart and it completely blew my… Read More »