mikaelnet

public static class GuidUtils
{
	/// <summary>
	/// Creates a name-based UUID using the algorithm from RFC 4122 §4.3, using SHA1
	/// (version 5). This is useful for creating predictive Guid based on content.
	/// </summary>
	/// <param name="namespaceId">A known namespace to create the UUID within</param>
	/// <param name="name">The name (within the given namespace) to make the Guid from</param>
	/// <returns></returns>
	public static Guid Create(Guid namespaceId, string name)

mikaelnet

SELECT * FROM (
    SELECT ItemId, FieldId, Value FROM [SharedFields] (nolock)
    UNION
    SELECT ItemId, FieldId, Value FROM [UnversionedFields] (nolock)
    UNION
    SELECT ItemId, FieldId, Value FROM [VersionedFields] (nolock)
  ) A
WHERE Value Like '%' + CHAR(0x01) + '%'
OR Value Like '%' + CHAR(0x08) + '%'
OR Value Like '%' + CHAR(0x10) + '%'

mikaelnet

DECLARE @SharedFieldId UniqueIdentifier = '{BE351A73-FCB0-4213-93FA-C302D8AB4F51}' /* Shared checkbox */
DECLARE @UnversionedFieldId UniqueIdentifier = '{39847666-389D-409B-95BD-F2016F11EED5}' /* unversioned checkbox */
DECLARE @TemplateFieldId UniqueIdentifier = '{455A3E98-A627-4B40-8035-E683A0331AC7}' /* Template field */

-- Find all templates WHERE both "Unversioned" AND "Shared" is selected:
-- "Shared" will have precedense, so the "Unversioned" checkbox can be removed
SELECT * FROM SharedFields 
	WHERE FieldId=@UnversionedFieldId AND [Value] = '1'
	AND ItemId IN (SELECT ItemId FROM SharedFields WHERE FieldId=@SharedFieldId AND [Value]='1')

mikaelnet

using System;
using System.Collections.Generic;
using System.Linq;
using Sitecore;
using Sitecore.Collections;
using Sitecore.ContentSearch;
using Sitecore.Data;
using Sitecore.Data.Items;
using Sitecore.Diagnostics;

mikaelnet

<#
	.SYNOPSIS
		Lists the items with broken links searching all or the latest version in the current language.

		This is an update of the original Broken Links report created by the authors of SPE:
		https://github.com/SitecorePowerShell/Console
		This versions has the following changes
		* Ability to ignore checking broken links in the renderings field. (Makes sense in come clone scenarios)
		* Supports checking external links of field type "General Link with Search"
		* Supports checking external protocol independent links (URL's starting with //)

mikaelnet

using System.Management.Automation;
using Sitecore.Data.Items;

[OutputType(typeof(Item)), Cmdlet("Touch", "Item")]
public class TouchItem : Cmdlet
{
	[Parameter(ValueFromPipeline = true, ValueFromPipelineByPropertyName = true)]
	public Item Item { get; set; }

	protected override void ProcessRecord()

mikaelnet

DECLARE @SearchStr nvarchar (100)
SET @SearchStr = 'string to find'

CREATE TABLE #Results ( ColumnName nvarchar( 370), ColumnValue nvarchar(3630 ))
SET NOCOUNT ON

DECLARE @TableName nvarchar (256), @ColumnName nvarchar( 128), @SearchStr2 nvarchar(110 )
SET  @TableName = ''
SET @SearchStr2 = QUOTENAME( '%' + @SearchStr + '%','''' )

mikaelnet

select 'Database Name: ', db_name()
set nocount on
if exists(select name from tempdb..sysobjects where name='##tmp') drop table ##tmp
create table ##tmp(nam varchar(50), rows int, res varchar(15),data varchar(15),ind_sze varchar(15),unsed varchar(15))
go
declare @tblname varchar(50)
declare tblname CURSOR for select name from sysobjects where xtype='U'
open tblname
Fetch next from tblname into @tblname
WHILE @@FETCH_STATUS = 0

mikaelnet

function Update-MediaItem {
    [CmdletBinding()]
    param(
        [Parameter(Position=0, Mandatory=$true, ValueFromPipeline=$true)]
        [ValidateNotNullOrEmpty()]
        [string]$filePath,

        [Parameter(Position=1, Mandatory=$true)]
        [ValidateNotNullOrEmpty()]
        [string]$mediaPath)

mikaelnet

    public static class LevenshteinDistanceComputer
    {
        public static int LevenshteinDistance(this string s, string t)
        {
            return Compute(s, t);
        }

        public static int Compute(string s, string t)
        {
            if (string.IsNullOrEmpty(s))