Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
ALTER PROCEDURE [dbo].[getMatchingArticles] @region varchar(50), @terms varchar(100) AS BEGIN SELECT TOP 80 article_ID, f.WeightedRank, article_title, article_tags, article_description, article_link, article_image, source_ID, source_title, source_url, article_posted, article_image FROM table_articles INNER JOIN ( SELECT [KEY], SUM(Rank) AS WeightedRank FROM ( SELECT Rank * 5.0 as Rank, [KEY] from FREETEXTTABLE(table_articles, article_title, @terms) UNION select Rank * 3.0 as Rank, [KEY] from FREETEXTTABLE(table_articles, article_tags, @terms) UNION select Rank * 1.0 as Rank, [KEY] from FREETEXTTABLE(table_articles, article_description, @terms) ) as x GROUP BY [KEY] ) as f ON article_ID = f.[KEY] JOIN table_sources ON article_listing = source_ID AND source_c = 1 AND source_approved = 1 WHERE article_region = @region AND article_posted > GetDate() - 60 ORDER BY f.WeightedRank DESC END