Cookbook Scripts

Cookbook Scripts

This section contains various SQL, PowerShell, VBScript, and CMD scripts to perform various tasks.

Collect the Connectivity Ring Buffer

Determine If I Am Connected to SQL Server using Kerberos Authentication

Determine I have Delegatable Credentials in my ASPX Web Site

Enumerate SQL Server Instances and TCP Settings

One-Line PowerShell Scripts

Description	Command
Can the server be reached	Test-NetConnection sqlprod01.contoso.com -port 1433
List Jumbo Frames Settings	Get-NetAdapterAdvancedProperty You can also see this in the SQLCheck output
Turn Jumbo Frames On	Set-NetAdapterAdvancedProperty -Name "Ethernet 2" -RegistryKeyword "JumboPacket" -RegistryValue "2"
Turn Jumbo Frames Off	Set-NetAdapterAdvancedProperty -Name "Ethernet 2" -RegistryKeyword "JumboPacket" -RegistryValue "0"