ghotz

/*Note This script creates two stored procedures in the master database. The procedures are named sp_hexadecimal and sp_help_revlogin. */
 -- Create stored procedure sp_hexadecimal
USE master
GO
IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL
  DROP PROCEDURE sp_hexadecimal
GO
CREATE PROCEDURE sp_hexadecimal
    @binvalue varbinary(256),
    @hexvalue varchar (514) OUTPUT

ghotz

$scanPSTExe = "C:\Program Files\Microsoft Office\root\Office16\SCANPST.EXE"
$SourceDir = "E:\Outlook\test"
$BackupDir = "F:\Backups\Outlook\test"
$MaxIterations = 10

$PSTs = Get-ChildItem -Path (Join-Path $SourceDir "\*") -Include *.pst,*.ost -File

$PSTs | ForEach-Object {
    $NumIteration = 1

ghotz

DECLARE	@old_email_address nvarchar(128) = N'[email protected]';
DECLARE	@new_email_address nvarchar(128) = N'[email protected]';
DECLARE	@old_replyto_address nvarchar(128) = N'[email protected]';
DECLARE	@new_replyto_address nvarchar(128) = N'[email protected]';
DECLARE	@test_email_address nvarchar(128) = N'[email protected]';

USE msdb;
SET NOCOUNT ON;

IF OBJECT_ID('tempdb..#tmp_account') IS NOT NULL

ghotz

SELECT
	FLOOR(transferred_size_bytes * 1. / NULLIF(database_size_bytes, 0) * 100) AS Perc
,	transfer_rate_bytes_per_second / 1024 / 1024. AS MBSec
,	internal_state_desc
,	start_time_utc, estimate_time_complete_utc
,	FLOOR(transferred_size_bytes / 1024. / 1024. / 1024.) AS transferred_size_GB
,	FLOOR(database_size_bytes / 1024. / 1024. / 1024.) AS database_size_bytes_GB
,	*
FROM sys.dm_hadr_physical_seeding_stats

ghotz

WITH cte AS
(
	SELECT
		CASE
		WHEN	PATINDEX('SQL Server (%', servicename) > 0
		THEN	'Engine'
		WHEN	PATINDEX('SQL Server Agent (%', servicename) > 0
		THEN	'Agent'
		WHEN	PATINDEX('SQL Full-text Filter Daemon Launcher (%', servicename) > 0
		THEN	'FullText'

ghotz

WITH cte AS
(
	SELECT
		RH.destination_database_name, RH.restore_type
	,	ROW_NUMBER() OVER (PARTITION BY RH.destination_database_name, RH.restore_type ORDER BY RH.restore_history_id DESC) AS rn
	,	RH.restore_date, BS.backup_start_date, BS.backup_finish_date
	,	CASE WHEN CONVERT(varchar, DATEDIFF(ms, backup_start_date, backup_finish_date) / 1000 / 86400) > 0 THEN CONVERT(varchar, DATEDIFF(ms, backup_start_date, backup_finish_date) / 1000 / 86400) + ' day(s) ' ELSE '' END + CONVERT(varchar, DATEADD(ms, DATEDIFF(ms, backup_start_date, backup_finish_date), 0), 114) AS elapsed_time
	,	FORMAT(BS.backup_size / 1073741824., 'N2') AS backup_size_gb
	,	FORMAT(BS.compressed_backup_size / 1073741824., 'N2') AS compressed_backup_size_gb
	FROM	msdb.dbo.restorehistory AS RH

ghotz

SELECT
	JO.[name] AS job_name, JO.[enabled]
,	JS.step_id, JS.step_name, JS.subsystem, JS.command
FROM	msdb.dbo.sysjobs AS JO
JOIN	msdb.dbo.sysjobsteps as JS
  ON	JO.job_id = JS.job_id
WHERE	JS.command like N'%something%'

ghotz

EXEC sp_msforeachdb 'USE [?];
SELECT
	DB_NAME()
,	S.[object_id], S.[stats_id]
,	FORMATMESSAGE(
		N''[%s].[%s]''
	,	OBJECT_SCHEMA_NAME(S.[object_id])
	,	OBJECT_NAME(S.[object_id])
	)AS object_full_name
,	QUOTENAME(S.[name]) AS stat_name

ghotz

# Windows Sandbox
Disable-WindowsOptionalFeature -FeatureName "Containers-DisposableClientVM" -Online -NoRestart

# WSL
Disable-WindowsOptionalFeature -FeatureName "VirtualMachinePlatform" -Online -NoRestart
Disable-WindowsOptionalFeature -FeatureName "Microsoft-Windows-Subsystem-Linux" -Online -NoRestart

# Hyper-V
Disable-WindowsOptionalFeature -FeatureName "Microsoft-Hyper-V-All" -Online -NoRestart

ghotz

SELECT
	J1.[name] AS job_name
,	C1.[name] AS category_name, S1.[name] as [owner_name]
,	CASE
	WHEN S1.[name] = N'sa' OR S1.[name] LIKE '##%'
	THEN NULL
	ELSE	'EXEC msdb..sp_update_job @job_name = ''' + J1.[name] + ''''
		+	', @owner_login_name = ''sa'' -- was ' + QUOTENAME(S1.[name])
	END	AS alter_command
FROM	msdb.dbo.sysjobs AS J1