SQLDBAWithABeard

SQLDBAWithABeard

SQLDBAWithABeard

<#
Nasty, horrible, dirty method of filling a database with duff data.

We used this for some data movement load testing into Azure

It uses Itziks method of creating a numbers table and then converts them into the right(ish)
datatype which it gets from the schema. 

Nothing more No PKs, no FKs, no constraints
All dates, datetimes etc are 1901-01-01 00:00:00

SQLDBAWithABeard

Param(
    $SqlInstance,
    $JobID
)

$webhookurl = ""
function Notify-TeamsSQlAgentJob {
    Param(
        $SQLInstance,
        $JobID,

SQLDBAWithABeard

SQLDBAWithABeard

	 "Table": {
	 	"prefix": "table",
	 	"body": [
			"| ${1:Heading1}   | ${2:Heading2} | ${3:Heading3} |",
			"|------------|----------------:|-----------------:|",
			"|  |        |          |"
	 	],
	 	"description": "Log output to console"
	 }

SQLDBAWithABeard

// This file was initially generated by Windows Terminal 1.0.1401.0
// It should still be usable in newer versions, but newer versions might have additional
// settings, help text, or changes that you will not see unless you clear this file
// and let us generate a new one for you.

// To view the default settings, hold "alt" while clicking on the "Settings" button.
// For documentation on these settings, see: https://aka.ms/terminal-documentation
{
    "$schema": "https://aka.ms/terminal-profiles-schema",

SQLDBAWithABeard

SQLDBAWithABeard

$TargetDatabase = "DBA"
$JobId =  "$(ESCAPE_SQUOTE(JOBID))"
$StartTime = "$(ESCAPE_SQUOTE(STRTTM))"
$StartDate = "$(ESCAPE_SQUOTE(STRTDT))"
$JSONTable = "select * from notebooks.nb_template where job_id = $JobId"
$sqlResult = Invoke-Sqlcmd -Query $JSONTable -Database $TargetDatabase -MaxCharLength 2147483647
$FirstNotebookError = ""
function ParseTableToNotebookOutput {
    param (
        [System.Data.DataTable]

SQLDBAWithABeard