Data Quality & Reference Data Management Keynote

This year I was asked to deliver a portion of the 2016 TMW Systems / PeopleNet In.Sight Conference Keynote which was held in September at the Gaylord Opryland Hotel. I was so honored and excited to have the opportunity to speak to a crowd of thousands. Below is a link to my 10 minute talk. I had a so much fun doing this presentation and hope to do more at this level in the future.

Using Powershell to set Roles & Features required for MDS

This is my 3rd go-around installing MDS on SQL Server. I’ve been playing with it on each of the new SQL 2016 RC builds. Today I’m once again standing it up. Hey, practice makes perfect!

One of the first things that needs to happen in order to get MDS up and running is that the Roles & Features for the server need to be in the right state. Today I was playing with Powershell some (long story…but it involves an orphaned storage group in Azure), so I was already in a Powershell kind of mood. I then found a handy script, which allows you to use Powershell to “presto-chango” get the Roles & Features just right.


I was a little bit awkward pulling it off, but got it done. Wow, that was WAY easier than opening up the Roles and Features area of Windows! no more iterating through all of it, trying to make sure I didn’t miss anything.


But then, trying to run the Master Data Services Configuraiton Manager I still got one more warning about it needing the feature for Dynamic Web Compression in IIS to be enabled. **sigh**  So — I went back into powershell and added that feature:


After that, everything was good as gold.  As you can see, in the Master Data Services Configuration Manager I had green checkbox on Prerequisites. Now I can move forward!


Here’s the entire consolidated Powershell batch for you to copy/paste and run in your environment:

Install-WindowsFeature Web-Mgmt-Console, AS-NET-Framework, Web-Asp-Net, Web-Asp-Net45, Web-Default-Doc, Web-Dir-Browsing, Web-Http-Errors, Web-Static-Content, Web-Http-Logging, Web-Request-Monitor, Web-Stat-Compression, Web-Filtering, Web-Windows-Auth, NET-Framework-Core, WAS-Process-Model, WAS-NET-Environment, WAS-Config-APIs

Install-WindowsFeature Web-App-Dev, NET-Framework-45-Features -IncludeAllSubFeature –Restart

Install-WindowsFeature Web-Dyn-Compression