Ambient Concepts SqlName is a set of Microsoft SQL Server user defined functions
that provide provide full name parsing and matching capabilities.
These SQL CLR functions are easy to use, provide high performance, and are ideal
for scenarios with high transactional throughput and large datasets.
Version 1.1 now includes support for alternate name formats and multi name
SqlName utilizes basic parsing logic and embedded reference data to achieve fast
and consistent results. Typical uses include contact searching, contact deduplication,
and name standardization.
SqlName includes support for first name abbreviations and alternate spellings. In
the example below, the acSimilarFirstNames function is used to locate a contact
record where all you know is that their first name was Cat (or Kat) and that their last
name started with "T".
For more details on the features provided by SqlName, see the
full online documentation.
SqlName has been heavily optimized for performance and provides various methods
for achieving the best conditions for your scenario. Tests have shown parsing speeds
up to 500k records per second on unindexed data with moderate hardware.
SqlName is supported on all editions of SQL Server starting with version 2005. SQL
Azure is not supported as it does not currently support custom SQL CLR objects.
The SqlName functions reside in a single assembly file that can execute under the
permission level of Safe and do not require any additional references or access
to external datasets.
Ambient Concepts SqlName is available as a deployable SQL CLR assembly that can
be used for royalty free distribution. The license covers use by your entire development
team. A separate license is available that includes full, documented source code
with the ability to add or customize features as needed.
A fully functional demo of Ambient Concepts SqlName is available via the link
below. To download, you will need to first register for a free AmbientConcepts.com
account if you do not already have one.
The demo version of SqlName is limited to use in the AdventureWorks sample database
only. A copy of this database can be retrieved from the Microsoft SQL Server Database
Product Samples site on CodePlex.
You are free to create your own tables in this database and import your own address
data for evaluation, but the overall database size must be less than 1GB. The demo
version also has a small initialization overhead in order to check that these conditions
are met. The full version of SQLName has neither of these limitations.
Download SqlName Demo