How to search the Microsoft SQL Full Text Search index

Published on Author JFLeave a comment

Use this query in SQL Management Studio to directly search the Full Text Search index. select * from sys.dm_fts_parser(‘”search term”‘, 1033, NULL, 0) Note that there are upcoming changes to FTI, including many deprecated functions, so if you’re using it extensively you probably have some work to do.

TLS 1.2 Support for MSSQL

Published on Author JFLeave a comment

Like many people, you’re still running Windows 2008 R2. You removed SSL and TLS 1.0 and other various security related connection configurations and protocols and you want to now install Microsoft SQL Server 2008 R2! Note: if you have not disabled these open wounds of Internet communication you should do so now! Note: there are… Continue reading TLS 1.2 Support for MSSQL