Neal Waterstreet

Some things I've learned about Data Warehousing, Business Intelligence and other stuff too

Speaking at SQLSaturday #733 Atlanta 2018

by Leave a Comment

On Saturday, May 19th, I’m speaking at SQLSaturday #733 Atlanta 2018! I’m presenting my session “Master Data Management with SQL Server 2016 MDS”. The event is at a new location again this year, Gwinnett Technical College on Old Milton Pkwy. I’m speaking during the first sessions at 8 a.m. in the Patagonia room. Nothing like a fresh cup of MDM first thing in the morning to get the day started!

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.

MDS: Issue with upgrading server

by Leave a Comment

We recently upgraded a clustered server to MDS 2016. I went to go verify the upgrade and ran into this strange error when viewing all of the entities:

After troubleshooting for a while, the cause became painfully obvious. It turned out that I needed to clear the cache in IE since it still had the previous 2012 version in cache.

I hope this saves someone some time.

Speaking at SQLSaturday #699 Tampa 2018

by Leave a Comment

On Saturday, February 24th, I’m speaking at SQLSaturday #699 Tampa 2018! I’m presenting my session “Master Data Management with SQL Server 2016 MDS”.

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.

MDS: Problem with user access

by Leave a Comment

Last week there was a problem with user access after a migration between environments. Members of one of the AD groups that had been granted access were not able to access the website or by the MDS Add-in for Excel.

First, I checked the security settings and there was no problem with the configuration. Everything looked OK with each of the security sections. I then added one of the users manually to check if it was a problem with the AD group itself. The user was able to access the model and modify data successfully. The AD group name was spelled correctly, but the scope was set to “Global” instead of “Universal”. Once the AD group was updated all of the users were able to access MDS.

References:

https://technet.microsoft.com/en-us/library/cc755692(v=ws.10).aspx