Tim Kent's Blog

SQLBits 9–Master Data Services Training Day

As I’m sure many of you have heard, SQLBits 9 has been announced and will be at the Adelphi Hotel in Liverpool from 29th September to 1st October this year.  Jeremy and I will be presenting a full day training on Master Data Services

Master your data with MDS

A end to end look inside Master Data Services, this full day course will begin with a synopsis of Master Data Management before moving on to an overview of Microsoft SQL Server 2008 R2 Master Data Services (MDS) and then looking in detail at topics such as:

  • installing, configuring, and maintaining Master Data Services
  • creating and using models
  • version management
  • business rules and workflow
  • importing data into Master Data Services
  • Integrating with other systems
  • Security. 

It will also take a brief look at what’s coming next for MDS in the SQL Server Denali.
This course is for anyone who wants to manage and maintain their business master data and improve data quality with Microsoft SQL Server Master Data Services.  A basic understanding of Microsoft SQL Server is required.

If you don’t fancy MDS, there are ten other training days being offered.

Registration for the training days and conference should be open in the next few weeks and pricing remains the same as last time – an unbelievable £375 for the full conference if you book before 26th August!

Master Data Services Webinars–March and April

If you haven’t yet seen Master Data Services in action or are interested to find out how it could fit into your organisation then it might be worth signing up for one of the webinars that Profisee are running in March and April:

The first two of these (March 18th and April 8th) look at MDS in general, but in particular:

  • Learn the basics of master data management (MDM) and the business problems it solves
  • Realize the invaluable link between MDM and your business intelligence & enterprise reporting initiatives
  • Uncover the key components to a successful MDM strategy and implementation
  • Experience Master Data Services in action with a live demonstration and open questions & answers
  • Determine how Master Data Services can benefit your organization and what you can do to lead your MDM strategy

The second (March 25th and April 29th) are more focussed around the Master Data Maestro product which the Profisee team have developed on the MDS platform.  One of the features of Maestro that stands out is the user interface which, lets be honest, is a little lacking in MDS but there’s more to it than that.

In case you haven’t heard of them before, Profisee was formed by the team from Stratature after Microsoft bought the product from them and turned it into Master Data Services so they know it pretty well! 

SQLBits 7 – Spaces going fast

We’ve now had over 500 registrations for SQLBits 7 so if you haven’t registered already, you’d better get moving before it’s too late!  There’s also still a few spaces left for the  training day on Thursday.  Even though the early bird offer has expired, these still represent incredible value for money at £300!

As Jeremy has already posted. he’s presenting a session on Master Data Services on the Saturday.  I’ve seen his draft presentation and if you want to get a great high level overview of what MDS is all about then don’t miss it.  I’m presenting a session on Data Visualisation techniques on the Friday and Adatis are once again sponsoring the event.

SQLBits 7 – voting is open!

Following on from my post on Friday, Session submission is now closed.  There have been very close to 100 sessions submitted about pretty much everything to do with SQL Server (some very loosely!!)

Unfortunately we can’t fit all of these sessions into two days and it’s impossible to choose, so unlike many other conferences, it’s up to you lot to vote for the ones you want!  As long as you have a registration on the SQLBits website you can vote (even if you don’t know if you can make it yet!).  You get to vote for 10 sessions and the top sessions within each track will get the gig!

Power to the people!

Connecting to AS2000 from X64 Excel Services - SharePoint

I can’t imagine too many people will have this issue, but just in case you you have a similar environment it’s bad news I’m afraid.  Connections from 64-bit applications to AS2000 aren’t possible as there is no x64 oledb 8.0 AS driver.  If you’re running IA64 then you’re fine as MS built a library for this version (?)

The alternatives? Run SharePoint and IIS in 32-bit mode or, probably better, point out to your boss/customer/IT dept that 2010 subtract 2000 = 10 years and that it really is time to upgrade to the wonders of SQL2008 R2.  The fact they can actually get support for this version might help swing it ;)

PerformancePoint Services and PowerPivot document

MSFT have just a published a new document about how to use PowerPivot Cubes\workbooks as data sources for your PPS dashboards.  Worth a read as it doesn’t work quite the same way as a standard AS data source in PPS.  A couple of things stood out for me:

Dimensions and Attribute Hierarchies

Every table, including a Fact table, in the PowerPivot window is shown as a dimension in PerformancePoint. The columns in each table are represented as an attribute hierarchy under the respective dimension in PPS. In a similar manner, calculated columns in the PowerPivot window are displayed as attribute hierarchies for that dimension.



PerformancePoint uses the ADOMD.NET driver to connect to PowerPivot applications.

In order to use a PowerPivot model in PerformancePoint, you must install the new SQL Server 2008 R2 ADOMD.NET driver on the servers that are running the PerformancePoint service in the SharePoint Server farm. This is not required if such servers also have the server component of PowerPivot, that is the SQL Server PowerPivot for SharePoint, installed on them.

SQL Server Master Data Services now available

Whilst the core components of SQL 2008 R2 have been signing autographs on the red carpet, Master Data Services has sneaked quietly in through the back door.   If you have MSDN access, download a full version (guessing developer and enterprise only but haven’t checked) and off you go.  The install is a not part of the main installation either, you need to run it directly from the DVD\ISO in the MasterDataServices folder.  Setup is very simple and there’s some good sample packages to play with. 

StreamInsight is on there as well :)

Feedback for SQLBits VI

As Chris Webb has already mentioned the latest SQLBits was the best attended and (in our opinion) the slickest event yet.  We still want to make it even better though and we can only do that with your feedback.  This is all done online and can be completely anonymous if you want.  If you can spare five or ten minutes then please use the links below and let us know what you think:

Conference Feedback

Session Feedback