PSFirstResponderKit

0.0.4-Prerelease2

PSFirstResponderKit.psm1

Set-StrictMode -Version Latest

#Region Enumerations
enum BlitzFirstOutputResultSets {
    BlitzWho_Start;
    Findings;
    FileStats;
    PerfmonStats;
    WaitStats;
    BlitzCache;
    BlitzWho_End
}

enum BlitzProcedureCacheFilter {
    CPU
    Duration
    ExecCount
    Reads
}
#EndRegion

#Region Type Definitions
$TypeDefinition = @'
using System;
using System.Collections.Generic;
 
namespace FirstResponderKit
{
    public class Blitz
    {
        public string ServerInstance;
        public BlitzVersion BlitzVersion;
        public byte Priority;
        public string FindingsGroup;
        public string Finding;
        public string DatabaseName;
        public string URL;
        public string Details;
        public System.Xml.XmlDocument QueryPlan;
        public System.Xml.XmlDocument QueryPlanFiltered;
        public int CheckID;
 
        public Blitz(string ServerInstance)
        {
            this.ServerInstance = ServerInstance;
        }
    }
 
    public class BlitzAdvanced
    {
        public Blitz[] Blitz;
        public ProcedureCache[] ProcedureCache;
 
        public BlitzAdvanced(Blitz[] Blitz, ProcedureCache[] ProcedureCache)
        {
            this.Blitz = Blitz;
            this.ProcedureCache = ProcedureCache;
        }
    }
 
    public class BlitzCache
    {
        public int ID;
        public int Pass;
        public DateTimeOffset SampleTime;
        public Byte[] sql_handle;
        public int statement_start_offset;
        public int statement_end_offset;
        public Int64 plan_generation_num;
        public Byte[] plan_handle;
        public Int64 execution_count;
        public Int64 total_worker_time;
        public Int64 total_physical_reads;
        public Int64 total_logical_writes;
        public Int64 total_logical_reads;
        public Int64 total_clr_time;
        public Int64 total_elapsed_time;
        public DateTimeOffset creation_time;
        public Byte[] query_hash;
        public Byte[] query_plan_hash;
        public Byte Points;
    }
 
    public class BlitzFirst : BlitzFirstResult
    {
        public string ServerInstance;
        public BlitzVersion BlitzVersion;
 
        public BlitzFirst(string ServerInstance) : base()
        {
            this.ServerInstance = ServerInstance;
        }
    }
 
    public class BlitzFirstExpert
    {
        public string ServerInstance;
        public BlitzVersion BlitzVersion;
        public BlitzWho[] BlitzWho_Start;
        public BlitzFirstExpertResult[] BlitzFirst;
        public WaitStats[] WaitStats;
        public FileStats[] FileStats;
        public PerfmonStats[] PerfmonStats;
        public BlitzCache[] BlitzCache;
        public BlitzWho[] BlitzWho_End;
 
        public BlitzFirstExpert(string ServerInstance)
        {
            this.ServerInstance = ServerInstance;
        }
    }
 
    public class BlitzFirstExpertResult : BlitzFirstResult
    {
        public int? CheckID;
        public DateTimeOffset? StartTime;
        public string LoginName;
        public string NTUserName;
        public string OriginalLoginName;
        public string ProgramName;
        public string HostName;
        public int? DatabaseID;
        public string DatabaseName;
        public int? OpenTransactionCount;
        public byte[] PlanHandle;
        public byte[] SqlHandle;
        public int? StatementStartOffset;
        public int? StatementEndOffset;
        public Int64? Executions;
        public decimal? ExecutionsPercent;
        public Int64? Duration;
        public decimal? DurationPercent;
        public Int64? CPU;
        public decimal? CPUPercent;
        public Int64? Reads;
        public decimal? ReadsPercent;
        public DateTimeOffset? PlanCreationTime;
        public Int64? TotalExecutions;
        public decimal? TotalExecutionsPercent;
        public Int64? TotalDuration;
        public decimal? TotalDurationPercent;
        public Int64? TotalCPU;
        public decimal? TotalCPUPercent;
        public Int64? TotalReads;
        public decimal? TotalReadsPercent;
        public int? DetailsInt;
    }
 
    public class BlitzFirstResult
    {
        public byte Priority;
        public string FindingsGroup;
        public string Finding;
        public string URL;
        public string Details;
        public string HowToStopIt;
        public string QueryText;
        public System.Xml.XmlDocument QueryPlan;
    }
 
    public class BlitzFirstSchema
    {
        public string ServerInstance;
        public BlitzVersion BlitzVersion;
        public string FieldList;
 
        public BlitzFirstSchema(string ServerInstance)
        {
            this.ServerInstance = ServerInstance;
        }
    }
 
    public class BlitzFirstSinceStartup
    {
        public string ServerInstance;
        public BlitzVersion BlitzVersion;
        public WaitStatsSinceStartup[] WaitStats;
        public FileStats[] FileStats;
        public PerfmonStats[] PerfmonStats;
        public BlitzCache[] BlitzCache;
 
        public BlitzFirstSinceStartup(string ServerInstance)
        {
            this.ServerInstance = ServerInstance;
        }
    }
 
    public class BlitzFirstTop10
    {
        public string ServerInstance;
        public BlitzVersion BlitzVersion;
        public decimal HoursSample;
        public decimal ThreadTime;
        public string wait_type;
        public string wait_category;
        public decimal WaitTime;
        public decimal PerCorePerHour;
        public Int64 NumberOfWaits;
        public decimal AvgMsPerWait;
 
        public BlitzFirstTop10(string ServerInstance)
        {
            this.ServerInstance = ServerInstance;
        }
    }
 
    public class BlitzVersion
    {
        public string Version;
        public DateTime VersionDate;
 
        public BlitzVersion(string Version, DateTime VersionDate)
        {
            this.Version = Version;
            this.VersionDate = VersionDate;
        }
    }
 
    public class BlitzWho
    {
        public DateTime run_date;
        public string elapsed_time;
        public short session_id;
        public short blocking_session_id;
        public string database_name;
        public string query_text;
        public System.Xml.XmlDocument query_plan;
        public string live_query_plan;
        public string Cached_Parameter_Info;
        public double query_cost;
        public string status;
        public string wait_info;
        public string wait_resource;
        public string top_session_waits;
        public int open_transaction_count;
        public int is_implicit_transaction;
        public string nt_domain;
        public string host_name;
        public string login_name;
        public string nt_user_name;
        public string program_name;
    }
 
    public class FileStats
    {
        public string Pattern;
        public DateTimeOffset SampleTime;
        public int Sample;
        public string FileName;
        public string Drive;
        public Int64 NoReadsWrites;
        public decimal MBReadWritten;
        public int AvgStall;
        public string FilePhysicalName;
        public string DatabaseName;
        public Int64 StallRank;
    }
 
    public class PerfmonStats
    {
        public string Pattern;
        public string object_name;
        public string counter_name;
        public string instance_name;
        public DateTimeOffset FirstSampleTime;
        public Int64 FirstSampleValue;
        public DateTimeOffset LastSampleTime;
        public Int64 LastSampleValue;
        public Int64 ValueDelta;
        public decimal ValuePerSecond;
    }
 
    public class ProcedureCache
    {
        public int AvgCPU;
        public Int64 TotalCPU;
        public decimal PercentCPU;
        public int AvgDuration;
        public Int64 TotalDuration;
        public decimal PercentDuration;
        public int AvgReads;
        public Int64 TotalReads;
        public decimal PercentReads;
        public int execution_count;
        public decimal PercentExecutions;
        public decimal executions_per_minute;
        public DateTime plan_creation_time;
        public DateTime last_execution_time;
        public string text;
        public string text_filtered;
        public System.Xml.XmlDocument query_plan;
        public System.Xml.XmlDocument query_plan_filtered;
        public Byte[] sql_handle;
        public Byte[] query_hash;
        public Byte[] plan_handle;
        public Byte[] query_plan_hash;
    }
 
    public class WaitStats
    {
        public string Pattern;
        public DateTimeOffset SampleEnded;
        public int SecondsSample;
        public decimal TotalThreadTime;
        public string wait_type;
        public string wait_category;
        public decimal WaitTime;
        public decimal PerCorePerSecond;
        public decimal SignalWaitTime;
        public decimal PercentSignalWaits;
        public Int64 NumberOfWaits;
        public decimal AvgMsPerWait;
        public string URL;
    }
 
    public class WaitStatsSinceStartup
    {
        public string Pattern;
        public DateTimeOffset SampleEnded;
        public decimal HoursSample;
        public decimal ThreadTime;
        public string wait_type;
        public string wait_category;
        public decimal WaitTime;
        public decimal PerCorePerHour;
        public decimal SignalWaitTime;
        public decimal PercentSignalWaits;
        public Int64 NumberOfWaits;
        public decimal AvgMsPerWait;
        public string URL;
    }
}
'@

$ReferencedAssemblies = @(
    [System.Xml.XmlDocument].Assembly.Location
)

Add-Type -TypeDefinition $TypeDefinition -ReferencedAssemblies $ReferencedAssemblies

Remove-Variable -Name TypeDefinition
#EndRegion


function Invoke-Blitz {
    <#
    .EXTERNALHELP
    PSFirstResponderKit-help.xml
    #>

    [System.Diagnostics.DebuggerStepThrough()]

    [CmdletBinding(
        PositionalBinding = $false,
        SupportsShouldProcess = $true,
        ConfirmImpact = 'Low',
        DefaultParameterSetName = 'DatabaseName'
    )]

    [OutputType(
        [FirstResponderKit.Blitz],
        [FirstResponderKit.BlitzAdvanced],
        [FirstResponderKit.BlitzVersion],
        [System.Void]
    )]

    param (
        #Region Parameter ServerInstance
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Help'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Version'
        )]
        [ValidateLength(1, 128)]
        [Alias('SqlServer')]
        [string]$ServerInstance,
        #EndRegion

        #Region Parameter DatabaseName
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Help'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Version'
        )]
        [ValidateLength(1, 128)]
        [string]$DatabaseName,
        #EndRegion

        #Region Parameter SqlConnection
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Help'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Version'
        )]
        [Microsoft.Data.SqlClient.SqlConnection]$SqlConnection,
        #EndRegion

        #Region Parameter BlitzHelp
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Help'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Help'
        )]
        [switch]$BlitzHelp,
        #EndRegion

        #Region Parameter SkipCheckUserDatabaseObjects
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [switch]$SkipCheckUserDatabaseObjects,
        #EndRegion

        #Region Parameter CheckProcedureCache
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [switch]$CheckProcedureCache,
        #EndRegion

        #Region Parameter OutputProcedureCache
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [switch]$OutputProcedureCache,
        #EndRegion

        #Region Parameter CheckProcedureCacheFilter
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [BlitzProcedureCacheFilter]$CheckProcedureCacheFilter,
        #EndRegion

        #Region Parameter CheckServerInfo
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [switch]$CheckServerInfo,
        #EndRegion

        #Region Parameter SkipChecksServer
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$SkipChecksServer,
        #EndRegion

        #Region Parameter SkipChecksDatabase
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateLength(1, 128)]
        $SkipChecksDatabase,
        #EndRegion

        #Region Parameter SkipChecksSchema
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateLength(1, 128)]
        $SkipChecksSchema,
        #EndRegion

        #Region Parameter SkipChecksTable
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateLength(1, 128)]
        $SkipChecksTable,
        #EndRegion

        #Region Parameter IgnorePrioritiesBelow
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateRange(0, [int]::MaxValue)]
        [int]$IgnorePrioritiesBelow,
        #EndRegion

        #Region Parameter IgnorePrioritiesAbove
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateRange(0, [int]::MaxValue)]
        [int]$IgnorePrioritiesAbove,
        #EndRegion

        #Region Parameter VersionCheckMode
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Version'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Version'
        )]
        [switch]$VersionCheckMode,
        #EndRegion

        #Region Parameter OutputDatabaseName
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputDatabaseName,
        #EndRegion

        #Region Parameter OutputSchemaName
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputSchemaName,
        #EndRegion

        #Region Parameter OutputTableName
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputTableName,
        #EndRegion


<#
        @EmailRecipients VARCHAR(MAX) = NULL ,
        @EmailProfile sysname = NULL ,
#>


        #Region Parameter SummaryMode
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [switch]$SummaryMode,
        #EndRegion

        #Region Parameter BringThePain
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [switch]$BringThePain,
        #EndRegion

        #Region Parameter UsualDBOwner
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$UsualDBOwner,
        #EndRegion

        #Region Parameter BlockingChecks
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SkipChecks_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ProcedureCache'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SkipChecks_LogToTable'
        )]
        [switch]$BlockingChecks,
        #EndRegion

        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false
        )]
        [ValidateRange(0, 2)]
        [int]$BlitzDebugLevel
    )

    BEGIN {
        try {
            $DatabaseParameterSets = @(
                'DatabaseName',
                'DatabaseName_Help',
                'DatabaseName_LogToTable',
                'DatabaseName_ProcedureCache',
                'DatabaseName_SkipChecks',
                'DatabaseName_SkipChecks_LogToTable',
                'DatabaseName_Version'
            )

            if ($PSCmdlet.ParameterSetName -in $DatabaseParameterSets) {
                $SqlServerParameters = @{
                    'ServerInstance' = $ServerInstance
                    'DatabaseName' = $DatabaseName
                }

                $SqlConnection = Connect-SqlServerInstance @SqlServerParameters
            }

            if ($SqlConnection.DataSource -in @('.', '(local)')) {
                $SqlInstanceName = [Environment]::MachineName
            } else {
                $SqlInstanceName = $SqlConnection.DataSource
            }

            if ($BlitzHelp -or ($PSBoundParameters.ContainsKey('BlitzDebugLevel') -and $BlitzDebugLevel -gt 0)) {
                $SqlInfoMessageEventHandler = [Microsoft.Data.SqlClient.SqlInfoMessageEventHandler]{
                    param($SqlSender, $SqlEvent)

                    Write-Host $SqlEvent.Message
                }
            } else {
                $SqlInfoMessageEventHandler = [Microsoft.Data.SqlClient.SqlInfoMessageEventHandler]{
                    param($SqlSender, $SqlEvent)

                    Write-Verbose $SqlEvent.Message
                }
            }

            $SqlConnection.add_InfoMessage($SqlInfoMessageEventHandler)

            $SqlCommandText = '[dbo].[sp_Blitz]'
            $DataSetName = 'sp_Blitz'
            $DataTableName = 'sp_Blitz'
        }
        catch {
            throw $_
        }

        $CommonParameters = @(
            'Debug',
            'ErrorAction',
            'ErrorVariable',
            'InformationAction',
            'InformationVariable',
            'OutVariable',
            'OutBuffer',
            'PipelineVariable',
            'ProgressAction',
            'Verbose',
            'WarningAction',
            'WarningVariable',
            'WhatIf'
        )

        $ConvertFromDataRowScriptBlock = {
            param($DataRow, $ColumnNames, $Object)

            foreach ($ColumnName in $ColumnNames) {
                if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                    $Object.$ColumnName = $DataRow.$ColumnName
                }
            }

            $Object
        }
    }

    PROCESS {
        try {
            $SqlParameterList = [System.Collections.Generic.List[Microsoft.Data.SqlClient.SqlParameter]]::New()

            $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@Version", [System.Data.SqlDbType]::VarChar, 30)
            $SqlParameter.Direction = [System.Data.ParameterDirection]::Output

            $SqlParameterList.Add($SqlParameter)

            $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@VersionDate", [System.Data.SqlDbType]::DateTime)
            $SqlParameter.Direction = [System.Data.ParameterDirection]::Output

            $SqlParameterList.Add($SqlParameter)

            #Region Procedure Parameter Binding
            switch ($PSBoundParameters.Keys) {
                'BlitzDebugLevel' {
                    if ($BlitzDebugLevel) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@Debug", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = $BlitzDebugLevel

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'BlitzHelp' {
                    if ($BlitzHelp) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@Help", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'BlockingChecks' {
                    if ($BlockingChecks) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@SkipBlockingChecks", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 0

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'BringThePain' {
                    if ($BringThePain) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@BringThePain", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'CheckProcedureCache' {
                    if ($CheckProcedureCache) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@CheckProcedureCache", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'CheckProcedureCacheFilter' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@CheckProcedureCacheFilter", [System.Data.SqlDbType]::VarChar, 10)
                    $SqlParameter.Value = $CheckProcedureCacheFilter

                    $SqlParameterList.Add($SqlParameter)
                }
                'CheckServerInfo' {
                    if ($CheckServerInfo) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@CheckServerInfo", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'IgnorePrioritiesAbove' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@IgnorePrioritiesAbove", [System.Data.SqlDbType]::Int)
                    $SqlParameter.Value = $IgnorePrioritiesAbove

                    $SqlParameterList.Add($SqlParameter)
                }
                'IgnorePrioritiesBelow' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@IgnorePrioritiesBelow", [System.Data.SqlDbType]::Int)
                    $SqlParameter.Value = $IgnorePrioritiesBelow

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputDatabaseName' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputType", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = 'None'

                    $SqlParameterList.Add($SqlParameter)

                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputDatabaseName", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputDatabaseName

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputProcedureCache' {
                    if ($OutputProcedureCache) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputProcedureCache", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'OutputSchemaName' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputSchemaName", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputSchemaName

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputTableName' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputTableName", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputTableName

                    $SqlParameterList.Add($SqlParameter)
                }
                'SkipChecksDatabase' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@SkipChecksDatabase", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $SkipChecksDatabase

                    $SqlParameterList.Add($SqlParameter)
                }
                'SkipChecksSchema' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@SkipChecksSchema", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $SkipChecksSchema

                    $SqlParameterList.Add($SqlParameter)
                }
                'SkipChecksServer' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@SkipChecksServer", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $SkipChecksServer

                    $SqlParameterList.Add($SqlParameter)
                }
                'SkipChecksTable' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@SkipChecksTable", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $SkipChecksTable

                    $SqlParameterList.Add($SqlParameter)
                }
                'SkipCheckUserDatabaseObjects' {
                    if ($SummaryMode) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@CheckUserDatabaseObjects", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 0

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'SummaryMode' {
                    if ($SummaryMode) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@SummaryMode", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'UsualDBOwner' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@UsualDBOwner", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $UsualDBOwner

                    $SqlParameterList.Add($SqlParameter)
                }
                'VersionCheckMode' {
                    if ($VersionCheckMode) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@VersionCheckMode", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                Default {
                    $Parameter = $_

                    if ($Parameter -NotIn @('ServerInstance', 'DatabaseName', 'SqlConnection') -and $Parameter -NotIn $CommonParameters) {
                        throw [System.Management.Automation.ErrorRecord]::New(
                            [Exception]::New('Unknown parameter.'),
                            '1',
                            [System.Management.Automation.ErrorCategory]::InvalidType,
                            $Parameter
                        )
                    }
                }
            }
            #EndRegion

            $OutSqlParameterList = [System.Collections.Generic.List[Microsoft.Data.SqlClient.SqlParameter]]::New()

            $SqlClientDataSetParameters = @{
                'SqlConnection' = $SqlConnection
                'SqlCommandText' = $SqlCommandText
                'CommandType' = [System.Data.CommandType]::StoredProcedure
                'SqlParameter' = $SqlParameterList
                'OutSqlParameter' = $([ref]$OutSqlParameterList)
                'CommandTimeout' = 0
                'DataSetName' = $DataSetName
                'DataTableName' = $DataTableName
                'OutputAs' = 'DataSet'
            }

            if ($PSCmdlet.ShouldProcess($DataSetName, 'Get SQL dataset')) {
                $OutputDataset = Get-SqlClientDataSet @SqlClientDataSetParameters

                if ($PSCmdlet.ParameterSetName -in $DatabaseParameterSets) {
                    Disconnect-SqlServerInstance -SqlConnection $SqlConnection
                }
            }

            $BlitzVersion = [FirstResponderKit.BlitzVersion]::New($OutSqlParameterList.Where({$_.ParameterName -eq '@Version'}).Value, $OutSqlParameterList.Where({$_.ParameterName -eq '@VersionDate'}).Value)

            if ($OutputDataset.Tables.Count -gt 0) {
                $DataTableNumber = 0

                #Region Blitz Results
                if ($OutputProcedureCache) {
                    $FindingsList = [System.Collections.Generic.List[FirstResponderKit.Blitz]]::New()
                }

                $DataTable = $OutputDataset.Tables[$DataTableNumber]

                $ColumnNames = $DataTable.Columns.ColumnName

                foreach ($DataRow in $DataTable.Rows) {
                    $FindingsObject = [FirstResponderKit.Blitz]::New($SqlInstanceName)

                    $FindingsObject.BlitzVersion = $BlitzVersion

                    $FindingsObject = $ConvertFromDataRowScriptBlock.Invoke($DataRow, $ColumnNames, $FindingsObject)[0]

                    if ($OutputProcedureCache) {
                        $FindingsList.Add($FindingsObject)
                    } else {
                        $FindingsObject
                    }
                }

                $DataTableNumber++
                #EndRegion

                if ($OutputProcedureCache) {
                    #Region OutputProcedureCache
                    $ProcedureCacheList = [System.Collections.Generic.List[FirstResponderKit.ProcedureCache]]::New()

                    $DataTable = $OutputDataset.Tables[$DataTableNumber]

                    $ColumnNames = $DataTable.Columns.ColumnName

                    foreach ($DataRow in $DataTable.Rows) {
                        $ProcedureCacheObject = [FirstResponderKit.ProcedureCache]::New()

                        $ProcedureCacheObject = $ConvertFromDataRowScriptBlock.Invoke($DataRow, $ColumnNames, $ProcedureCacheObject)[0]

                        $ProcedureCacheList.Add($ProcedureCacheObject)
                    }
                    #EndRegion

                    $BlitzAdvancedObject = [FirstResponderKit.BlitzAdvanced]::New($FindingsList, $ProcedureCacheList)

                    $BlitzAdvancedObject
                }
            } else {
                if ($VersionCheckMode) {
                    $BlitzVersion
                }
            }

            if ($PSCmdlet.ParameterSetName -in $DatabaseParameterSets) {
                Disconnect-SqlServerInstance -SqlConnection $SqlConnection
            }
        }
        catch {
            throw $_
        }
        finally {
            if (Test-Path -Path variable:\SqlCommand) {
                $SqlCommand.Dispose()
            }

            if ($PSCmdlet.ParameterSetName -in $DatabaseParameterSets) {
                Disconnect-SqlServerInstance -SqlConnection $SqlConnection
            }
        }
    }

    END {
    }
}

function Invoke-BlitzFirst {
    <#
    .EXTERNALHELP
    PSFirstResponderKit-help.xml
    #>

    [System.Diagnostics.DebuggerStepThrough()]

    [CmdletBinding(
        PositionalBinding = $false,
        SupportsShouldProcess = $true,
        ConfirmImpact = 'Low',
        DefaultParameterSetName = 'DatabaseName'
    )]

    [OutputType(
        [FirstResponderKit.BlitzFirst],
        [FirstResponderKit.BlitzFirstExpert],
        [FirstResponderKit.BlitzFirstSinceStartup],
        [FirstResponderKit.BlitzFirstSchema],
        [FirstResponderKit.BlitzFirstTop10],
        [FirstResponderKit.BlitzVersion],
        [System.Void]
    )]

    param (
        #Region Parameter ServerInstance
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Help'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Schema'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SinceStartup'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Top10'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Version'
        )]
        [ValidateLength(1, 128)]
        [Alias('SqlServer')]
        [string]$ServerInstance,
        #EndRegion

        #Region Parameter DatabaseName
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Help'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Schema'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SinceStartup'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Top10'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Version'
        )]
        [ValidateLength(1, 128)]
        [string]$DatabaseName,
        #EndRegion

        #Region Parameter SqlConnection
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Help'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Schema'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SinceStartup'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Top10'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Version'
        )]
        [Microsoft.Data.SqlClient.SqlConnection]$SqlConnection,
        #EndRegion

        #Region Parameter BlitzFirstHelp
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Help'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Help'
        )]
        [switch]$BlitzFirstHelp,
        #EndRegion

        #Region Parameter BlitzFirstSchema
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Schema'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Schema'
        )]
        [switch]$BlitzFirstSchema,
        #EndRegion

        #Region Parameter BlitzFirstTop10
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Top10'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Top10'
        )]
        [switch]$BlitzFirstTop10,
        #EndRegion

        #Region Parameter VersionCheckMode
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_Version'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_Version'
        )]
        [switch]$VersionCheckMode,
        #EndRegion

        #Region Parameter SkipCheckServerInfo
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [switch]$SkipCheckServerInfo,
        #EndRegion

        #Region Parameter Seconds
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateRange(0, [int]::MaxValue)]
        [int]$Seconds = 5,
        #EndRegion

        #Region Parameter FileLatencyThresholdMS
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateRange(0, [int]::MaxValue)]
        [int]$FileLatencyThresholdMS = 100,
        #EndRegion

        #Region Parameter MemoryGrantThresholdPct
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateRange(0, 100)]
        [decimal]$MemoryGrantThresholdPct = 15.00,
        #EndRegion

        #Region Parameter ExpertMode
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [switch]$ExpertMode,
        #EndRegion

        #Region Parameter OutputResultSets
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [BlitzFirstOutputResultSets[]]$OutputResultSets = @('BlitzWho_Start', 'Findings', 'FileStats', 'PerfmonStats', 'WaitStats', 'BlitzCache', 'BlitzWho_End'),
        #EndRegion

        #Region Parameter SinceStartup
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SinceStartup'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SinceStartup'
        )]
        [switch]$SinceStartup,
        #EndRegion

        #Region Parameter AsOf
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_AsOf'
        )]
        [System.DateTimeOffset]$AsOf,
        #EndRegion

        #Region Parameter OutputDatabaseName
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputDatabaseName,
        #EndRegion

        #Region Parameter OutputSchemaName
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputSchemaName,
        #EndRegion

        #Region Parameter OutputTableName
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_AsOf'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputTableName,
        #EndRegion

        #Region Parameter OutputTableNameFileStats
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputTableNameFileStats,
        #Endregion

        #Region Parameter OutputTableNamePerfmonStats
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputTableNamePerfmonStats,
        #EndRegion

        #Region Parameter OutputTableNameWaitStats
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputTableNameWaitStats,
        #EndRegion

        #Region Parameter OutputTableNameBlitzCache
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputTableNameBlitzCache,
        #EndRegion

        #Region Parameter OutputTableNameBlitzWho
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateLength(1, 128)]
        [string]$OutputTableNameBlitzWho,
        #EndRegion

        #Region Parameter OutputTableRetentionDays
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [ValidateRange(0, 255)]
        [int]$OutputTableRetentionDays = 7,
        #EndRegion

        #Region Parameter LogMessage
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [string]$LogMessage,
        #EndRegion

        #Region Parameter LogMessageCheckID
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [ValidateRange(0, [int]::MaxValue)]
        [int]$LogMessageCheckID = 38,
        #EndRegion

        #Region Parameter LogMessagePriority
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [ValidateRange(0, 255)]
        [int]$LogMessagePriority = 1,
        #EndRegion

        #Region Parameter LogMessageFindingsGroup
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [string]$LogMessageFindingsGroup = 'Logged Message',
        #EndRegion

        #Region Parameter LogMessageFinding
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [string]$LogMessageFinding = 'Logged from sp_BlitzFirst',
        #EndRegion

        #Region Parameter LogMessageURL
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $true,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [string]$LogMessageURL,
        #EndRegion

        #Region Parameter LogMessageCheckDate
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogMessage'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogMessage'
        )]
        [System.DateTimeOffset]$LogMessageCheckDate = $(Get-Date),
        #EndRegion

        #Region Parameter CheckProcedureCache
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SinceStartup'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SinceStartup'
        )]
        [switch]$CheckProcedureCache,
        #EndRegion

        #Region Parameter BlitzCacheAnalysis
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SinceStartup'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SinceStartup'
        )]
        [switch]$BlitzCacheAnalysis,
        #EndRegion

        #Region Parameter FilterPlansByDatabase
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_SinceStartup'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_SinceStartup'
        )]
        [string[]]$FilterPlansByDatabase,
        #EndRegion

        #Region Parameter ShowSleepingSPIDs
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'DatabaseName_LogToTable'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_ExpertMode'
        )]
        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false,
            ParameterSetName = 'SqlConnection_LogToTable'
        )]
        [switch]$ShowSleepingSPIDs,
        #EndRegion

        [Parameter(
            Mandatory = $false,
            ValueFromPipeline = $false,
            ValueFromPipelineByPropertyName = $false
        )]
        [switch]$BlitzFirstDebug
    )

    BEGIN {
        try {
            $DatabaseParameterSets = @(
                'DatabaseName',
                'DatabaseName_AsOf',
                'DatabaseName_ExpertMode',
                'DatabaseName_Help',
                'DatabaseName_LogMessage',
                'DatabaseName_LogToTable',
                'DatabaseName_Schema',
                'DatabaseName_SinceStartup',
                'DatabaseName_Top10',
                'DatabaseName_Version',
                'WhatIf'
            )

            if ($PSCmdlet.ParameterSetName -in $DatabaseParameterSets) {
                $SqlServerParameters = @{
                    'ServerInstance' = $ServerInstance
                    'DatabaseName' = $DatabaseName
                }

                $SqlConnection = Connect-SqlServerInstance @SqlServerParameters
            }

            if ($SqlConnection.DataSource -in @('.', '(local)')) {
                $SqlInstanceName = [Environment]::MachineName
            } else {
                $SqlInstanceName = $SqlConnection.DataSource
            }

            if ($BlitzFirstHelp -or $BlitzFirstDebug) {
                $SqlInfoMessageEventHandler = [Microsoft.Data.SqlClient.SqlInfoMessageEventHandler]{
                    param($SqlSender, $SqlEvent)

                    Write-Host $SqlEvent.Message
                }
            } else {
                $SqlInfoMessageEventHandler = [Microsoft.Data.SqlClient.SqlInfoMessageEventHandler]{
                    param($SqlSender, $SqlEvent)

                    Write-Verbose $SqlEvent.Message
                }
            }

            $SqlConnection.add_InfoMessage($SqlInfoMessageEventHandler)

            $SqlCommandText = '[dbo].[sp_BlitzFirst]'
            $DataSetName = 'sp_BlitzFirst'
            $DataTableName = 'sp_BlitzFirst'
        }
        catch {
            throw $_
        }

        $CommonParameters = @(
            'Debug',
            'ErrorAction',
            'ErrorVariable',
            'InformationAction',
            'InformationVariable',
            'OutVariable',
            'OutBuffer',
            'PipelineVariable',
            'ProgressAction',
            'Verbose',
            'WarningAction',
            'WarningVariable'
        )

        $ConvertFromDataRowScriptBlock = {
            param($DataRow, $ColumnNames, $Object)

            foreach ($ColumnName in $ColumnNames) {
                if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                    $Object.$ColumnName = $DataRow.$ColumnName
                }
            }

            $Object
        }
    }

    PROCESS {
        try {
            $SqlParameterList = [System.Collections.Generic.List[Microsoft.Data.SqlClient.SqlParameter]]::New()

            $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@Version", [System.Data.SqlDbType]::VarChar, 30)
            $SqlParameter.Direction = [System.Data.ParameterDirection]::Output

            $SqlParameterList.Add($SqlParameter)

            $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@VersionDate", [System.Data.SqlDbType]::DateTime)
            $SqlParameter.Direction = [System.Data.ParameterDirection]::Output

            $SqlParameterList.Add($SqlParameter)

            #Region Procedure Parameter Binding
            switch ($PSBoundParameters.Keys) {
                'AsOf' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@AsOf", [System.Data.SqlDbType]::DateTime)
                    $SqlParameter.Value = $AsOf

                    $SqlParameterList.Add($SqlParameter)
                }
                'BlitzCacheAnalysis' {
                    if ($BlitzCacheAnalysis) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@BlitzCacheSkipAnalysis", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 0

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'BlitzFirstDebug' {
                    if ($BlitzFirstDebug) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@Debug", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'BlitzFirstHelp' {
                    if ($BlitzFirstHelp) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@Help", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'BlitzFirstSchema' {
                    if ($BlitzFirstSchema) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputType", [System.Data.SqlDbType]::VarChar, 20)
                        $SqlParameter.Value = 'Schema'

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'BlitzFirstTop10' {
                    if ($BlitzFirstTop10) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputType", [System.Data.SqlDbType]::VarChar, 20)
                        $SqlParameter.Value = 'Top10'

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'CheckProcedureCache' {
                    if ($CheckProcedureCache) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@CheckProcedureCache", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'ExpertMode' {
                    if ($ExpertMode) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@ExpertMode", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'FileLatencyThresholdMS' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@FileLatencyThresholdMS", [System.Data.SqlDbType]::Int)
                    $SqlParameter.Value = $FileLatencyThresholdMS

                    $SqlParameterList.Add($SqlParameter)
                }
                'FilterPlansByDatabase' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@FilterPlansByDatabase", [System.Data.SqlDbType]::NVarChar)
                    $SqlParameter.Value = [string]::Join(',', $FilterPlansByDatabase)

                    $SqlParameterList.Add($SqlParameter)
                }
                'LogMessage' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@LogMessage", [System.Data.SqlDbType]::NVarChar, 4000)
                    $SqlParameter.Value = $LogMessage

                    $SqlParameterList.Add($SqlParameter)
                }
                'LogMessageCheckDate' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@LogMessageCheckDate", [System.Data.SqlDbType]::DateTimeOffset)
                    $SqlParameter.Value = $LogMessageCheckDate

                    $SqlParameterList.Add($SqlParameter)
                }
                'LogMessageCheckID' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@LogMessageCheckID", [System.Data.SqlDbType]::Int)
                    $SqlParameter.Value = $LogMessageCheckID

                    $SqlParameterList.Add($SqlParameter)
                }
                'LogMessageFinding' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@LogMessageFinding", [System.Data.SqlDbType]::VarChar, 200)
                    $SqlParameter.Value = $LogMessageFinding

                    $SqlParameterList.Add($SqlParameter)
                }
                'LogMessageFindingsGroup' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@LogMessageFindingsGroup", [System.Data.SqlDbType]::VarChar, 50)
                    $SqlParameter.Value = $LogMessageFindingsGroup

                    $SqlParameterList.Add($SqlParameter)
                }
                'LogMessageURL' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@LogMessageURL", [System.Data.SqlDbType]::VarChar, 200)
                    $SqlParameter.Value = $LogMessageURL

                    $SqlParameterList.Add($SqlParameter)
                }
                'LogMessagePriority' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@LogMessagePriority", [System.Data.SqlDbType]::TinyInt)
                    $SqlParameter.Value = $LogMessagePriority

                    $SqlParameterList.Add($SqlParameter)
                }
                'MemoryGrantThresholdPct' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@MemoryGrantThresholdPct", [System.Data.SqlDbType]::Decimal)
                    $SqlParameter.Precision = 5
                    $SqlParameter.Scale = 2
                    $SqlParameter.Value = $MemoryGrantThresholdPct

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputDatabaseName' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputType", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = 'None'

                    $SqlParameterList.Add($SqlParameter)

                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputDatabaseName", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputDatabaseName

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputResultSets' {
                    if ($OutputResultSets -NotContains 'Findings') {
                        $OutputResultSets += 'Findings'
                    }

                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputResultSets", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = [string]::Join('|', $OutputResultSets)

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputSchemaName' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputSchemaName", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputSchemaName

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputTableName' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputTableName", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputTableName

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputTableNameBlitzCache' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@BlitzCacheSkipAnalysis", [System.Data.SqlDbType]::TinyInt)
                    $SqlParameter.Value = 0

                    $SqlParameterList.Add($SqlParameter)

                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputTableNameBlitzCache", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputTableNameBlitzCache

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputTableNameBlitzWho' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputTableNameBlitzWho", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputTableNameBlitzWho

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputTableNameFileStats' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputTableNameFileStats", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputTableNameFileStats

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputTableNamePerfmonStats' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputTableNamePerfmonStats", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputTableNamePerfmonStats

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputTableNameWaitStats' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputTableNameWaitStats", [System.Data.SqlDbType]::NVarChar, 256)
                    $SqlParameter.Value = $OutputTableNameWaitStats

                    $SqlParameterList.Add($SqlParameter)
                }
                'OutputTableRetentionDays' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@OutputTableRetentionDays", [System.Data.SqlDbType]::TinyInt)
                    $SqlParameter.Value = $OutputTableRetentionDays

                    $SqlParameterList.Add($SqlParameter)
                }
                'Seconds' {
                    $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@Seconds", [System.Data.SqlDbType]::Int)
                    $SqlParameter.Value = $Seconds

                    $SqlParameterList.Add($SqlParameter)
                }
                'ShowSleepingSPIDs' {
                    if ($ShowSleepingSPIDs) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@ShowSleepingSPIDs", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'SinceStartup' {
                    if ($SinceStartup) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@SinceStartup", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'SkipCheckServerInfo' {
                    if ($SkipCheckServerInfo) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@CheckServerInfo", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 0

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                'VersionCheckMode' {
                    if ($VersionCheckMode) {
                        $SqlParameter = [Microsoft.Data.SqlClient.SqlParameter]::New("@VersionCheckMode", [System.Data.SqlDbType]::TinyInt)
                        $SqlParameter.Value = 1

                        $SqlParameterList.Add($SqlParameter)
                    }
                }
                Default {
                    $Parameter = $_

                    if ($Parameter -NotIn @('ServerInstance', 'DatabaseName', 'SqlConnection') -and $Parameter -NotIn $CommonParameters) {
                        throw [System.Management.Automation.ErrorRecord]::New(
                            [Exception]::New('Unknown parameter.'),
                            '1',
                            [System.Management.Automation.ErrorCategory]::InvalidType,
                            $Parameter
                        )
                    }
                }
            }
            #EndRegion

            $OutSqlParameterList = [System.Collections.Generic.List[Microsoft.Data.SqlClient.SqlParameter]]::New()

            $SqlClientDataSetParameters = @{
                'SqlConnection' = $SqlConnection
                'SqlCommandText' = $SqlCommandText
                'CommandType' = [System.Data.CommandType]::StoredProcedure
                'SqlParameter' = $SqlParameterList
                'OutSqlParameter' = $([ref]$OutSqlParameterList)
                'CommandTimeout' = 0
                'DataSetName' = $DataSetName
                'DataTableName' = $DataTableName
                'OutputAs' = 'DataSet'
            }

            if ($PSCmdlet.ShouldProcess($DataSetName, 'Get SQL dataset')) {
                $OutputDataset = Get-SqlClientDataSet @SqlClientDataSetParameters

                if ($PSCmdlet.ParameterSetName -in $DatabaseParameterSets) {
                    Disconnect-SqlServerInstance -SqlConnection $SqlConnection
                }
            }

            $BlitzVersion = [FirstResponderKit.BlitzVersion]::New($OutSqlParameterList.Where({$_.ParameterName -eq '@Version'}).Value, $OutSqlParameterList.Where({$_.ParameterName -eq '@VersionDate'}).Value)

            if ($OutputDataset.Tables.Count -gt 0) {
                if ($BlitzFirstSchema) {
                    #Region Schema
                    $DataTable = $OutputDataset.Tables

                    $ColumnNames = $DataTable.Columns.ColumnName

                    foreach ($DataRow in $DataTable.Rows) {
                        $SchemaObject = [FirstResponderKit.BlitzFirstSchema]::New($SqlInstanceName)

                        $SchemaObject.BlitzVersion = $BlitzVersion

                        $SchemaObject = $ConvertFromDataRowScriptBlock.Invoke($DataRow, $ColumnNames, $SchemaObject)[0]

                        $SchemaObject
                    }
                    #EndRegion
                } elseif ($BlitzFirstTop10) {
                    #Region Top 10
                    $DataTable = $OutputDataset.Tables

                    $ColumnNames = $DataTable.Columns.ColumnName

                    foreach ($DataRow in $DataTable.Rows) {
                        $BlitzFirstTop10Object = [FirstResponderKit.BlitzFirstTop10]::New($SqlInstanceName)

                        $BlitzFirstTop10Object.BlitzVersion = $BlitzVersion

                        switch ($ColumnNames) {
                            'Avg ms Per Wait' {
                                $ColumnName = $_

                                if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                    $BlitzFirstTop10Object.AvgMsPerWait = $DataRow.$ColumnName
                                }
                            }
                            'Hours Sample' {
                                $ColumnName = $_

                                if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                    $BlitzFirstTop10Object.HoursSample = $DataRow.$ColumnName
                                }
                            }
                            'Number of Waits' {
                                $ColumnName = $_

                                if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                    $BlitzFirstTop10Object.NumberOfWaits = $DataRow.$ColumnName
                                }
                            }
                            'Per Core Per Hour' {
                                $ColumnName = $_

                                if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                    $BlitzFirstTop10Object.PerCorePerHour = $DataRow.$ColumnName
                                }
                            }
                            'Thread Time (Hours)' {
                                $ColumnName = $_

                                if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                    $BlitzFirstTop10Object.ThreadTime = $DataRow.$ColumnName
                                }
                            }
                            'Wait Time (Hours)' {
                                $ColumnName = $_

                                if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                    $BlitzFirstTop10Object.WaitTime = $DataRow.$ColumnName
                                }
                            }
                            Default {
                                $ColumnName = $_

                                if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                    $BlitzFirstTop10Object.$ColumnName = $DataRow.$ColumnName
                                }
                            }
                        }

                        $BlitzFirstTop10Object
                    }
                    #EndRegion
                } elseif ($ExpertMode -or $SinceStartup) {
                    if ($ExpertMode) {
                        $BlitzFirstObject = [FirstResponderKit.BlitzFirstExpert]::New($SqlInstanceName)
                    } else {
                        $BlitzFirstObject = [FirstResponderKit.BlitzFirstSinceStartup]::New($SqlInstanceName)
                    }

                    $BlitzFirstObject.BlitzVersion = $BlitzVersion

                    $DataTableNumber = 0

                    #Region BlitzWho_Start
                    if ($ExpertMode -and $OutputResultSets -contains 'BlitzWho_Start') {
                        $DataTable = $OutputDataset.Tables[$DataTableNumber]

                        $ColumnNames = $DataTable.Columns.ColumnName

                        if ($DataTable.Rows.Count -gt 0) {
                            $BlitzWhoList = [System.Collections.Generic.List[FirstResponderKit.BlitzWho]]::New()

                            foreach ($DataRow in $DataTable.Rows) {
                                $BlitzWhoObject = [FirstResponderKit.BlitzWho]::New()

                                $BlitzWhoObject = $ConvertFromDataRowScriptBlock.Invoke($DataRow, $ColumnNames, $BlitzWhoObject)[0]

                                $BlitzWhoList.Add($BlitzWhoObject)
                            }

                            $BlitzFirstObject.BlitzWho_Start = $BlitzWhoList
                        }

                        $DataTableNumber++
                    }
                    #EndRegion

                    #Region Findings
                    if ($ExpertMode -and $OutputResultSets -contains 'Findings') {
                        $DataTable = $OutputDataset.Tables[$DataTableNumber]

                        $ColumnNames = $DataTable.Columns.ColumnName

                        if ($DataTable.Rows.Count -gt 0) {
                            $BlitzFirstExpertList = [System.Collections.Generic.List[FirstResponderKit.BlitzFirstExpertResult]]::New()

                            foreach ($DataRow in $DataTable.Rows) {
                                $FindingsObject = [FirstResponderKit.BlitzFirstExpertResult]::New()

                                $FindingsObject = $ConvertFromDataRowScriptBlock.Invoke($DataRow, $ColumnNames, $FindingsObject)[0]

                                $BlitzFirstExpertList.Add($FindingsObject)
                            }

                            $BlitzFirstObject.BlitzFirst = $BlitzFirstExpertList
                        }

                        $DataTableNumber++
                    }
                    #EndRegion

                    #Region WaitStats
                    if ($OutputResultSets -contains 'WaitStats') {
                        $DataTable = $OutputDataset.Tables[$DataTableNumber]

                        $ColumnNames = $DataTable.Columns.ColumnName

                        if ($DataTable.Rows.Count -gt 0) {
                            if ($ExpertMode) {
                                $WaitStatsList = [System.Collections.Generic.List[FirstResponderKit.WaitStats]]::New()
                            } else {
                                $WaitStatsList = [System.Collections.Generic.List[FirstResponderKit.WaitStatsSinceStartup]]::New()
                            }

                            foreach ($DataRow in $DataTable.Rows) {
                                if ($ExpertMode) {
                                    $WaitStatsObject = [FirstResponderKit.WaitStats]::New()
                                } else {
                                    $WaitStatsObject = [FirstResponderKit.WaitStatsSinceStartup]::New()
                                }

                                switch ($ColumnNames) {
                                    'Avg ms Per Wait' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.AvgMsPerWait = $DataRow.$ColumnName
                                        }
                                    }
                                    'Hours Sample' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.HoursSample = $DataRow.$ColumnName
                                        }
                                    }
                                    'Number of Waits' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.NumberOfWaits = $DataRow.$ColumnName
                                        }
                                    }
                                    'Per Core Per Hour' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.PerCorePerHour = $DataRow.$ColumnName
                                        }
                                    }
                                    'Per Core Per Second' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.PerCorePerSecond = $DataRow.$ColumnName
                                        }
                                    }
                                    'Percent Signal Waits' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.PercentSignalWaits = $DataRow.$ColumnName
                                        }
                                    }
                                    'Sample Ended' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.SampleEnded = $DataRow.$ColumnName
                                        }
                                    }
                                    'Seconds Sample' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.SecondsSample = $DataRow.$ColumnName
                                        }
                                    }
                                    'Signal Wait Time (Hours)' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.SignalWaitTime = $DataRow.$ColumnName
                                        }
                                    }
                                    'Signal Wait Time (Seconds)' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.SignalWaitTime = $DataRow.$ColumnName
                                        }
                                    }
                                    'Thread Time (Hours)' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.ThreadTime = $DataRow.$ColumnName
                                        }
                                    }
                                    'Total Thread Time (Seconds)' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.TotalThreadTime = $DataRow.$ColumnName
                                        }
                                    }
                                    'Wait Time (Hours)' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.WaitTime = $DataRow.$ColumnName
                                        }
                                    }
                                    'Wait Time (Seconds)' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.WaitTime = $DataRow.$ColumnName
                                        }
                                    }
                                    Default {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $WaitStatsObject.$ColumnName = $DataRow.$ColumnName
                                        }
                                    }
                                }

                                $WaitStatsList.Add($WaitStatsObject)
                            }

                            $BlitzFirstObject.WaitStats = $WaitStatsList
                        }

                        $DataTableNumber++
                    }
                    #EndRegion

                    #Region FileStats
                    if ($OutputResultSets -contains 'FileStats') {
                        $DataTable = $OutputDataset.Tables[$DataTableNumber]

                        $ColumnNames = $DataTable.Columns.ColumnName

                        if ($DataTable.Rows.Count -gt 0) {
                            $FileStatsList = [System.Collections.Generic.List[FirstResponderKit.FileStats]]::New()

                            foreach ($DataRow in $DataTable.Rows) {
                                $FileStatsObject = [FirstResponderKit.FileStats]::New()

                                switch ($ColumnNames) {
                                    '# Reads/Writes' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $FileStatsObject.NoReadsWrites = $DataRow.$ColumnName
                                        }
                                    }
                                    'Avg Stall (ms)' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $FileStatsObject.AvgStall = $DataRow.$ColumnName
                                        }
                                    }
                                    'File Name' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $FileStatsObject.FileName = $DataRow.$ColumnName
                                        }
                                    }
                                    'file physical name' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $FileStatsObject.FilePhysicalName = $DataRow.$ColumnName
                                        }
                                    }
                                    'MB Read/Written' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $FileStatsObject.MBReadWritten = $DataRow.$ColumnName
                                        }
                                    }
                                    'Sample (seconds)' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $FileStatsObject.Sample = $DataRow.$ColumnName
                                        }
                                    }
                                    'Sample Time' {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $FileStatsObject.SampleTime = $DataRow.$ColumnName
                                        }
                                    }
                                    Default {
                                        $ColumnName = $_

                                        if ($DataRow.$ColumnName -IsNot [System.DBNull]) {
                                            $FileStatsObject.$ColumnName = $DataRow.$ColumnName
                                        }
                                    }
                                }

                                $FileStatsList.Add($FileStatsObject)
                            }

                            $BlitzFirstObject.FileStats = $FileStatsList
                        }

                        $DataTableNumber++
                    }
                    #EndRegion

                    #Region PerfmonStats
                    if ($OutputResultSets -contains 'PerfmonStats') {
                        $DataTable = $OutputDataset.Tables[$DataTableNumber]

                        $ColumnNames = $DataTable.Columns.ColumnName

                        if ($DataTable.Rows.Count -gt 0) {
                            $PerfmonStatsList = [System.Collections.Generic.List[FirstResponderKit.PerfmonStats]]::New()

                            foreach ($DataRow in $DataTable.Rows) {
                                $PerfmonStatsObject = [FirstResponderKit.PerfmonStats]::New()

                                $PerfmonStatsObject = $ConvertFromDataRowScriptBlock.Invoke($DataRow, $ColumnNames, $PerfmonStatsObject)[0]

                                $PerfmonStatsList.Add($PerfmonStatsObject)
                            }

                            $BlitzFirstObject.PerfmonStats = $PerfmonStatsList
                        }

                        $DataTableNumber++
                    }
                    #EndRegion

                    #Region BlitzCache
                    if ($OutputResultSets -contains 'BlitzCache') {
                        if ($CheckProcedureCache) {
                            $DataTable = $OutputDataset.Tables[$DataTableNumber]

                            $ColumnNames = $DataTable.Columns.ColumnName

                            if ($DataTable.Rows.Count -gt 0) {
                                $BlitzCacheList = [System.Collections.Generic.List[FirstResponderKit.BlitzCache]]::New()

                                foreach ($DataRow in $DataTable.Rows) {
                                    $BlitzCacheObject = [FirstResponderKit.BlitzCache]::New()

                                    $BlitzCacheObject = $ConvertFromDataRowScriptBlock.Invoke($DataRow, $ColumnNames, $BlitzCacheObject)[0]

                                    $BlitzCacheList.Add($BlitzCacheObject)
                                }

                                $BlitzFirstObject.BlitzCache = $BlitzCacheList
                            }
                        }

                        $DataTableNumber++
                    }
                    #EndRegion

                    #Region BlitzWho_End
                    if ($ExpertMode -and $OutputResultSets -contains 'BlitzWho_End') {
                        $DataTable = $OutputDataset.Tables[$DataTableNumber]

                        $ColumnNames = $DataTable.Columns.ColumnName

                        if ($DataTable.Rows.Count -gt 0) {
                            $BlitzWhoList = [System.Collections.Generic.List[FirstResponderKit.BlitzWho]]::New()

                            foreach ($DataRow in $DataTable.Rows) {
                                $BlitzWhoObject = [FirstResponderKit.BlitzWho]::New()

                                $BlitzWhoObject = $ConvertFromDataRowScriptBlock.Invoke($DataRow, $ColumnNames, $BlitzWhoObject)[0]

                                $BlitzWhoList.Add($BlitzWhoObject)
                            }

                            $BlitzFirstObject.BlitzWho_End = $BlitzWhoList
                        }

                        $DataTableNumber++
                    }
                    #EndRegion

                    $BlitzFirstObject
                } else {
                    #Region BlitzFirst Default
                    $DataTable = $OutputDataset.Tables

                    $ColumnNames = $DataTable.Columns.ColumnName

                    foreach ($DataRow in $DataTable.Rows) {
                        $FindingsObject = [FirstResponderKit.BlitzFirst]::New($SqlInstanceName)

                        $FindingsObject.BlitzVersion = $BlitzVersion

                        $FindingsObject = $ConvertFromDataRowScriptBlock.Invoke($DataRow, $ColumnNames, $FindingsObject)[0]

                        $FindingsObject
                    }
                    #EndRegion
                }
            } else {
                if ($VersionCheckMode) {
                    $BlitzVersion
                }
            }

            if ($PSCmdlet.ParameterSetName -in $DatabaseParameterSets) {
                Disconnect-SqlServerInstance -SqlConnection $SqlConnection
            }
        }
        catch {
            throw $_
        }
        finally {
            if (Test-Path -Path variable:\SqlCommand) {
                $SqlCommand.Dispose()
            }

            if ($PSCmdlet.ParameterSetName -in $DatabaseParameterSets) {
                Disconnect-SqlServerInstance -SqlConnection $SqlConnection
            }
        }
    }

    END {
    }
}