Skip to content

Instantly share code, notes, and snippets.

View Philo's full-sized avatar

Phil Oyston Philo

  • Lenus Health
  • Edinburgh
View GitHub Profile
@Hendy
Hendy / DeleteAllVersions.sql
Last active October 28, 2020 10:10
Umbraco - delete version history for all content
-- 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
@sdurandeu
sdurandeu / arm-template.md
Last active December 4, 2017 10:12
Azure ARM Template Samples

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