SQLDBAWithABeard

1..100 | ForEach-Object {
    $number = $Psitem
    switch (($number % 5) -eq 0 -and ($number % 3 -eq 0)) {
        $true { 'FizzBuzz' }
        Default {
            switch ($number % 3) {
                0 { 'Fizz' }
                Default {
                    switch ($number % 5) {
                        0 { 'Buzz' }

SQLDBAWithABeard

$shell = New-Object -com shell.application
$rb = $shell.Namespace(10)
$rb.Items() | Sort ModifyDate -Descending |   Select -first 10 | ft

SQLDBAWithABeard

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