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 »

Where’s my Team Explorer 2015?

Team Explorer is a client software that can be used to integrate Visual Studio with an instance of Team Foundation Server (on-premise or cloud based). Over the years of using TFS – I’ve looked forward to downloading and installing Team Explorer for every version of Team Foundation Server. So you will understand my bewilderment when… 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 »

Execute All Packages Within SSIS Project Catalog

The SSIS Project Deployment Model is great! It really is the best thing since sliced bread! I specifically appreciate the package execution logging and reporting that is provided by this model but …. (there is always a but :), right), lately I’ve been looking for ways to execute all packages within a project at once.… Read More »

Handling No Data in SSRS Controls

When SQL Server Reporting Services (SSRS) successfully renders a given report control (i.e. Table, Matrix, List etc.), the result set can either be empty (which means no data returned) or actually show data. In cases whereby an empty result set is returned, SSRS controls, such as tables and charts, use NoDataMessage and NoRowsMessage properties to inform report users… Read More »