Neal Waterstreet

  • Home
  • About
  • Book Reviews
    • 2018 Reading List
    • 2017 Reading List
    • 2016 Reading List
    • 2015 Reading List
    • 2014 Reading List
    • 2013 Reading List
  • Projects
    • OBi200
    • DS716+ memory upgrade
    • Cord cutting
  • Presentations
  • Contact

MDS Features in SQL Server 2019 CTP 2.2

January 11, 2019 by neal 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.

Filed Under: Data, MDS Tagged With: HTML5, SQL Server 2019 CTP2.2

Atlanta Microsoft BI Group – October Meeting

October 23, 2018 by neal 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)

Filed Under: Atlanta Microsoft BI, Presentation Tagged With: Data Quality, DQS, MDS

Changing The Case Of An Object in MDS

October 22, 2018 by neal 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.

Filed Under: MDS Tagged With: Attribute, Change case

Speaking at SQLSaturday #806 Charlotte 2018!

October 8, 2018 by neal 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.

Filed Under: Stuff

  • « Previous Page
  • 1
  • 2
  • 3
  • 4
  • …
  • 24
  • Next Page »
March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Mar    

Blogroll

  • Atlanta MDF
  • Atlanta Microsoft Business Intelligence Group
  • Atlanta Modern Excel User Group
  • Chris Webb's BI Blog
  • codegumbo
  • Lance England
  • PowerPivotPro
  • Prologika
  • SQLBI

Tags

#SQLSatATLBI Aereo at Atlanta Microsoft BI Azure Azure DataFest Backups Batch Certification changeset Chicago Conference CrashPlan Data Modeling Data Quality DAX Deployment DVR Entity-based staging Error Messages Excel Filter Goals Headphones Healthcare Leaf Tables MDM MDS MDS Add-in for Excel Oops! Something went wrong PASS Healthcare VC Power BI Power Pivot review Roku SQLSaturday SQL Saturday 800 SQLSaturday Atlanta BI SSIS Streaming Subscription View Time Training Validation Version Flag

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2023 · Minimum Pro Theme on Genesis Framework · WordPress · Log in