Peter Vandivier petervandivier

Captured SMO queries against SQL Agent to try and figure out why tf I can read SQL Agent schedule data in RDS

This is a markdown file.

graph TD;
    A(with a mermaid diagram)-->B;
    A-->C;
    B-->D;
    C-->D(embedded inside);

	create or alter proc dbo.[BatchDelete<Table Name,,>]
	@BatchSize smallint = 1000,
	@RangeMax datetime = null,
	@RangeMin datetime = null,
	@DebugMode bit = 0
	as
	/***********************************************************************************************
	-- DESCRIPTION: batch delete `dbo.[<Table Name,,>]` records older than retention policy.
	-- Toggle @DebugMode for a summary of what would be deleted
	-- but take no action (other than parameter validation).


	function Get-AdxDashboardDefinition {
	param (
	[Parameter(Mandatory)]
	[string]
	$authorization,

	[Parameter(Mandatory)]
	[guid]
	$DashboardGuid

	-- Why does SQL Server Full Text Search (FTS) rank go down when match count goes up due to highly rare word
	-- https://dba.stackexchange.com/q/347554/68127
	use [master];
	go
	-- exec sp_WhoIsActive @show_system_spids = 1;

	drop database if exists fts;
	go

	create database fts;

	use [master]
	go
	drop database if exists TriggerDemo;
	go
	create database TriggerDemo;
	go
	use TriggerDemo
	go
	create table dbo.foo (
	id int not null primary key,

	/*
	https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/cdc-capture-instance-ct-transact-sql

	wanted to check that for ins/del ops (2 & 1 respectively) that the full update bitmask always applies

	it does:
	- 0x0f bitmask on 4 cols
	- 0x7f bitmask on 7 cols
	- 0xFF bitmask on 8 cols

	drop table if exists
	#row_comps,
	#main,
	#mid,
	#end;

	declare @indent varchar(50) = ' ';

	-- manually input table & column names below
	with cols as (

	#Requires -PSEdition Core

	# HT @santisq in powershell-slack
	# https://powershell.slack.com/archives/C1RCWRDL4/p1685120926413089

	function foo {
	param(
	[Parameter(Mandatory,ValueFromPipeline)]
	[string]
	$bar