Sifiso

The People’s Race

Sunday, 6th November 2022 our team participated in the 27th “The People’s Race”. The race took place at the FNB Stadium in Nasrec, Johannesburg.  Three marathons took place, during the course of the event.  The Standard Marathon, Half Marathon, and 10 Kilometer Race.  Completing the race within the allotted time, awarded participants with a medal. …

The People’s Race Read More »

ethnic girl having video chat with teacher online on laptop

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 45-course subscription Unfortunately, as stated in the picture you will …

Pluralsight courses available with MSDN Subscription Read More »

Master Data Services Insufficient Memory Error

A business case that requires the usage of Master Data Services finally landed on 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 test virtual machine environment so …

Master Data Services Insufficient Memory Error Read More »

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 error. In this post, I provide ways of resolving these errors. Error: Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required” failed The error …

Resolving PolyBase Installation Errors in SQL Server 2016 Read More »

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 the package deployment model. In this post, …

Single package deployment does not replace package deployment Read More »

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 …

Installing SQL Server Data Tools for Visual Studio 2015 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 …

SQL Server Exercise for Data Warehouse Candidates Read More »