Skip to content

Instantly share code, notes, and snippets.

@janhebnes
janhebnes / gist:3946630
Created October 24, 2012 15:06
Sitecore CMS - SQL for Removing Non Image Blobs from a Sitecore Database Blob table
-- Large blob data in test/uat environments is just wastefull use of disk space
SP_SPACEUSED [Blobs]
-- FINDING ItemIds FOR RELEVANT FIELDS
-- File > Information > Extension Field
select * from Items where ID like 'C06867FE-9A43-4C7D-B739-48780492D06F'
-- File > Media > Blob Field
select * from Items where ID like '40E50ED9-BA07-4702-992E-A912738D32DC'
-- Examining the data location of the fields
@JRondeau16
JRondeau16 / EmailAdministrator.cs
Last active October 8, 2015 13:09
Custom Workflow Email Action
using System.Net.Mail;
using Sitecore.Data.Items;
using Sitecore.Diagnostics;
using Sitecore.Workflows.Simple;
using Sitecore.Links;
namespace YOURPROJECTNAMESPACE
{
public class EmailAdmin
{