martinrayenglish

<#
    .SYNOPSIS
        Script targets a CSV file in the media library and creates simple redirect items for each data record
    
    .NOTES
        Martin English
#>

#Target csv file in media library
$media = "/sitecore/media library/import-data"

martinrayenglish

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:set="http://www.sitecore.net/xmlconfig/set/">
  <sitecore>
  <sc.variable name="environment" value="martin_dev_" />
    <contentSearch>
      <configuration>
        <indexes>
          <index id="sitecore_master_index" type="Sitecore.ContentSearch.Azure.CloudSearchProviderIndex, Sitecore.ContentSearch.Azure">
            <param desc="name" patch:instead="param[@desc='name']">$(environment)$(id)</param>
          </index>
          <index id="sitecore_web_index" type="Sitecore.ContentSearch.Azure.CloudSearchProviderIndex, Sitecore.ContentSearch.Azure">

martinrayenglish

using System;

using Sitecore.Analytics.Pipelines.UpdateMongoDriverSettings;
using Sitecore.Diagnostics;

namespace MySite.Foundation.SitecoreExtensions.Pipelines.UpdateMongoDriverSettings
{
    public class CustomMongoDriverSettings : UpdateMongoDriverSettingsProcessor
    {
        private readonly string _maxConnectionPoolSize;

martinrayenglish

<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
  <sitecore>
    <pipelines>
      <updateMongoDriverSettings>
        <processor type="MySite.Foundation.SitecoreExtensions.Pipelines.UpdateMongoDriverSettings.CustomMongoDriverSettings, MySite.Foundation.SitecoreExtensions">
          <param desc="maxConnectionPoolSize">150</param>
          <param desc="minConnectionPoolSize">20</param>
          <param desc="maxConnectionIdleTimeSeconds">1500</param>
          <param desc="maxConnectionLifeTimeSeconds">0</param>
        </processor>

martinrayenglish

private int FixBrokenLinksInDatabase(Database database, bool serializeItem)
    {
      Globals.LinkDatabase.Rebuild(database);
      ItemLink[] brokenLinks = Globals.LinkDatabase.GetBrokenLinks(database);
      ItemLink[] itemLinkArray = new BrokenLinksFilter().ExcludeSystemItemLinks(database, (IReadOnlyCollection<ItemLink>) brokenLinks);
      foreach (ItemLink itemLink in itemLinkArray)
      {
        Item sourceItem = itemLink.GetSourceItem();
        if (sourceItem != null)
        {

martinrayenglish

ALTER PROCEDURE [xdb_refdata].[DeleteDefinitions]
(
    @Keys [xdb_refdata].[DefinitionKeys] READONLY
)
WITH EXECUTE AS OWNER
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE 

martinrayenglish

<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:set="http://www.sitecore.net/xmlconfig/set/" xmlns:search="http://www.sitecore.net/xmlconfig/search/" xmlns:role="http://www.sitecore.net/xmlconfig/role/">
  <sitecore role:require="Standalone or ContentDelivery or ContentManagement" search:require="azure">
    <contentSearch>
      <indexConfigurations>
        <locationCloudIndexConfiguration ref="contentSearch/indexConfigurations/defaultCloudIndexConfiguration">
          <documentOptions type="Sitecore.ContentSearch.DocumentBuilderOptions, Sitecore.ContentSearch">
            <indexAllFields>false</indexAllFields>
            <include hint="list:AddIncludedTemplate">
              <locationTemplateId>{53720ED3-C9F1-494F-88D8-BF05609E79FB}</locationTemplateId>

martinrayenglish

<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:role="http://www.sitecore.net/xmlconfig/role/" xmlns:search="http://www.sitecore.net/xmlconfig/search/">
  <sitecore role:require="Standalone or ContentDelivery or ContentManagement" search:require="azure">
    <contentSearch>
      <configuration type="Sitecore.ContentSearch.ContentSearchConfiguration, Sitecore.ContentSearch">
        <indexes hint="list:AddIndex">
          <index id="test_locations_web_index" type="Sitecore.ContentSearch.Azure.CloudSearchProviderIndex, Sitecore.ContentSearch.Azure">
            <param desc="name">$(id)</param>
            <param desc="connectionStringName">cloud.search</param>
            <param desc="totalParallelServices">5</param>

martinrayenglish

{
	"info": {
		"_postman_id": "ac487bbf-4bc0-498c-9b16-034706b6fc19",
		"name": "Sitecore xDB",
		"schema": "https://schema.getpostman.com/json/collection/v2.1.0/collection.json"
	},
	"item": [
		{
			"name": "xDB Contacts Count",
			"request": {

martinrayenglish

using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading;
using System.Xml;

using Sitecore.Analytics.Model;
using Sitecore.Analytics.XConnect.DataAccess;
using Sitecore.Framework.Conditions;
using Sitecore.Xml;