Businesses today want actionable insights into their datathey want their data to reveal itself to them in a natural and userfriendly form. What could be more natural than human language? Naturallanguage search is at the center of a storm of everincreasing webdriven demand for humancomputer communication and information access. SQL Server 2008 provides the tools to take advantage of the features of its builtin enterpriselevel naturallanguage search engine in the form of integrated fulltext search (iFTS). iFTS uses textaware relational queries to provide your users with fast access to content. Whether you want to set up an enterprisewide Internet or intranet search engine or create less ambitious naturallanguage search applications, this book will teach you how to get the most out of SQL Server 2008 iFTS:

Introducing powerful iFTS features in SQL Server, such as the FREETEXT and CONTAINS predicates, custom thesauruses, and stop listsShowing you how to optimize fulltext query performance through features like fulltext indexes and iFiltersProviding examples that help you understand and apply the power of iFTS in your daily projects

Hilary Cotter has been involved in information technology for more than 19 years. He has worked as a web and database consultant specializing in search solutions, and he has helped several major sites tune their e-commerce sites. Hilary has answered over 6,000 questions on the Microsoft newsgroups and founded, with Chris Crowe, both IISFAQ.com, the world's largest resource for information on Internet Information Server, and IndexServerFAQ.com, which averages 1.2 million hits per month. In 2001, Microsoft recognized him with a Microsoft SQL Server "Most Valuable Professional" award. Hilary received his bachelor's of applied science degree in mechanical engineering from the University of Toronto. He subsequently studied economics at the University of Calgary and computer science at the University of California, Berkeley.

SQL Server Full-Text Search.- Administration.- Basic and Advanced Queries.- Client Applications.- Multilingual Searching.- Indexing BLOBs.- Stoplists.- Thesauruses.- iFTS Dynamic Management Views and Functions.- Filters.- Advanced Search Techniques.