Multi-level Taxonomy Facets in Azure Search

Azure Search schemas do not explicitly support multi-level taxonomy categories, but such a feature can be approximated by manipulating content prior to indexing and then applying some special handling to the results. Like my previous post, this post will use sample data from AdventureWorks. AdventureWorks has a simple two-level taxonomy with a parent-child relationship. For…


Modeling the AdventureWorks Inventory Database for Azure Search

Modeling structured database content into an efficient search index is rarely a straightforward exercise. Scheduling and change management aside, there exists the challenge of denormalizing source rows away from their table-joined state into search-friendly entities. This post will explore the AdventureWorks sample data, available online, to highlight common experiences in the transition from database to…


Important SharePoint 2013 Patching Script Changes

  Intro and Issue I want to get a quick update out to my subscribers that currently use the SharePoint 2013 patching script I created back in 2013.  The script itself is located here.  While the script has been highly successful for thousands of SharePoint Admin’s, Consultants, and others, the script will always report success…


PowerShell: Getting Link Counts per Host Domain

Let's consider this throwback Thursday. A couple of years ago, I posted this " PowerShell to Rebalance Crawl Store DBs in SP2013 ". As a side note, I mentioned the following PowerShell to leverage the CrawlLog object for viewing some Crawl Store level…(read more)


SharePoint 2013 Search: How clicks change relevancy and rank scoring

If you've ever looked at rank log or the ExplainRank.aspx page, you may have noticed that term frequency scoring is only a portion of the total rank score.  There are many other relevancy features which contribute to rank scoring.  Among them are "click events".  Click events measure the interaction, or lack of interaction, between a…