Neal Waterstreet

MDS Features in SQL Server 2019 CTP 2.2

by Leave a Comment

I finally downloaded a copy of CTP 2.2 and installed it to check out MDS and DQS for any new features and make sure they’re both still included. The preview only allows new installs, so I wasn’t able to upgrade from an older version. Hopefully I can try an upgrade in an upcoming release.

The HTML5 interface seems a little more reactive than Silverlight. Here are some screenshots with MDS running in Chrome on Windows Server 2019:

Here’s the main screen, which looks almost the same.

MDS Explorer.

Editing a member.

I haven’t compared the 2019 database to an older version yet but will do so and report in another post.

Atlanta Microsoft BI Group – October Meeting

by Leave a Comment

On October 30th, I’ll be presenting “Data Quality – Plain & Simple” at the Atlanta Microsoft BI Group. Due to the PASS Summit, we’ll be having the meeting a week early this month. Starting in December, we’ll be meeting on the first Monday of the month at the Microsoft Technology Center in Alpharetta.

Please note the new meeting location below.

When: Tuesday, October 30, 2018 6:30-8:30 ET

Topic: Data Quality – Plain & Simple

Data quality is a subject that comes up over and over again in many organizations. Most executives are concerned about the quality of the information used in their decisions. We talk about “good data” and “bad data” but what do those terms mean? In this presentation, we will first define what data quality is and look at how to measure it with data quality dimensions. Then, we’ll explore common causes for data quality issues and how to perform a data quality assessment. Finally, we’ll review the results and discuss some strategies and tools that can help improve the quality of the data in your organization.

RSVP at http://atlantabi.pass.org/

Sponsor: ZAP

Where: Microsoft Technology Center, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA 30009 (https://binged.it/2KQLAPw)

Changing The Case Of An Object in MDS

by Leave a Comment

One question that comes up from time to time is how to change the case of an object once it is created in MDS. This can be done for a variety of reasons and it’s really easy to do.

In this example we’ll change “Sampleattribute” to “SampleAttribute”.

1. Select the attribute and click “Edit”.
2. The “Sampleattribute” is displayed on the right.
3. Simply rename the “Name” and “DisplayName” to something different and click “Save”.
4. Change the “Name” and “DisplayName” to the correct value and click “Save”.
5. Now the attribute has the correct case.

Speaking at SQLSaturday #806 Charlotte 2018!

by Leave a Comment

On Saturday, October 20th, I’m speaking at SQLSaturday #806 Charlotte 2018! I’ll be presenting my session “Master Data Management with SQL Server 2016 MDS”. If you’re able to attend the event, stop by and say hello.

Want to know the position Master Data Management and MDS play in an organization’s overall data strategy? We’ll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We’ll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.