sdurandeu

ARM Templates Samples

Azure App Service

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

Hendy

-- 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