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 – March Meeting

by Leave a Comment

Topic: Power BI Architecture

Overview: Having the right architecture is key to the adoption of Power BI, and to make the most of your business intelligence solution. This session guides you through different Power BI architectures, such as Direct Query, Import, Connect Live, Composite Models, and Embedded. We will analyze different techniques in data refresh, incremental extraction, integration and collaboration to provide a quick overview of the different approaches available.

Speaker: SolidQ North America CEO and Microsoft Data Platform MVP. Paco Gonzalez has more than 15 years leading teams for high visibility solutions on Data Platform, Business Intelligence, and Machine Learning. He is also a frequent speaker at large and small conferences. SQL Saturdays, TechEd’s, PASS BA, PASS Summit, DevWeek London, PAW Chicago and London, or Ignite.

Sponsor: The tools and technologies to manage information will constantly evolve, but the need for accurate and actionable information is timeless. SolidQ delivers services for Microsoft platforms that help you architect, integrate and optimize your use of data. The result? Our clients think bigger and move faster because we help them build the capacity and skills to interact with data in creative, collaborative ways that deliver new insights to the business. At SolidQ we measure our success by your satisfaction – and we guarantee it.

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

When: Monday, March 4, 2019 6:30-8:30 ET

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