michaellwest

 -- Find field data not associated with an item.
 SELECT Id  FROM SharedFields f
 WHERE NOT EXISTS (SELECT ID FROM Items i WHERE i.ID = f.ItemId) 
 SELECT Id  FROM UnversionedFields f
 WHERE NOT EXISTS (SELECT ID FROM Items i WHERE i.ID = f.ItemId) 
 SELECT Id  FROM VersionedFields f
 WHERE NOT EXISTS (SELECT ID FROM Items i WHERE i.ID = f.ItemId)

bplasmeijer

Sitecore on Kubernetes

Start

• https://azure.microsoft.com/en-us/overview/what-is-a-container

• https://azure.microsoft.com/en-us/topic/what-is-kubernetes

• https://azure.microsoft.com/en-us/resources/kubernetes-learning-and-training

• https://www.sitecore.com/knowledge-center/getting-started/should-my-team-adopt-docker

Containers

vtml

Set-ExecutionPolicy RemoteSigned -Force; Set-ExecutionPolicy Unrestricted -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))
choco install dotnetcore -y
choco install dotnetcore-sdk -y
choco install webdeploy -y
choco install dotnetfx -y
choco install netfx-4.8 -y
choco install powershell-core -y
choco install azure-cli -y
choco install git -y
choco install sourcetree -y

michaellwest

Import-Function -Name Invoke-SqlCommand

$connection = [Sitecore.Configuration.Settings]::GetConnectionString("master")

$query = @"
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_ActivationLock]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_Data_Params_FieldIds]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_Data_Params_Languages]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_JobManifest]
DELETE FROM [Sitecore.Masterx].[dbo].[Publishing_JobMetadata]

MonrealRyan

1. sudo service solr stop

2. sudo rm -r /var/solr

3. sudo rm -r /opt/solr-5.3.1

4. sudo rm -r /opt/solr

5. sudo rm /etc/init.d/solr

michaellwest

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
  <sitecore>
    <powershell>
      <services>
        <remoting>
          <patch:attribute name="enabled">true</patch:attribute>
          <authorization>
            <add Permission="Allow" IdentityType="User" Identity="sitecore\admin" />
          </authorization>
        </remoting>

Jcardif

{
    "$help": "https://aka.ms/terminal-documentation",
    "$schema": "https://aka.ms/terminal-profiles-schema",
    "actions": 
    [
        {
            "command": 
            {
                "action": "copy",
                "singleLine": false

poojarsn

   public interface ICacheProvider
    {
        T Get<T>(string key, Func<T> fetch) where T : class;
        IEnumerable<T> GetAll<T>(IReadOnlyCollection<string> keys, Func<IEnumerable<T>> fetch, Func<T, string, string> keyGen, string keyPrefix) where T : class;
        void Clear(string key);
    }
    
    //Encryt and decrypt
    //Logging service
    //Key for different env same shared redis cache

georgechang

Git DMZ Flow

I've been asked a few times over the last few months to put together a full write-up of the Git workflow we use at RichRelevance (and at Precog before), since I have referenced it in passing quite a few times in tweets and in person. The workflow is appreciably different from GitFlow and its derivatives, and thus it brings with it a different set of tradeoffs and optimizations. To that end, it would probably be helpful to go over exactly what workflow benefits I find to be beneficial or even necessary.

• Two developers working on independent features must never be blocked by each other
  • No code freeze! Ever! For any reason!
• A developer must be able to base derivative work on another developer's work, without waiting for any third party
• Two developers working on inter-dependent features (or even the same feature) must be able to do so without interference from (or interfering with) any other parties
• Developers must be able to work on multiple features simultaneously, or at lea

EdCharbeneau

using Microsoft.AspNetCore.Components;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Reflection;
using System.Text.RegularExpressions;
public static class ExampleMetadata
{
    public static IEnumerable<MenuItem> GetItems()