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,131 reads
James Serra's Blog
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,249 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
695 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,403 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,132 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,366 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,551 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
799 reads
SQL Server Data Tools (SSDT) – September 2012 update
SQL Server Data Tools (SSDT) has a new update (version 11.1.20905, with the previous version being 11.1.20225). The SSDT team...
2012-09-21
1,588 reads
Master Data Services: Expand the Leaf member attributes box
In Master Data Services (MDS), when using the Master Data Manager Web User Interface (“UI”), you will notice the “Leaf member...
2012-09-19
801 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
Economics of AI: What is the Real Cost to Profit?
Comments posted to this topic are about the item Economics of AI: What is...
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers