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:
#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.
Posted in Data Warehousing, Databases |
Tagged Automotive, Download, Microsoft SQL Server, MSSQL, RegEx, Regular Expressions, User Defined Function, Validator, Vehicle Identification Number, VIN |
When creating entities in Microsoft SQL Server Master Data Manager, it is not possible to set a member attribute to store only unique values.
In order to provide a full-text search index on Adobe PDF documents, there are several options available.
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!
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.