Author Archives: Sifiso Ndlovu

Installing SQL Server Data Tools for Visual Studio 2015

In my article, Single package deployment in SQL Server Integration Services 2016, I highlighted the joys of single package deployment available in the release of SQL Server Data Tools 2015 and SQL Server 2016. The only feeling of misery in the overall SSDT 2015 you are likely to experience is during the installation of Business… Read More »

SQL Server Exercise for Data Warehouse Candidates

Background Part of the process when looking for candidates to bring into a data warehouse team is to ensure that you hire competent and reliable people. We recently had to fill a data warehouse position in our team and I setup the following technical exercise that helps measure technical competencies of candidates. Candidates were required to do… Read More »

How to Trim Characters in C#

The removing of leading and trailing characters in c# is made possible by the System namespace. My demo is uses a windows form to illustrate trimming of characters. My form looks as shown below. The default value in my text box is my name printed with leading and trailing characters as ”         … Read More »

Multiple Tagging of TFS Work Items Using Excel

In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can be used to manage SQL Server-related development. Some of the feedback I received from the article was the issue of tagging items in Excel. This article illustrates how TFS work items can be multi-tagged using… Read More »

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 »