Sometimes, when users enter a new member to an entity in Master Data Services (either using the Web frontend or MS Excel), they experience the following error:
Continue reading
#DWH #BI #Automotive
In my last article, I focused on Vehicle Identification Numbers (VINs), about their structure and how to verify them in a data warehouse setting. This article focuses on an implementation of a VIN Validator for Microsoft SQL Server. The validator implements all the checks discussed in the earlier article. The downloadable source code can be found at the end of this article.
Continue reading
When creating entities in Microsoft SQL Server Master Data Manager, it is not possible to set a member attribute to store only unique values.
Continue reading
In order to provide a full-text search index on Adobe PDF documents, there are several options available.
Continue reading
Ever wondered which file types are supported by Microsoft SQL Server 2012 full text search? This article gives a complete list.
Just a question. Does anybody need a SSRS client for Android?
Please leave a comment!
For Microsoft SQL Server Analysis Services, there is a neat Android client available on Google Play.
Continue reading
Reading a book on Microsoft SQL Server administration, I came upon a topic that I didn’t cared about so far, mainly because I’m usually not responsible for administrating the data warehouse.
Just found an interesting white paper from Microsoft on a reference configuration for high performance data warehousing using Microsoft SQL Server.
Continue reading
