ROSQL invites you to a special meeting dedicated to SQL Server, on 5th of March 2015, starting at 17:30, at Microsoft Romania.
For registration please use the following URL: http://1drv.ms/17auGq1
17:30- 18:00 Microsoft's Data Platform lately - Cristian Lefter, SQL Server MVP, sqlserver.ro
18:10 - 19:30 End-to-End SQL Server Master Data Services - Peter Myers, SQL Server MVP, Director - Training and Mentoring at BizData
About our guest and his session
Peter Myers has worked with Microsoft database and development products since 1997.
Today, he specializes in all Microsoft BI products and provides mentoring, technical training, and training course content authoring for SQL Server, Office, and SharePoint.
Peter has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with solid experience backed by current MCSE and MCT certifications. He lives in Melbourne, Australia and has been a SQL Server MVP since 2007.
End-to-End SQL Server Master Data Services
This presentation describes how SQL Server Master Data Services can be used to implement Master Data Management (MDM). It introduces the discipline of MDM and maps common processes to the feature set of Master Data Services.
Topics include defining models, entities, attributes and hierarchies, to store and manage master data. Additionally, administrative tasks including business rules to validate data, the import and export of master data, model versioning, and permission management will be described. The two Microsoft user interfaces (the Master Data Manager web application, and the Excel add-in) will be covered, in addition to T-SQL scripting opportunities to automate master data processes.
This session will be of interest to data stewards, ETL developers and ETL administrators to appreciate what SQL Server 2012 (or 2014) Master Data Services can achieve.