As your organization grows, one challenge will be the management of data between systems and organizational units. With MDS, Microsoft gives you the ability to have one accurate source of non-transactional data. This data can then be used within applications, other databases, and ETL processes. By leveraging data stewards to help manage the data repository, you ensure that your MDS data is up-to-date and accurate.
In this presentation we will cover MDS from start to finish including installation, creating models/entities, working with data, using the Excel add-in, security, hierarchies, views, versions, and business rules. After this presentation, you will have a good understanding of what master data management is, what MDS does, how to use it, and how to get started with your own MDS project.
Speaker: Jeff Prom, Data Architect , Silver Bay Realy Trust Corp
Jeff Prom is a Data and BI Developer with over 15 years of experience. From a wide variety of industries, he has worked with corporations both large and small including several global fortune 50 companies. Jeff is an active member in the SQL community and regularly speaks and attends user groups and conferences. He has earned MCTS certifications for Database Development, Administration, and BI. Jeff is currently employed at Silver Bay Realty Trust Corp as a Data Architect.
If you are like many, you've been hearing a lot about Parallel Data Warehouse (PDW) lately. PDW is Microsoft's appliance solution with SQL Server 2012 that allows massively parallel processing (MPP) of database workloads. But how do you know that you have a workload that requires or could benefit from MPP over the standard symmetric multiprocessing (SMP) architecture? In this session, we'll review that question and more with a run through of how to identify MPP workloads? As part of the session, we'll also review some of the key components and differentiators of the PDW platform.
Jason Strate, SQL Server Database Architect, Pragmatic Works
Jason Strate is a SQL Server database architect with Pragmatic Works. He is also a Microsoft SQL Server MVP and MCM. He has over 15 years of experience developing, architecting, and managing data platforms. As a PASS community member, Jason has lead user groups, organized SQL Saturdays, and is currently a Regional Mentor for PASS’s North Central US region. Jason is a well-known presenter and author on SQL Server and data platform topics. He has been author or editor on five books and blogging at www.jasonstrate.com. He’s also presented at the PASS Summit, TechEd NA, dozens of SQL Saturdays, and other SQL Server community events. And if that isn’t enough, he’s never been too far away from the karaoke after parties which may include an occasional unicorn.
Sanjay Kaul, Technology Specialist, Microsoft
Sanjay Kaul is a Technology Specialist at Microsoft who specializes in helping customers envision, design, and deploy data life cycle, data warehouse, and business intelligence focused solutions using the Microsoft platform. In his 12th year at Microsoft, Sanjay has spent time in Microsoft’s consulting group, enterprise SQL Server sales, SQL Server & BI Architect at the Microsoft Technology Center in Minneapolis, before moving to his current role of Data Warehouse Technology Specialist. With all the experience gained in the industry ranging from data architecture, disaster recovery planning, governance, database optimization, and data warehousing, his goal is to gain a deep understanding of the customer’s needs and help create solutions that exactly meet their needs.