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

SQLDBAWithABeard

SQLDBAWithABeard

SQLDBAWithABeard