Neal Waterstreet

Speaking at SQLSaturday 825 – Chicago

by Leave a Comment

The schedule has been posted and I’ve been selected to speak at SQLSaturday 825 Chicago. I’ll be presenting “Master Data Management with SQL Server 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 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.”

I’ve made some updates to this presentation over the past few weeks and I’m looking forward to the event. If you are interested in MDM, Reference Data or just want to see what MDS is please come by and say hi.

 

MDS Error: “200085: The attribute cannot be saved. The input mask is not valid.”

by Leave a Comment

During a recent deployment, I received an error that I’d never seen before. It’s always fun to get these.

“200085: The attribute cannot be saved. The input mask is not valid.”

My initial thought was that someone had modified an attribute and created a conflict. The model was new and sparsely populated, so I was able to view the data. It didn’t appear to be data related.

It turned out to be a custom input mask was not included in the deployment. The mask was created in a lower environment but never migrated. Once that update was made the deployment completed successfully.

 

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)

Atlanta Microsoft BI Group – September Meeting

by Leave a Comment

Please note the new meeting location below.

When: Tuesday, September 25, 2018 6:30-8:30 ET

Topic: Mastering data with Microsoft Master Data Services (MDS) for strategic advantage

Overview: Mastering customer, product, employee, job, and recipe data has become increasing important to companies focused on becoming data driven organization:

Mastering Data with Microsoft Master Data Services (MDS):

  • Data Modeling Strategy
  • Hierarchy Strategy and Management
  • Application-level transaction management
  • Bulk data movement
  • Security and Access
  • Microsoft’s MDS Direction

Other Strategies and Consideration for mastering data:

  • User Experience, Governance and Data Stewardship
  • Address, Person, and Email Standardization
  • Matching Records and Survivorship
  • Workflow and Event needs
  • Direct and real-time Application Integration

Speaker:  John Rossiter is a subject-matter expert in Master Data Management with a focus on strategy, governance, and process with twenty years of experience serving clients in multiple industries: high tech, retail, airline/aerospace, government (Federal, State, Municipal), consumer packaged goods, and financial services. John has successfully led large consulting projects, leveraging technology, process improvement, and change management to deliver a wide range of solutions, including Master Data Management, ERP system implementation, Supply Chain Management, and eCommerce.

Sponsor: Profisee is an Atlanta area base Master Data enterprise software company solely focused on master and reference data management with customers in the US, Canada, Europe, and Australia.

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

When: Tuesday, September 25, 2018 6:30-8:30 ET

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