michaellwest

-- https://www.sqlshack.com/how-to-identify-and-resolve-sql-server-index-fragmentation/
SELECT S.name as 'Schema',
T.name as 'Table',
I.name as 'Index',
DDIPS.avg_fragmentation_in_percent,
DDIPS.page_count
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS DDIPS
INNER JOIN sys.tables T on T.object_id = DDIPS.object_id
INNER JOIN sys.schemas S on T.schema_id = S.schema_id
INNER JOIN sys.indexes I ON I.object_id = DDIPS.object_id

michaellwest

$matchedItems = [System.Collections.ArrayList]@()

$revisionFilter = @("9323dec0-9b37-4fae-b87c-2dc12cbea0f2")
Get-ChildItem -Path "master:\media library" -Recurse | 
    Where-Object { [string]::IsNullOrEmpty($PSItem["__revision"]) -or  $revisionFilter -contains $PSItem["__revision"] } |
    ForEach-Object { $matchedItems.Add([PSCustomObject]@{"ItemId"=$PSItem.ID; "RevisionId"=$PSItem["__revision"]; "ItemPath"=$PSItem.ItemPath}) > $null }

$matchedItems | Show-ListView

michaellwest

stages:
    - build:dotnet

default:
  image:
    name: gcr.io/kaniko-project/executor:debug
    entrypoint: [""]

.job_template: 
  script: &script_definition

michaellwest

<script src=https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js></script>
<script>
jQuery(function() {
	function applyStyles() {
		jQuery(".ms-listviewtable tbody tr td:nth-child(3):contains('Required')").parent().css('background-color','red');
		jQuery(".ms-listviewtable tbody tr td:nth-child(3):contains('Conditionally Required')").parent().css('background-color','blue');
		jQuery(".ms-listviewtable tbody tr td:nth-child(3):contains('Additional Services')").parent().css('background-color','yellow');
	        jQuery(".ms-listviewtable tbody[id*='titl'] > tr > td > span").remove()
	}
	applyStyles();

michaellwest

$ips = @(
"19.143.116.98"
"19.143.116.98"
"19.143.116.98"
"19.143.116.98"
"19.143.116.98"
"19.143.116.98"
"19.143.116.98"
"19.143.116.98"
"15.37.53.228"

michaellwest

$levelFrom = 1
$levelTo = 4
$navigationFilterId = "{D063E9D1-C7B5-4B1E-B31E-69886C9C59F5}" # Main Navigation
#$navigationFilterId = "{6594C7CB-9588-47F6-B1E3-03783C9EAA79}" # Mobile Navigation
$navigationFilterFieldId = "{1FBC6A49-6281-48EE-87E9-A3970B145ADB}"
$navigableTemplateId = "{371D5FBB-5498-4D94-AB2B-E3B70EEBE78C}"
$counter = 0
$startItem = Get-Item -Path "master:" -ID "{961563FC-3445-4558-BF3A-06DF06BA6298}"
function Walk-ItemTree {
    param(

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)

michaellwest

#$provider = [Sitecore.DependencyInjection.ServiceLocator]::ServiceProvider.GetService([Sitecore.XA.Foundation.Abstractions.Configuration.IConfiguration[Sitecore.XA.Foundation.Search.SearchConfiguration]]).GetConfiguration().QueryMaxItems

$query = "+template:{51ed5851-1a61-4dae-b803-6c7fae6b43d8};+sxa:SameFirstTagAsCurrentPage|SxaTags;custom:EventStartDate|[NOW TO *];custom:EventEndDate|[NOW TO *];sort:eventstartdate;sort:isfeatured[desc]"
$modelList = [Sitecore.ContentSearch.Utilities.SearchStringModel]::ParseDatasourceString($query)
$contextItem = Get-Item -Path "master:" -ID "{31318AEE-310B-4EE4-84DA-4B84471E0FCA}"
[Sitecore.DependencyInjection.ServiceLocator]::ServiceProvider.GetService([Sitecore.XA.Foundation.Search.Services.ISearchQueryTokenResolver]).Resolve($modelList, $contextItem)

class CustomSearchResultItem : SearchResultItem
{
   [Sitecore.ContentSearch.IndexField("eventstartdate_tdt")]

michaellwest

$sql = @"
SELECT DISTINCT i.* FROM [dbo].[Items] i
INNER JOIN [dbo].[VersionedFields] v
    ON i.ID = v.ItemId
WHERE v.[Language] = ''
--SELECT COUNT(*) AS COUNT FROM [VersionedFields] WHERE [Language] = ''

--DELETE FROM [VersionedFields] WHERE [Language] = ''
"@

michaellwest

# This is a ScopeQuery item found in SXA. You don't have to use this.
$scopeItem = Get-Item -Path "master:" -ID "{648F4C3A-C9EA-4FCF-82A3-39ED2AC90A06}"
# If not using SXA, you can replace this with the string from the QueryBuilder field type.
$scopeQuery = $scopeItem.ScopeQuery
$props = @{
    Index = "sitecore_sxa_master_index"
    ScopeQuery = $scopeQuery
}

$referenceList = Find-Item @props