-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Select SIFISO Blogs

Sifiso W. Ndlovu is a certified Microsoft professional who holds a Master’s degree in IT Management from the University of Johannesburg. He specializes on a range of enterprise and consumer technologies using open source and proprietary software. He is the member of the Johannesburg SQL User Group wherein he has made several presentations on User Group Meetings and SQL Saturday sessions. He has written for a number of publications including SQLShack.com and SQLServerCentral.com.

Pluralsight courses available with MSDN Subscription

One of the benefits of having an MSDN Subscription is that you have free access to some Pluralsight courses.

To verify this, you can visit the My Account page of MSDN Subscription  website.

MSDN Subscriptions

You should notice – among other benefits – Pluralsight course subscription, as shown below:

Pluralsight…

Read more

0 comments, 22 reads

Posted in Select SIFISO Blogs on 8 September 2016

Master Data Services Insufficient Memory Error

A business case that requires the usage of Master Data Services finally landed in my desk. As part of delivering this business case, I had to install and configure SQL Server 2014 Master Data Services in production. I had previously installed and configured SQL Server Master Data Services in a… Read more

0 comments, 21 reads

Posted in Select SIFISO Blogs on 24 August 2016

Resolving Windows Folder Access Denied Error

I previously got rid of my desktop when its motherboard got damaged. Prior to throwing it away, I recovered its SATA hard drive.

I recently connected the retrieved hard drive into my laptop as shown above (Local Disk (G:)) and attempted to delete windows system folders such as… Read more

0 comments, 14 reads

Posted in Select SIFISO Blogs on 17 August 2016

Resolving PolyBase Installation Errors in SQL Server 2016

One of the exciting new features you may want to explore in SQL Server 2016 is PolyBase. However, as I attempted to install PolyBase, I ran into more than one errors. In this post, I provide ways of resolving these errors.

Error: Rule “Oracle JRE 7 Update 51 (64-bit)… Read more

0 comments, 61 reads

Posted in Select SIFISO Blogs on 15 July 2016

Single package deployment does not replace package deployment

In my article, Single package deployment in SQL Server Integration Services 2016, I covered the exciting single package deployment feature available in SQL Server 2016 via SQL Server Data Tools (SSDT) 2015. I think in the midst of the excitement, some people started confusing this new feature with package… Read more

0 comments, 120 reads

Posted in Select SIFISO Blogs on 30 June 2016

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… Read more

0 comments, 1,986 reads

Posted in Select SIFISO Blogs on 20 May 2016

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… Read more

0 comments, 159 reads

Posted in Select SIFISO Blogs on 18 April 2016

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… Read more

0 comments, 390 reads

Posted in Select SIFISO Blogs on 30 March 2016

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… Read more

0 comments, 194 reads

Posted in Select SIFISO Blogs on 14 November 2015

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… Read more

0 comments, 209 reads

Posted in Select SIFISO Blogs on 3 November 2015

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… Read more

0 comments, 105 reads

Posted in Select SIFISO Blogs on 26 October 2015

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… Read more

0 comments, 2,214 reads

Posted in Select SIFISO Blogs on 6 July 2015

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… Read more

0 comments, 1,960 reads

Posted in Select SIFISO Blogs on 15 June 2015