Douglas Couto dcouto

dcouto / PS Disable Scripts Security

Created August 16, 2021 19:40

powershell -ExecutionPolicy Bypass -File .\script.ps1

dcouto / Sitecore-Quick-Delete.ps1

Created April 12, 2021 15:09

	New-UsingBlock (New-Object Sitecore.Data.BulkUpdateContext) {
	Get-Item -Path master: -Query "/sitecore/content/My Site/*[@@name != 'Item Name']" \| Remove-Item -Recurse -Permanently
	}

dcouto / Unlock_Sitecore_Admin_User.sql

Created October 25, 2018 18:14

	USE [database_name]
	GO

	UPDATE [dbo].[aspnet_Membership]
	SET [IsLockedOut] = 0

	WHERE UserId = 'B09BBCDE-9B3C-4DCD-B69E-67F615CE01E9'
	GO

dcouto / Coveo.IsPublishableInboundFilter.config

Last active November 1, 2018 19:00

	<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/">
	<sitecore>
	<pipelines>
	<coveoInboundFilterPipeline>
	<processor type="MySolution.Coveo.Custom.InboundFilters.IsPublishableInboundFilter, MySolution.Coveo.Custom" />
	</coveoInboundFilterPipeline>
	</pipelines>
	</sitecore>
	</configuration>

dcouto / ChangeTemplate.ps1

Created August 21, 2018 15:05

	$master = [Sitecore.Configuration.Factory]::GetDatabase("master");

	$commonFolderTemplate = $master.Templates["Common/Folder"];

	$allItems = Get-ChildItem -Path '/sitecore/content/United States/Home/Test Pages' -Recurse

	ForEach ($item in $allItems) {
	if($item.TemplateName -match "Local Content Folder") {
	Write-Host $item.FullPath
	$item.ChangeTemplate($commonFolderTemplate)

dcouto / CreateSelfSignedCert.ps1

Created August 20, 2018 17:05

	# https://andrewwburns.com/2018/03/01/create-a-self-signed-certificate-for-development/

	New-SelfSignedCertificate -CertStoreLocation Cert:\LocalMachine\My -DnsName "mysite.local" -Friend
	lyName "mysite.local" -NotAfter $([datetime]::now.AddYears(5))

dcouto / SetItemsAsProtected.ps1

Created August 15, 2018 16:20

	$allItems = Get-ChildItem -Path '/sitecore/content/Default Datasources/Default Featured Data List' -Recurse

	ForEach ($item in $allItems) {
	# Write-Host $item.FullPath

	$item.Editing.BeginEdit()
	$item["__Read Only"] = "1"
	$item.Editing.EndEdit()
	}

dcouto / DeleteSitecore9Databases.sql

Created August 15, 2018 13:59

	EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_Core'
	GO
	USE [master]
	GO
	DROP DATABASE [prefix_Core]
	GO

	EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'prefix_EXM.Master'
	GO
	USE [master]

dcouto / UpdateLinksDatabaseReferences.ps1

Created August 6, 2018 13:21

	$items = Get-Item master: -Query "/sitecore//*"

	Write-Host $items.Length

	$items \| ForEach-Object {
	try {
	[Sitecore.Globals]::LinkDatabase.UpdateReferences($_)
	# [Sitecore.Globals]::LinkDatabase.UpdateItemVersionReferences($_)
	}
	catch {

dcouto / All databases and sizes.sql

Created May 21, 2018 16:43

	SELECT
	D.name,
	F.Name AS FileType,
	F.physical_name AS PhysicalFile,
	F.state_desc AS OnlineStatus,
	CAST((F.size*8)/1024 AS int) AS [FileSize (MB)]
	--CAST(F.size*8 AS VARCHAR(32)) as SizeInBytes
	FROM
	sys.master_files F
	INNER JOIN sys.databases D ON D.database_id = F.database_id