MDS: Copying models and data to another server
Having recently completed a model in Master Data Services (MDS), I needed to move the model from a development environment...
2012-10-23 (first published: 2012-10-16)
6,006 reads
James Serra's Blog
24 Hours of PASS videos online
All the videos for the sessions at 24 Hours of PASS (Fall 2012) are available for free. Check the session schedule for...
2012-10-12
743 reads
Interacting with Master Data Services (MDS)
There are four different way to interact with Master Data Services (MDS) to do things such as create a model, load...
2012-10-11
3,135 reads
MDS Error: “Cannot insert the value NULL into column ‘Code’”
In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error:
“Cannot...
2012-10-09
1,252 reads
SharePoint dependencies
Microsoft has made a big push the last few years to have all its end-user BI tools integrate with SharePoint,...
2012-10-04
697 reads
Master Data Services (MDS): Bug deleting an attribute
UPDATE on 11/28/2012: I had this same error when trying to delete a model. Fortunately, SQL Server 2012 SP1 has...
2012-10-04
1,411 reads
Master Data Services: Copy Versions
In Master Data Services (MDS), you can use the Master Data Manager Web User Interface “UI” to copy a version of...
2012-10-02
1,137 reads
MDS Error: “The status of the specified batch is not valid”
In Master Data Services (MDS), I received a strange error when I was calling a stored procedure (stg.upd_name_Leaf) to batch...
2012-09-27
2,368 reads
Master Data Services: Resources
Here are some of my favorite Master Data Services (MDS) resources:
SQL Server Master Data Services Utilities: A set of useful...
2012-09-25
2,557 reads
TechEd Australia 2012 videos online
Microsoft has posted ALL the session videos for TechEd Austrialia 2012 and they are available for free! Get your learning...
2012-09-24
802 reads
Blogs
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers