Phil Oyston Philo

ARM Templates Samples

Including how to:

Set Connection Strings
Set app settings with a Cosmos DB Accunt Key, the Azure Storage Key and App Insights Instrumentation Key
Output the Website Publishing Username and Password
AlwaysOn turned on

	-- Create a temporary table for all documents which are published and not in the recycle bin
	CREATE TABLE #Nodes (id int)
	-- Delete all rows if the table exists before
	TRUNCATE TABLE #Nodes

	-- Insert all nodeIds from all documents which are published and not in the recycle bin
	INSERT INTO #Nodes
	SELECT N.id
	FROM umbracoNode N
	INNER JOIN cmsDocument D ON N.ID = D.NodeId