This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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%' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
D1.[name] AS database_name, S1.[name] as [owner_name] | |
, CASE | |
WHEN S1.[name] = N'sa' | |
THEN NULL | |
--ELSE 'ALTER AUTHORIZATION ON DATABASE::' + QUOTENAME(D1.[name]) + ' TO [sa] -- was ' + QUOTENAME(S1.[name]) | |
ELSE 'USE ' + QUOTENAME(D1.[name]) + '; EXEC sp_changedbowner ''sa'' -- was ' + QUOTENAME(S1.[name]) | |
END AS alter_command | |
FROM sys.databases AS D1 | |
LEFT |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
QUOTENAME(S1.[name]) AS [schema_name] | |
, QUOTENAME(O1.[name]) AS [table_name] | |
, QUOTENAME(C1.[name]) AS [constraint_name] | |
, N'FOREIGN_KEY_CONSTRAINT' AS [constraint_type] | |
, 'ALTER TABLE ' + QUOTENAME(S1.[name]) + '.' + QUOTENAME(O1.[name]) | |
+ ' WITH CHECK CHECK CONSTRAINT ' + QUOTENAME(C1.[name]) AS sql_stmt | |
FROM sys.foreign_keys AS C1 | |
JOIN sys.objects AS O1 ON C1.parent_object_id = O1.[object_id] | |
JOIN sys.schemas AS S1 ON O1.[schema_id] = S1.[schema_id] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
[name] AS database_name, page_verify_option_desc | |
, CASE | |
WHEN page_verify_option_desc = N'CHECKSUM' | |
THEN NULL | |
ELSE 'ALTER DATABASE [' + [name] + ']' | |
+ ' SET PAGE_VERIFY CHECKSUM;' | |
END AS alter_command | |
FROM sys.databases | |
WHERE [name] NOT IN ('master','model','msdb','tempdb') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
[name] AS database_name, target_recovery_time_in_seconds | |
, CASE | |
WHEN target_recovery_time_in_seconds = 60 | |
THEN NULL | |
ELSE 'ALTER DATABASE [' + [name] + ']' | |
+ ' SET TARGET_RECOVERY_TIME = 60 SECONDS;' | |
END AS alter_command | |
FROM sys.databases | |
WHERE [name] NOT IN ('master','model','msdb','tempdb') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT AG1.[name] AS ag_name | |
, AL1.dns_name AS ag_listener_dns_name | |
, AL1.[port] AS ag_listener_tcp_port | |
, AL2.ip_address AS ag_listener_ip_address | |
, AL2.ip_subnet_mask AS ag_listener_ip_subnet_mask | |
FROM sys.availability_groups AS AG1 | |
JOIN sys.availability_group_listeners AS AL1 | |
ON AG1.group_id = AL1.group_id | |
JOIN sys.availability_group_listener_ip_addresses AS AL2 | |
ON AL1.listener_id = AL2.listener_id |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Warning: remember to whitelist who you want to allow to post by entering their IP addresses in the Azure Portal | |
import-module Az; | |
$TenantID = 'YOURTENANTID'; | |
$SubscriptionID = 'YOURSUBID' | |
$ResourceGroupName = 'WebSite'; | |
$AppServiceName = 'YOURSERVICENAME'; | |
$MyIP = (Invoke-WebRequest -uri "http://ifconfig.me/ip").Content; #avoid self-banning | |
$MaxPostsBytes = 100KB; | |
# Authenticate to Azure if not already authenticated |
NewerOlder