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

Reference snippets for https://dba.stackexchange.com/q/347514/68127

This is a markdown file.

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

I'm attempting (and failing) to run a data-driven Pester v5 test over a PS Class. In the Tests/ directory are the 3 (currently failing) implemetations.

	-- 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


	function New-DateArray {
	<#
	.EXAMPLE
	$days = New-DateArray '2021-01-01' '2021-02-01'
	$days \| % { $_.ToShortDateString() }
	#>
	[CmdletBinding()]
	Param(
	[Parameter()]

	<xsd:schema xmlns:shp="http://schemas.microsoft.com/sqlserver/2004/07/showplan"
	xmlns:xsd="http://www.w3.org/2001/XMLSchema"
	targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/showplan" elementFormDefault="qualified"
	attributeFormDefault="unqualified" version="1.539" blockDefault="#all">
	<xsd:annotation>
	<xsd:documentation> The following schema for Microsoft SQL Server describes output from the showplan
	functionality in XML format. Microsoft does not make any representation or warranty regarding the schema or
	any product or item developed based on the schema. The schema is provided to you on an AS IS basis.
	Microsoft disclaims all express, implied and statutory warranties, including but not limited to the implied
	warranties of merchantability, fitness for a particular purpose, and freedom from infringement. Without