Ole Morten Didriksen oledid

Windows: I want to run a command line script from task scheduler without opening a console window. How?

Task scheduler:

Also, set powershell execution policy first to be able to run powershell scripts

There are other ways to solve this, but this will let you "Run only when user is logged on".

May fix rare problems connecting to RDP

If you do not know your local account name run PowerShell or Command Prompt and run the command 'whoami'

Hold down the shift key, and right click on a shortcut of your choice. I used PowerShell, but Notepad or some other small application should work.

https://stackoverflow.com/questions/41139067/git-log-output-encoding-issues-on-windows-10-command-prompt

cmd -> set LC_ALL=C.UTF-8

pwsh -> $env:LC_ALL = "C.UTF-8"

Manage App Service Plan count and SKU

(Get-AzAppServicePlan -ResourceGroupName "<resource group name>" -Name "<app service plan name>").Sku.Capacity

	$myUrl = "https://my-url-with-invalid-cert"

	Function Get-SSLThumbprint {
	param(
	[Parameter(
	Position=0,
	Mandatory=$true,
	ValueFromPipeline=$true,
	ValueFromPipelineByPropertyName=$true)
	]

	rem Source: https://answers.microsoft.com/en-us/windows/forum/all/how-to-disable-windows-11-automatic-reboots/d7766f02-59a1-48f4-af6e-761345704ead?page=1
	rem Author: Michael 'The Curate'
	rem Howto:
	rem This script works by adjusting your 'Active hours'. You should schedule it to run every hour with the task scheduler.
	rem To not get an "annoying popup" when it gets run you need to be running it "whether user is logged in or not"
	rem You probably also need administrative privileges to edit the registry

	for /f %%i in ('powershell "((get-date).Hour+18) %% 24"') do set startHour=%%i
	for /f %%i in ('powershell "((get-date).Hour+12) %% 24"') do set endHour=%%i

	-- MS SQL, SQL Azure
	CREATE OR ALTER PROCEDURE CreateIndexesForForeignKeysWithMissingIndex
	AS
	BEGIN
	WITH FK_Indexes AS (
	SELECT
	fk.name AS ForeignKey,
	tp.name AS TableName,
	fk.parent_object_id AS TableObjectID,
	fkc.parent_column_id AS ColumnID,

	Windows Registry Editor Version 5.00

	; Please read https://stackoverflow.com/questions/10537610/how-do-i-add-the-description-property-to-the-table-designer-view-in-ssms
	; before running this file

	[HKEY_CURRENT_USER\Software\Microsoft\SQL Server Management Studio\19.0_IsoShell\DataProject]
	"SSVPropViewColumnsSQL70"="1,2,6,17;"
	"SSVPropViewColumnsSQL80"="1,2,6,17;"

	# Create a 2048-bit RSA Keypair in XML format
	#
	# @author Michael Johnson <michael.johnson@snap.md>
	# @copyright 2016 SnapMD, Inc.
	# @license https://opensource.org/licenses/BSD-2-Clause Simplified BSD License

	<#
	Copyright (c) 2016, SnapMD, Inc.
	All rights reserved.

	############################################################
	# Resubmit failed logic app runs
	############################################################

	# Sources:
	# https://github.com/Azure/logicapps/tree/master/scripts/resubmit-all-failed-runs
	# https://github.com/Azure/azure-powershell/issues/7752

	import-module Az