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

SQLDBAWithABeard

CREATE EVENT SESSION [MonitorWindowsLogins] ON SERVER 
ADD EVENT sqlserver.login(
    ACTION(sqlserver.client_hostname,sqlserver.database_name,sqlserver.session_id,sqlserver.session_nt_username,sqlserver.session_server_principal_name)
    WHERE ([sqlserver].[not_equal_i_sql_unicode_string]([sqlserver].[session_nt_user],N'') 
    AND [sqlserver].[not_equal_i_sql_unicode_string]([sqlserver].[session_server_principal_name],N'THEBEARD\gsartori') 
    AND [sqlserver].[not_equal_i_sql_unicode_string]([sqlserver].[session_server_principal_name],N'THEBEARD\wdurkin') 
    AND [sqlserver].[not_equal_i_sql_unicode_string]([sqlserver].[session_server_principal_name],N'THEBEARD\Rob') 
    AND [sqlserver].[session_nt_user]<>N'THEBEARD\gfritchey' 
    AND [sqlserver].[session_server_principal_name]<>N'THEBEARD\SQL_SVC' 
    AND [sqlserver].[session_server_principal_name]<>N'THEBEARD\SQL2014SER12R2$'))

SQLDBAWithABeard

function Calm {
    for ($i = 0; $i -le 4; $i++) {
        $x = 1
        while ($x -le 4) {
            "In through the nose - $x"
            Start-Sleep -Seconds 1
            $x ++
        }
        $x = 1
        while ($x -le 7) {

SQLDBAWithABeard

SQLDBAWithABeard