Welcome to EMC Consulting Blogs

SQL Server 2008 is introducing some interesting querying and storage enhancements such as the introduction of spatial data and the FILESTREAM attribute on VARBINARY(MAX) columns and my thoughts have recently turned to what querying enhancements we are going to see in future versions. I was chatting to Rob Farley recently and we started to wonder ...

A few days ago I posted a blog entry discussing some experiences of using fuzzy matching in SSIS. In it I talked of a problem I was having resolving 50 different records with the word ''google'' in them down to a single record ''www.google.com''. Another problem I was having was that fuzzy matching doesn't allow much control over what ...

I have been doing some work with the Fuzzy Matching transformation and as anyone that has done any form of fuzzy logic before will know, it is far from being an exact science. Fuzzy logic for those that don't know can be defined in many ways:''The process of reaching conclusions based on information and facts that are not 100 percent certain.'' - ...