My good friend Gianluca informed me that Microsoft created a new add-in for Excel 2010: Fuzzy Lookup. Fuzzy Lookup was developed by Microsoft Research and was first introduced in SSIS 2005. Now it is available in Excel 2010 as well. It is used for identity mapping and de-duplicating. For approximate string searches, it uses one of the most advanced algorithms currently available. I am already testing it, and works like expected, like SSIS variant: fantastic!
Independent Consultant at Dejan Sarka S.P.
I am a trainer and consultant that focus on development of database & business intelligence applications.
Besides projects, I spend about half of the time on training and mentoring. I am the founder of the Slovenian SQL Server and .NET Users Group. and the main author or coauthor of eleven books about databases and SQL Server. I also developed many courses and seminars for SolidQ.
Besides projects, I spend about half of the time on training and mentoring. I am the founder of the Slovenian SQL Server and .NET Users Group. and the main author or coauthor of eleven books about databases and SQL Server. I also developed many courses and seminars for SolidQ.
Latest posts by Dejan Sarka (see all)
- Python for SQL Server Specialists Part 4: Python and SQL Server - April 24, 2018
- Python for SQL Server Specialists Part 3: Graphs and Machine Learning - April 11, 2018
- Python for SQL Server Specialists Part 2: Working with Data - March 22, 2018
