Category Archives: SQL Server

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 »

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 »

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 »