|
|
-
|
|
Here are some of my favorite Master Data Services (MDS) resources:
SQL Server Master Data Services Utilities: A set of useful add-ons for SQL Server Master Data Services, including utilities for generating an MDS model, loading the model, writing a custom ...
|
|
-
|
|
Microsoft has posted ALL the session videos for TechEd Austrialia 2012 and they are available for free! Get your learning cap on. Check them out here.
...
|
|
-
|
|
SQL Server Data Tools (SSDT) has a new update (version 11.1.20905, with the previous version being 10.3.20225). The SSDT team is committed to delivering regular, frequent releases of SSDT, and this is the first in a long line of updates. This release of ...
|
|
-
|
|
In Master Data Services (MDS), when using the Master Data Manager Web User Interface (“UI”), you will notice the “Leaf member attributes” box on the “Edit Entity” screen is too small. It only fits four rows. This can be very annoy...
|
|
-
|
|
In Master Data Services (MDS), you can create multiple versions of the master data within a model. When you create a model for the first time, MDS creates a default initial version of your model data. You can create as many versions you want for your mod...
|
|
-
|
|
When moving from a data warehouse world to MDM, there is some new terminology to learn. Each of the terms below are components of a Master Data Services model. In brackets is the equivalent term in the data warehouse world:
Domain – subject area; ...
|
|
-
|
|
I have been working heavily with Microsoft Data Services (MDS) in SQL Server 2012 over the past few months, and really like the product. Through my use of it I have learned some tips and tricks that I will share on this blog over the next few months. My ...
|
|
-
|
|
The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based on data in a source table in one easy statement, replacing lots of messy code. I use it frequently when building a data warehouse.
In short, th...
|
|
-
|
|
With the preview of SharePoint 2013 now available, I have updated my post SQL Server 2012: Installing on a Virtual Machine to use SharePoint 2013 instead of SharePoint 2010. If you would like to get a head start on learning what is new with SharePoint 201...
|
|
-
|
|
On July 16, 2012, Office 2013 Preview was released to the public (download). Excel 2013 now includes a lot of the SQL Server BI components directly in the initial install, as well as enhancements made to the business intelligence (BI) capabilities in Exce...
|
|