Monthly Archives: October 2012

SQL Server 2012: New Business Intelligence features

Posted on October 30, 2012 by

SQL Server 2012 has many new Business Intelligence (BI) features and enhancements.  Here are my top 12, in order of importance: Power View.  A fun, visual, and powerful drag-and-drop ad-hoc reporting tool.  It is a web-based end-user BI tool based … Continue reading →

Posted in Business Intelligence, SQL Server 2012, SQLServerPedia Syndication | 5 Comments

Using PerformancePoint against tabular data

Posted on October 25, 2012 by

PerformancePoint (PPS) is typically used against multidimensional data sources (i.e. Analysis Services), but it does have the ability, albeit limited, to work against tabular data sources such as SQL Server tables, SharePoint Lists, Excel Services, Import From Excel Workbooks, and even PowerPivot (with … Continue reading →

Posted in PerformancePoint, SQLServerPedia Syndication | 2 Comments

Master Data Services (MDS): Miscellaneous tips

Posted on October 23, 2012 by

I have come across a number of tips while using MDS.  These are tips not big enough for their own blog post, so I list them all here: To “hide” an attribute in the MDS Excel add-in, set the pixel … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication | 7 Comments

Should a placement firm tell you what they are billing the client?

Posted on October 18, 2012 by

As a 1099 consultant, I usually use a placement firm to find a contract job.  I always ask the placement firm what rate they are billing the client.  They usually tell me.  When they don’t, it’s a sure sign that … Continue reading →

Posted in Career, Consulting, SQLServerPedia Syndication | 7 Comments

MDS: Copying models and data to another server

Posted on October 16, 2012 by

Having recently completed a model in Master Data Services (MDS), I needed to move the model from a development environment to a QA environment.  Below is some helpful tips if you need to do the same, along with details on … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication | 2 Comments

24 Hours of PASS videos online

Posted on October 12, 2012 by

All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free.  Check the session schedule for a complete list.  Enjoy!

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

Interacting with Master Data Services (MDS)

Posted on October 11, 2012 by

There are five different way to interact with Master Data Services (MDS) to do things such as create a model, load data into MDS, manage business rules, versioning, etc. Master Data Manager Web User Interface (“UI”), also called the Master Data Manager Web … Continue reading →

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

MDS Error: “Cannot insert the value NULL into column ‘Code’”

Posted on October 9, 2012 by

In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error: “Cannot insert the value NULL into column ‘Code’, table ‘MDS2012.mdm.tblStgErrorDetail’; column does not allow nulls. INSERT fails.” As described in … Continue reading →

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

Master Data Services (MDS): Bug deleting an attribute

Posted on October 4, 2012 by

UPDATE on 11/28/2012:  I had this same error when trying to delete a model.  Fortunately, SQL Server 2012 SP1 has fixed this bug! In Master Data Services (MDS), when trying to delete an attribute in an entity, I received the … Continue reading →

Posted in MDS/MDM, SQLServerPedia Syndication | 2 Comments

Master Data Services: Copy Versions

Posted on October 2, 2012 by

In Master Data Services (MDS), you can use the Master Data Manager Web User Interface “UI” to copy a version of a model and create a new version of it (via the Version Management screen).  However, you may find the “Copy” … Continue reading →

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