Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Eleven Challenges in Unifying Reference Data Expand / Collapse
Author
Message
Posted Wednesday, December 19, 2012 11:31 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:07 AM
Points: 2,916, Visits: 1,854
Comments posted to this topic are about the item Eleven Challenges in Unifying Reference Data

LinkedIn Profile
Newbie on www.simple-talk.com
Post #1398790
Posted Thursday, December 20, 2012 8:24 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 10, 2014 6:19 AM
Points: 262, Visits: 919
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. :)
Post #1399004
Posted Thursday, December 20, 2012 8:41 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:07 AM
Points: 2,916, Visits: 1,854
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
Newbie on www.simple-talk.com
Post #1399019
Posted Thursday, December 20, 2012 3:31 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, November 1, 2014 2:56 AM
Points: 4, Visits: 69
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)?
Post #1399124
Posted Thursday, December 20, 2012 4:27 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 3:07 AM
Points: 2,916, Visits: 1,854
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
Newbie on www.simple-talk.com
Post #1399128
Posted Saturday, December 22, 2012 10:08 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:42 PM
Points: 35,612, Visits: 32,208
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1399729
Posted Monday, December 24, 2012 11:20 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, April 15, 2013 11:42 PM
Points: 424, Visits: 55
Nice article
Post #1399939
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse