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
Tag Archives: MSSQL
Vehicle Identification Number (VIN) Validator for #SQLServer
#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
Unique Leaf Member Attributes in #SQLServer #MDM
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
#Adobe PDF IFilter for #SQLServer Full Text Search (FTS)
In order to provide a full-text search index on Adobe PDF documents, there are several options available.
Continue reading
Supported File Formats for #SQLServer Full Text Search (IFilter)
Ever wondered which file types are supported by Microsoft SQL Server 2012 full text search? This article gives a complete list.
#SQLServer #SSRS Client for #Android
Just a question. Does anybody need a SSRS client for Android?
Please leave a comment!
#SSAS #Android Client #MSSQL
For Microsoft SQL Server Analysis Services, there is a neat Android client available on Google Play.
Continue reading
Defragmented Indexes in a #DWH on #MSSQL
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.
Fast Track Data Warehouse 3.0 Reference Guide
Just found an interesting white paper from Microsoft on a reference configuration for high performance data warehousing using Microsoft SQL Server.
Continue reading