Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

Archives: September 2012

MDS Error: “The status of the specified batch is not valid”

In Master Data Services (MDS), I received a strange error when I was calling a stored procedure (stg.upd_name_Leaf) to batch a staging table, which will load data from the staging tables into the appropriate MDS tables:

[Execute SQL Task] Error: Executing the query “declare @versionName nvarchar(50) set @versionNam…”… Read more

9 comments, 1,198 reads

Posted in James Serra's Blog on 27 September 2012

Master Data Services: Resources

Here are some of my favorite Master Data Services (MDS) resources:

SQL Server Master Data Services Utilities: A set of useful add-ons for SQL Server Master Data Services, including utilities for generating an MDS model, loading the model, writing a custom UI for model data and integrating the model… Read more

1 comments, 1,674 reads

Posted in James Serra's Blog on 25 September 2012

TechEd Australia 2012 videos online

Microsoft has posted ALL the session videos for TechEd Austrialia 2012 and they are available for free!  Get your learning cap on.  Check them out here.

Read more

0 comments, 613 reads

Posted in James Serra's Blog on 24 September 2012

SQL Server Data Tools (SSDT) – September 2012 update

SQL Server Data Tools (SSDT) has a new update (version 11.1.20905, with the previous version being 11.1.20225).  The SSDT team is committed to delivering regular, frequent releases of SSDT, and this is the first in a long line of updates.  This release of SSDT now supports the Visual Studio 2012… Read more

0 comments, 1,247 reads

Posted in James Serra's Blog on 21 September 2012

Master Data Services: Expand the Leaf member attributes box

In Master Data Services (MDS), when using the Master Data Manager Web User Interface (“UI”), you will notice the “Leaf member attributes” box on the “Edit Entity” screen is too small.  It only fits four rows.  This can be very annoying as you will need to use the scroll bars… Read more

0 comments, 548 reads

Posted in James Serra's Blog on 19 September 2012

Master Data Services: Versioning

In Master Data Services (MDS), you can create multiple versions of the master data within a model.  When you create a model for the first time, MDS creates a default initial version of your model data.  You can create as many versions you want for your model, either in sequential… Read more

0 comments, 2,396 reads

Posted in James Serra's Blog on 17 September 2012

Master Data Services Terminology Overview

When moving from a data warehouse world to MDM, there is some new terminology to learn.  Each of the terms below are components of a Master Data Services model.  In brackets is the equivalent term in the data warehouse world:

  • Domain – subject area; what you are managing (i.e. customer,…

Read more

0 comments, 645 reads

Posted in James Serra's Blog on 12 September 2012

Master Data Services: Changing a model with a subscription view

I have been working heavily with Microsoft Data Services (MDS) in SQL Server 2012 over the past few months, and really like the product.  Through my use of it I have learned some tips and tricks that I will share on this blog over the next few months.  My first… Read more

2 comments, 1,556 reads

Posted in James Serra's Blog on 10 September 2012

The MERGE statement in SQL Server

The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based on data in a source table in one easy statement, replacing lots of messy code.  I use it frequently when building a data warehouse.

In short, the statement joins… Read more

0 comments, 4,374 reads

Posted in James Serra's Blog on 5 September 2012