Eleven Challenges in Unifying Reference Data

Question

Eleven Challenges in Unifying Reference Data

David.Poole

SSC Guru

Points: 76000
More actions
December 19, 2012 at 11:31 pm

#98743

Comments posted to this topic are about the item Eleven Challenges in Unifying Reference Data
LinkedIn Profile

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Mike Dougherty-384281 SSCrazy Points: 2794 More actions · Answer 1

great article. I liked the story it told. I imagine anyone who has been through it before recognized a lot of the issues you mentioned. Anyone who hasn't done it already should view it as a roadmap with carefully labeled potholes/pitfalls.

I wonder if anyone else read this title in their email subject as "Elven challenges..."? I was initially expecting Middle-Earth DBA building a single grand lookup table. 🙂

David.Poole SSC Guru Points: 76000 More actions · Answer 2

I wonder if anyone else read this title in their email subject as "Elven challenges..."?

I to am being pestered to take the kids to see The Hobbit!

I suspect that, if pushed, the development community would describe DBAs as data orcs;-)

LinkedIn Profile

gavwat Valued Member Points: 60 More actions · Answer 3

Thank you for sharing such a detailed and well-explained solution.

Quick question: At the time did you evaluate SQL Server Master Data Services (MDS) as an option for your Reference Data requirements and have you subsequently looked at the possibilities around Reference Data in SQL Server's Data Quality Services (DQS)?

David.Poole SSC Guru Points: 76000 More actions · Answer 4

I've been to a few presentations on DQS and to be honest it looks like a version 1.0 product. It seems to be a question of shifting your data to the service which given the size of the data would be impractical. The last two SQL Bits sessions on DQS looked interesting but didn't give me a light-bulb moment.

I haven't had the chance to look at Master Data Services yet but it is on my radar.

LinkedIn Profile

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 5

SPAM reported.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Neha05 Default port Points: 1494 More actions · Answer 6

Neha05

Default port

Points: 1494

December 24, 2012 at 11:20 am

#1571321

Nice article