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. You should notice – among other benefits – Pluralsight course subscription, as shown below: Unfortunately, as stated in the picture you will notice that you don’t have… Read More »

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 test virtual machine environment so I was certain… Read More »

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 the “hidden” ProgramData folder However I ran into… 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 errors. 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… 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 package deployment model. In this post, I try to clear… Read More »

Connect to SQL Server in QlikView

As business intelligence solution developers, we should not limit ourselves to using tools from specific vendors instead we should try and explore as many data visualization tools as we possibly can. In this article, we illustrate using screenshots on how you can connect to SQL Server from QlikView to visualize SQL Server data. How to… Read More »