Monthly Archives: January 2013

SSIS 2012: Empty toolbox?

Posted on January 29, 2013 by

This is an annoying problem I have had a few times: I open a SQL Server Integration Services (SSIS) project in SSDT, and see that the Toolbox pane is empty, displaying a “There are no usable controls in this group. … Continue reading →

Posted in SQLServerPedia Syndication, SSDT/Juneau, SSIS | 4 Comments

Missing Data Quality Service (DQS) buttons in Excel

Posted on January 24, 2013 by

The Master Data Services add-in for Excel has Data Quality Services functionality to help you match data before publishing it to the MDS repository.  When you make a connection, if a DQS database is installed on the same instance of … Continue reading →

Posted in DQS, SQLServerPedia Syndication | 1 Comment

PASS Business Analytics Conference Presentation

Posted on January 23, 2013 by

I am fortunate enough to have been selected to give a presentation at the PASS Business Analytics Conference in Chicago on April 10-12.  Below is my presentation abstract along with more info about the conference.  My session will be on … Continue reading →

Posted in Data warehouse, PASS, Presentation, Session, SQLServerPedia Syndication | Leave a comment

SQL Server 2012 SP1 Causes MsiInstaller Application Log Entries

Posted on January 17, 2013 by

After installing SP1 to SQL Server 2012 (11.0.3000) on one of our servers, I noticed higher than normal CPU loads due to msiexec.exe running non-stop.  The cpu percentage would bounce from 0% to 13%, and the application log would have five new … Continue reading →

Posted in SQL Server 2012, SQLServerPedia Syndication | 1 Comment

SSAS: One giant cube or many small ones?

Posted on January 15, 2013 by

When using SQL Server Analysis Services (SSAS) to build a cube, you may start out with one fact table, but then decide to add another fact table.  You are then faced with a decision: Do you add that fact table … Continue reading →

Posted in SQLServerPedia Syndication, SSAS | 7 Comments

MDS Error SYSERR207 after SQL Server 2012 SP1 Upgrade

Posted on January 10, 2013 by

After upgrading to SQL Server 2012 SP1, I ran into a bug in Master Data Services (MDS) that applies only to models that are deployed or created after SP1 is applied (models deployed or created before SP1 is applied are … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication | Leave a comment

Master Data Management (MDM) Hub Architecture

Posted on January 8, 2013 by

The Master Data Management (MDM) hub is a database with the software to manage the master data that is stored in the database and keep it synchronized with the transactional systems that use the master data.  There are three basic styles … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication | Leave a comment

MDS: The Microsoft SQL Server license has expired

Posted on January 3, 2013 by

When installing Master Data Services (MDS) in SQL Server 2012 or installing SQL Server 2012 sp1 (and possibly a CU), you might see the message “The Microsoft SQL Server license has expired” when trying to pull up the MDS web … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication | 3 Comments